Your Web News in One Place

Help Webnuz

Referal links:

Sign up for GreenGeeks web hosting
August 15, 2021 02:27 pm GMT

Installing Oracle 21c Database on Linux [Single Instance]

After some time of been available on the cloud, 21c Database is now ready to install on premises (Linux version for now)

@GeraldVenzl - Aug 13

Alt Text

You can read more about it from the usual suspects like Mike's blog:
Oracle Database 21c is available for download on Linux



The first thing we need to do is to download the Database Software

Oracle Database 21c Download for Linux x86-64

Alt Text

We are assuming here the server is ready for 21c Database installation (I'm using one of the Labs servers were I have 19c installed) but if you are creating the server from the scratch, remember to use the preinstall RPM to make sure the system is ready:
Running RPM Packages to Install Oracle Database

Once is downloaded into your server, create the 21c Oracle Home folder and extract the zip file in it

[oracle@rac1-node1 ~]$ mkdir -p /u01/app/oracle/product/21.0.0/dbhome_1[oracle@rac1-node1 ~]$ cd /u01/app/oracle/product/21.0.0/dbhome_1[oracle@rac1-node1 db_home1]$ unzip /tmp/LINUX.X64_213000_db_home.zip Archive:  /tmp/LINUX.X64_213000_db_home.zip   creating: addnode/  inflating: addnode/addnode.sh        inflating: addnode/addnode_oraparam.ini.sbs    inflating: addnode/addnode_oraparam.ini    inflating: addnode/addnode.pl  [....][oracle@rac1-node1 db_home1]$ 

Now that we have the software located on our server, lets install the software using runInstaller with the INSTALL_DB_SWONLY option.
Remember to execute the root.sh script as root after finishing it:

[oracle@rac1-node1 dbhome_1]$ ./runInstaller -silent -responseFile /u01/app/oracle/product/21.0.0/dbhome_1/install/response/db_install.rsp \oracle.install.option=INSTALL_DB_SWONLY \UNIX_GROUP_NAME=oinstall \ORACLE_BASE=/u01/app/oracle \INVENTORY_LOCATION=/u01/app/oraInventory  \SELECTED_LANGUAGES=en \oracle.install.db.InstallEdition=EE \oracle.install.db.isCustomInstall=false \oracle.install.db.OSDBA_GROUP=oinstall \oracle.install.db.OSBACKUPDBA_GROUP=oinstall \oracle.install.db.OSDGDBA_GROUP=oinstall \oracle.install.db.OSKMDBA_GROUP=oinstall \oracle.install.db.OSRACDBA_GROUP=oinstall \SECURITY_UPDATES_VIA_MYORACLESUPPORT=false \DECLINE_SECURITY_UPDATES=trueLaunching Oracle Database Setup Wizard...[WARNING] [INS-13014] Target environment does not meet some optional requirements.   CAUSE: Some of the optional prerequisites are not met. See logs for details. /u01/app/oraInventory/logs/InstallActions2021-08-15_01-56-35PM/installActions2021-08-15_01-56-35PM.log   ACTION: Identify the list of failed prerequisite checks from the log: /u01/app/oraInventory/logs/InstallActions2021-08-15_01-56-35PM/installActions2021-08-15_01-56-35PM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually.The response file for this session can be found at: /u01/app/oracle/product/21.0.0/dbhome_1/install/response/db_2021-08-15_01-56-35PM.rspYou can find the log of this install session at: /u01/app/oraInventory/logs/InstallActions2021-08-15_01-56-35PM/installActions2021-08-15_01-56-35PM.logAs a root user, execute the following script(s):    1. /u01/app/oracle/product/21.0.0/dbhome_1/root.shExecute /u01/app/oracle/product/21.0.0/dbhome_1/root.sh on the following nodes: [rac1-node1]Successfully Setup Software with warning(s).[oracle@rac1-node1 dbhome_1]$ [oracle@rac1-node1 dbhome_1]$ su -Password: [root@rac1-node1 ~]# /u01/app/oracle/product/21.0.0/dbhome_1/root.sh Check /u01/app/oracle/product/21.0.0/dbhome_1/install/root_rac1-node1.raclab.local_2021-08-15_14-03-18-085643579.log for the output of root script[root@rac1-node1 ~]# 

Let's now create a single instance Database on Filesystem

[oracle@rac1-node1 ~]$ . oraenvORACLE_SID = [oracle] ? cdb21ORACLE_HOME = [/home/oracle] ? /u01/app/oracle/product/21.0.0/dbhome_1The Oracle base has been set to /u01/app/oracle[oracle@rac1-node1 ~]$ [oracle@rac1-node1 ~]$ dbca -silent -createDatabase                     \-templateName General_Purpose.dbc                \-gdbname cdb21                                   \-sid cdb21                                       \-responseFile NO_VALUE                           \-characterSet AL32UTF8                           \-sysPassword Welcome1                            \-systemPassword Welcome1                         \-createAsContainerDatabase true                  \-numberOfPDBs 1                                  \-pdbName pdb21                                   \-pdbAdminPassword Welcome1                       \-databaseType MULTIPURPOSE                       \-memoryMgmtType auto_sga                         \-totalMemory 4096                                \-storageType FS                                  \-datafileDestination /u01/oradata/               \-emConfiguration NONE                            \-ignorePreReqs Prepare for db operation8% complete[....]58% complete77% completeExecuting Post Configuration Actions100% completeDatabase creation complete. For details check the logfiles at: /u01/app/oracle/cfgtoollogs/dbca/cdb21.Database Information:Global Database Name:cdb21System Identifier(SID):cdb21Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/cdb21/cdb211.log" for further details.

And voil! our new 21c Database is ready for testing

[oracle@rac1-node1 ~]$ sqlplus / as sysdbaSQL*Plus: Release 21.0.0.0.0 - Production on Sun Aug 15 14:39:16 2021Version 21.3.0.0.0Copyright (c) 1982, 2021, Oracle.  All rights reserved.Connected to:Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - ProductionVersion 21.3.0.0.0SQL> SELECT NAME as DB_NAME, HOST_NAME, DATABASE_ROLE, OPEN_MODE, status from GV$INSTANCE, V$DATABASE;DB_NAME   HOST_NAME               DATABASE_ROLE    OPEN_MODE        STATUS--------- ----------------------------------- ---------------- -------------------- ------------CDB21     rac1-node1.raclab.local         PRIMARY          READ WRITE       OPENSQL> SELECT d.CON_ID, v.name, v.open_modeFROM gv$pdbs v, dba_pdbs d WHERE v.guid = d.guidORDER BY 1;    CON_ID NAME         OPEN_MODE---------- -------------------- ----------     2 PDB$SEED     READ ONLY     3 PDB21        READ WRITESQL> 

Like Tim have already mentioned, please don't use 21c unless is for your testing and to learn what new features are coming to the long term support releases (current one is 19c and next one should be 23c)


Original Link: https://dev.to/project42/installing-oracle-21c-database-on-linux-single-instance-1cn

Share this article:    Share on Facebook
View Full Article

Dev To

An online community for sharing and discovering great ideas, having debates, and making friends

More About this Source Visit Dev To