Installing Oracle 12c Release 2 (12.2) RAC on VirtualBox – silent installation – Part 4
Posted by Balazs Papp on 2017-03-20
With a working 12c Release 2 (12.2) Grid Infrastructure cluster, the only remaining tasks left are installing the database software and creating a database.
Part 1 – https://balazspapp.wordpress.com/2017/03/19/installing-oracle-12c-release-2-12-2-rac-on-virtualbox-silent-installation-part-1/
Part 2 – https://balazspapp.wordpress.com/2017/03/19/installing-oracle-12c-release-2-12-2-rac-on-virtualbox-silent-installation-part-2/
Part 3 – https://balazspapp.wordpress.com/2017/03/20/installing-oracle-12c-release-2-12-2-rac-on-virtualbox-silent-installation-part-3/
Part 4 – https://balazspapp.wordpress.com/2017/03/20/installing-oracle-12c-release-2-12-2-rac-on-virtualbox-silent-installation-part-4/
As usual, prepare a responsefile for installing the database:
[oracle@rac1 ~]$ cp /install/database/response/db_install.rsp . [oracle@rac1 ~]$ vi db_install.rsp
Set the below parameters:
oracle.install.option=INSTALL_DB_SWONLY UNIX_GROUP_NAME=oinstall INVENTORY_LOCATION=/u01/app/oraInventory ORACLE_HOME=/u01/app/oracle/product/12.2.0/dbhome_1 ORACLE_BASE=/u01/app/oracle oracle.install.db.InstallEdition=EE oracle.install.db.OSDBA_GROUP=dba oracle.install.db.OSOPER_GROUP=dba oracle.install.db.OSBACKUPDBA_GROUP=dba oracle.install.db.OSDGDBA_GROUP=dba oracle.install.db.OSKMDBA_GROUP=dba oracle.install.db.CLUSTER_NODES=rac1,rac2 DECLINE_SECURITY_UPDATES=true
Here is my working version of the responsefile I used for this installation: http://pastebin.com/4WJLQfTQ
[oracle@rac1 ~]$ /install/database/runInstaller -silent -responsefile /home/oracle/db_install.rsp -showProgress -waitforcompletion Starting Oracle Universal Installer... Checking Temp space: must be greater than 500 MB. Actual 79997 MB Passed Checking swap space: must be greater than 150 MB. Actual 10231 MB Passed Preparing to launch Oracle Universal Installer from /tmp/OraInstall2017-03-19_11-27-14PM. Please wait ...You can find the log of this install session at: /u01/app/oraInventory/logs/installActions2017-03-19_11-27-14PM.log Prepare in progress. .................................................. 7% Done. Prepare successful. Copy files in progress. .................................................. 14% Done. .................................................. 20% Done. .................................................. 25% Done. .................................................. 30% Done. .................................................. 36% Done. .................................................. 45% Done. .................................................. 50% Done. .................................................. 55% Done. .................................................. 60% Done. .................................................. 65% Done. .......... Copy files successful. Link binaries in progress. .................... Link binaries successful. Setup files in progress. .................... Setup files successful. Setup Inventory in progress. Setup Inventory successful. Finish Setup successful. The installation of Oracle Database 12c was successful. Please check '/u01/app/oraInventory/logs/silentInstall2017-03-19_11-27-14PM.log' for more details. Copy Files to Remote Nodes in progress. .................................................. 70% Done. .................................................. 75% Done. .................................................. 80% Done. .................................................. 85% Done. Copy Files to Remote Nodes successful. Prepare in progress. Prepare successful. .......... Setup in progress. .................... Setup successful. The Cluster Node Addition of /u01/app/oracle/product/12.2.0/dbhome_1 was successful. Please check '/u01/app/oraInventory/logs/silentInstall2017-03-19_11-27-14PM.log' for more details. Setup Oracle Base in progress. Setup Oracle Base successful. .................................................. 97% Done. As a root user, execute the following script(s): 1. /u01/app/oracle/product/12.2.0/dbhome_1/root.sh Execute /u01/app/oracle/product/12.2.0/dbhome_1/root.sh on the following nodes: [rac1, rac2] .................................................. 100% Done. Successfully Setup Software.
Running the root script on both nodes:
[root@rac1 ~]# /u01/app/oracle/product/12.2.0/dbhome_1/root.sh Check /u01/app/oracle/product/12.2.0/dbhome_1/install/root_rac1_2017-03-19_23-35-53-426886840.log for the output of root script [root@rac2 ~]# /u01/app/oracle/product/12.2.0/dbhome_1/root.sh Check /u01/app/oracle/product/12.2.0/dbhome_1/install/root_rac2_2017-03-19_23-36-09-240372119.log for the output of root script
Finally, the database can be created. While in general, using the “General Purpose” template is not recommended, this is still the quickest method for creating a database, so for the sake of simplicity, the below command creates a database using the “General Purpose” template:
[oracle@rac1 ~]$ /u01/app/oracle/product/12.2.0/dbhome_1/bin/dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName ORCL -characterSet AL32UTF8 -databaseConfigType RAC -datafileDestination +DATA -totalMemory 1024 -nationalCharacterSet AL16UTF16 -nodelist rac1,rac2 -adminManaged -recoveryAreaDestination +FRA -recoveryAreaSize 20480 -sid ORCL -sysPassword Oracle123 -systemPassword Oracle123 -useOMF true Copying database files 1% complete 2% complete 15% complete 27% complete Creating and starting Oracle instance 29% complete 32% complete 36% complete 40% complete 41% complete 43% complete 45% complete Creating cluster database views 47% complete 63% complete Completing Database Creation 64% complete 65% complete 68% complete 70% complete 72% complete Executing Post Configuration Actions 100% complete Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/ORCL/ORCL.log" for further details.
Once it is complete, check the status:
[oracle@rac1 ~]$ . oraenv ORACLE_SID = [oracle] ? +ASM1 The Oracle base has been set to /u01/app/oracle [oracle@rac1 ~]$ srvctl status database -database ORCL Instance ORCL1 is running on node rac1 Instance ORCL2 is running on node rac2 [oracle@rac1 ~]$ ps -ef | grep tns root 15 2 0 20:35 ? 00:00:00 [netns] oracle 1240 1 0 22:21 ? 00:00:00 /u01/app/12.2.0/grid/bin/tnslsnr LISTENER -no_crs_notify -inherit oracle 7753 26350 0 23:54 pts/2 00:00:00 grep --color=auto tns oracle 27746 1 0 23:06 ? 00:00:00 /u01/app/12.2.0/grid/bin/tnslsnr MGMTLSNR -no_crs_notify -inherit oracle 29754 1 0 22:20 ? 00:00:01 /u01/app/12.2.0/grid/bin/tnslsnr ASMNET1LSNR_ASM -no_crs_notify -inherit oracle 30142 1 0 22:20 ? 00:00:00 /u01/app/12.2.0/grid/bin/tnslsnr LISTENER_SCAN2 -no_crs_notify -inherit oracle 30171 1 0 22:20 ? 00:00:00 /u01/app/12.2.0/grid/bin/tnslsnr LISTENER_SCAN3 -no_crs_notify -inherit [oracle@rac1 ~]$ lsnrctl status LISTENER_SCAN2 LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 19-MAR-2017 23:55:04 Copyright (c) 1991, 2016, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2))) STATUS of the LISTENER ------------------------ Alias LISTENER_SCAN2 Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production Start Date 19-MAR-2017 22:20:34 Uptime 0 days 1 hr. 34 min. 30 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/12.2.0/grid/network/admin/listener.ora Listener Log File /u01/app/oracle/diag/tnslsnr/rac1/listener_scan2/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN2))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.16.1.106)(PORT=1521))) Services Summary... Service "-MGMTDBXDB" has 1 instance(s). Instance "-MGMTDB", status READY, has 1 handler(s) for this service... Service "4b1da3d3f1dc7469e053650110acd0dc" has 1 instance(s). Instance "-MGMTDB", status READY, has 1 handler(s) for this service... Service "ORCL" has 2 instance(s). Instance "ORCL1", status READY, has 1 handler(s) for this service... Instance "ORCL2", status READY, has 1 handler(s) for this service... Service "ORCLXDB" has 2 instance(s). Instance "ORCL1", status READY, has 1 handler(s) for this service... Instance "ORCL2", status READY, has 1 handler(s) for this service... Service "_mgmtdb" has 1 instance(s). Instance "-MGMTDB", status READY, has 1 handler(s) for this service... Service "gimr_dscrep_10" has 1 instance(s). Instance "-MGMTDB", status READY, has 1 handler(s) for this service... The command completed successfully
Log in using the SCAN address:
[oracle@rac1 ~]$ sqlplus sys/Oracle123@\'rac-scan:1521/ORCL\' as sysdba SQL*Plus: Release 12.2.0.1.0 Production on Sun Mar 19 23:56:50 2017 Copyright (c) 1982, 2016, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production SQL> show user USER is "SYS" SQL>
And this concludes this walkthrough.
MP said
Excellent work. Followed the documents from start to finish ans created the 12cR2 RAC database.
MP