Description:-
In this article let us configure Oracle 12cR1 One Node RAC. Below is the server details we are going to configure.
High Level Steps:-
1) Pre-requisites for RAC Installation
2) SSH Configuration and running runcluvfy
3) Grid Infrastructure Installation
4) Database Binaries Installation
5) One Node RAC Database Creation
Pre-requisites for RAC Installation:-
Below is the ip-details of the public, private, virtual and scan configuration.
$ cat /etc/hosts 127.0.0.1 localhost.localdomain localhost #Public IP 192.168.1.211 prodrac101.oracledbwr.com prodrac101 192.168.1.212 prodrac102.oracledbwr.com prodrac102 #Private IP 192.168.2.211 prodprv101.oracledbwr.com prodprv101 192.168.2.212 prodprv102.oracledbwr.com prodprv102 #Virtual IP 192.168.1.214 prodvip101.oracledbwr.com prodvip101 192.168.1.215 prodvip102.oracledbwr.com prodvip102 #Scan IP 192.168.1.218 prodscn101.oracledbwr.com prodscn101 192.168.1.219 prodscn101.oracledbwr.com prodscn101 192.168.1.220 prodscn101.oracledbwr.com prodscn101
The pre-requisites steps involved in One Node RAC installation is similar to normal two node RAC installation. You can refer here for the OS configuration and pre-requisites need to be done for One Node RAC installation(Follow upto Step 79 for OS configuration and pre-requisites).
SSH Configuration and running runcluvfy:-
Login into NODE1/NODE2 as oracle:
$ cd <path-to-grid-software>/sshsetup $ ./sshUserSetup.sh -user oracle -hosts "prodrac101 prodrac102" -noPromptPassphrase
Run the above command in both the servers of the cluster we are going to configure One Node RAC.
Once the ssh is configured successfully, execute the runcluvfy to check whether all the pre-requisite for RAC installation has been done perfectly.
$ cd <path-to-grid-software>/ $ ./runcluvfy.sh stage -pre crsinst -n prodrac101,prodrac102 -r 12cR1 -orainv oinstall -fixup -verbose
Please check here for the cluvfy output.
Grid Infrastructure Installation:-
When the cluvfy completed successfully, follow the below steps for the Oracle 12cR1 grid installation. Go to the unzipped directory of the grid software and start the grid installation by executing the runInstaller.
$ cd <path-to-grid-software>/
$ ./runInstaller
Here, provide a cluster name and the scan-name of the cluster.
As similar to normal two node RAC installation, provide the public and virtual ip address name’s of the servers in the below page of the configuration.
Select a diskgroup where we need to place the OCR and voting disk of the cluster.
$ sh /oradb/app/oraInventory/orainstRoot.sh Changing permissions of /oradb/app/oraInventory. Adding read,write permissions for group. Removing read,write,execute permissions for world. Changing groupname of /oradb/app/oraInventory to oinstall. The execution of the script is complete.
Node 1:-
$ sh /oradb/app/12.1.0.2/grid/root.sh Performing root user operation. The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /oradb/app/12.1.0.2/grid Enter the full pathname of the local bin directory: [/usr/local/bin]: Copying dbhome to /usr/local/bin ... Copying oraenv to /usr/local/bin ... Copying coraenv to /usr/local/bin ... Creating /etc/oratab file... Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root script. Now product-specific root actions will be performed. Using configuration parameter file: /oradb/app/12.1.0.2/grid/crs/install/crsconfig_params 2018/09/01 22:25:44 CLSRSC-4001: Installing Oracle Trace File Analyzer (TFA) Collector. 2018/09/01 22:26:14 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector. OLR initialization - successful root wallet root wallet cert root cert export peer wallet profile reader wallet pa wallet peer wallet keys pa wallet keys peer cert request pa cert request peer cert pa cert peer root cert TP profile reader root cert TP pa root cert TP peer pa cert TP pa peer cert TP profile reader pa cert TP profile reader peer cert TP peer user cert pa user cert 2018/09/01 22:27:02 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.conf' CRS-4133: Oracle High Availability Services has been stopped. CRS-4123: Oracle High Availability Services has been started. CRS-4133: Oracle High Availability Services has been stopped. CRS-4123: Oracle High Availability Services has been started. CRS-2672: Attempting to start 'ora.evmd' on 'prodrac101' CRS-2672: Attempting to start 'ora.mdnsd' on 'prodrac101' CRS-2676: Start of 'ora.mdnsd' on 'prodrac101' succeeded CRS-2676: Start of 'ora.evmd' on 'prodrac101' succeeded CRS-2672: Attempting to start 'ora.gpnpd' on 'prodrac101' CRS-2676: Start of 'ora.gpnpd' on 'prodrac101' succeeded CRS-2672: Attempting to start 'ora.cssdmonitor' on 'prodrac101' CRS-2672: Attempting to start 'ora.gipcd' on 'prodrac101' CRS-2676: Start of 'ora.cssdmonitor' on 'prodrac101' succeeded CRS-2676: Start of 'ora.gipcd' on 'prodrac101' succeeded CRS-2672: Attempting to start 'ora.cssd' on 'prodrac101' CRS-2672: Attempting to start 'ora.diskmon' on 'prodrac101' CRS-2676: Start of 'ora.diskmon' on 'prodrac101' succeeded CRS-2676: Start of 'ora.cssd' on 'prodrac101' succeeded ASM created and started successfully. Disk Group DBWR_DATA created successfully. CRS-2672: Attempting to start 'ora.crf' on 'prodrac101' CRS-2672: Attempting to start 'ora.storage' on 'prodrac101' CRS-2676: Start of 'ora.storage' on 'prodrac101' succeeded CRS-2676: Start of 'ora.crf' on 'prodrac101' succeeded CRS-2672: Attempting to start 'ora.crsd' on 'prodrac101' CRS-2676: Start of 'ora.crsd' on 'prodrac101' succeeded CRS-4256: Updating the profile Successful addition of voting disk de3a592de9eb4feabf9fb4121f96c1ae. Successfully replaced voting disk group with +DBWR_DATA. CRS-4256: Updating the profile CRS-4266: Voting file(s) successfully replaced ## STATE File Universal Id File Name Disk group -- ----- ----------------- --------- --------- 1. ONLINE de3a592de9eb4feabf9fb4121f96c1ae (ORCL:DBWR_DATA) [DBWR_DATA] Located 1 voting disk(s). CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'prodrac101' CRS-2673: Attempting to stop 'ora.crsd' on 'prodrac101' CRS-2677: Stop of 'ora.crsd' on 'prodrac101' succeeded CRS-2673: Attempting to stop 'ora.evmd' on 'prodrac101' CRS-2673: Attempting to stop 'ora.storage' on 'prodrac101' CRS-2673: Attempting to stop 'ora.mdnsd' on 'prodrac101' CRS-2673: Attempting to stop 'ora.gpnpd' on 'prodrac101' CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'prodrac101' CRS-2677: Stop of 'ora.storage' on 'prodrac101' succeeded CRS-2677: Stop of 'ora.drivers.acfs' on 'prodrac101' succeeded CRS-2677: Stop of 'ora.evmd' on 'prodrac101' succeeded CRS-2673: Attempting to stop 'ora.crf' on 'prodrac101' CRS-2673: Attempting to stop 'ora.ctssd' on 'prodrac101' CRS-2673: Attempting to stop 'ora.asm' on 'prodrac101' CRS-2677: Stop of 'ora.mdnsd' on 'prodrac101' succeeded CRS-2677: Stop of 'ora.gpnpd' on 'prodrac101' succeeded CRS-2677: Stop of 'ora.crf' on 'prodrac101' succeeded CRS-2677: Stop of 'ora.ctssd' on 'prodrac101' succeeded CRS-2677: Stop of 'ora.asm' on 'prodrac101' succeeded CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'prodrac101' CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'prodrac101' succeeded CRS-2673: Attempting to stop 'ora.cssd' on 'prodrac101' CRS-2677: Stop of 'ora.cssd' on 'prodrac101' succeeded CRS-2673: Attempting to stop 'ora.gipcd' on 'prodrac101' CRS-2677: Stop of 'ora.gipcd' on 'prodrac101' succeeded CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'prodrac101' has completed CRS-4133: Oracle High Availability Services has been stopped. CRS-4123: Starting Oracle High Availability Services-managed resources CRS-2672: Attempting to start 'ora.mdnsd' on 'prodrac101' CRS-2672: Attempting to start 'ora.evmd' on 'prodrac101' CRS-2676: Start of 'ora.mdnsd' on 'prodrac101' succeeded CRS-2676: Start of 'ora.evmd' on 'prodrac101' succeeded CRS-2672: Attempting to start 'ora.gpnpd' on 'prodrac101' CRS-2676: Start of 'ora.gpnpd' on 'prodrac101' succeeded CRS-2672: Attempting to start 'ora.gipcd' on 'prodrac101' CRS-2676: Start of 'ora.gipcd' on 'prodrac101' succeeded CRS-2672: Attempting to start 'ora.cssdmonitor' on 'prodrac101' CRS-2676: Start of 'ora.cssdmonitor' on 'prodrac101' succeeded CRS-2672: Attempting to start 'ora.cssd' on 'prodrac101' CRS-2672: Attempting to start 'ora.diskmon' on 'prodrac101' CRS-2676: Start of 'ora.diskmon' on 'prodrac101' succeeded CRS-2676: Start of 'ora.cssd' on 'prodrac101' succeeded CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'prodrac101' CRS-2672: Attempting to start 'ora.ctssd' on 'prodrac101' CRS-2676: Start of 'ora.ctssd' on 'prodrac101' succeeded CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'prodrac101' succeeded CRS-2672: Attempting to start 'ora.asm' on 'prodrac101' CRS-2676: Start of 'ora.asm' on 'prodrac101' succeeded CRS-2672: Attempting to start 'ora.storage' on 'prodrac101' CRS-2676: Start of 'ora.storage' on 'prodrac101' succeeded CRS-2672: Attempting to start 'ora.crf' on 'prodrac101' CRS-2676: Start of 'ora.crf' on 'prodrac101' succeeded CRS-2672: Attempting to start 'ora.crsd' on 'prodrac101' CRS-2676: Start of 'ora.crsd' on 'prodrac101' succeeded CRS-6023: Starting Oracle Cluster Ready Services-managed resources CRS-6017: Processing resource auto-start for servers: prodrac101 CRS-6016: Resource auto-start has completed for server prodrac101 CRS-6024: Completed start of Oracle Cluster Ready Services-managed resources CRS-4123: Oracle High Availability Services has been started. 2018/09/01 22:33:42 CLSRSC-343: Successfully started Oracle Clusterware stack CRS-2672: Attempting to start 'ora.asm' on 'prodrac101' CRS-2676: Start of 'ora.asm' on 'prodrac101' succeeded CRS-2672: Attempting to start 'ora.DBWR_DATA.dg' on 'prodrac101' CRS-2676: Start of 'ora.DBWR_DATA.dg' on 'prodrac101' succeeded 2018/09/01 22:35:24 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded
Node 2:-
$ sh /oradb/app/12.1.0.2/grid/root.sh Performing root user operation. The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /oradb/app/12.1.0.2/grid Enter the full pathname of the local bin directory: [/usr/local/bin]: Copying dbhome to /usr/local/bin ... Copying oraenv to /usr/local/bin ... Copying coraenv to /usr/local/bin ... Creating /etc/oratab file... Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root script. Now product-specific root actions will be performed. Using configuration parameter file: /oradb/app/12.1.0.2/grid/crs/install/crsconfig_params 2018/09/01 22:45:47 CLSRSC-4001: Installing Oracle Trace File Analyzer (TFA) Collector. 2018/09/01 22:46:16 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector. OLR initialization - successful 2018/09/01 22:47:40 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.conf' CRS-4133: Oracle High Availability Services has been stopped. CRS-4123: Oracle High Availability Services has been started. CRS-4133: Oracle High Availability Services has been stopped. CRS-4123: Oracle High Availability Services has been started. CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'prodrac102' CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'prodrac102' CRS-2677: Stop of 'ora.drivers.acfs' on 'prodrac102' succeeded CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'prodrac102' has completed CRS-4133: Oracle High Availability Services has been stopped. CRS-4123: Starting Oracle High Availability Services-managed resources CRS-2672: Attempting to start 'ora.mdnsd' on 'prodrac102' CRS-2672: Attempting to start 'ora.evmd' on 'prodrac102' CRS-2676: Start of 'ora.evmd' on 'prodrac102' succeeded CRS-2676: Start of 'ora.mdnsd' on 'prodrac102' succeeded CRS-2672: Attempting to start 'ora.gpnpd' on 'prodrac102' CRS-2676: Start of 'ora.gpnpd' on 'prodrac102' succeeded CRS-2672: Attempting to start 'ora.gipcd' on 'prodrac102' CRS-2676: Start of 'ora.gipcd' on 'prodrac102' succeeded CRS-2672: Attempting to start 'ora.cssdmonitor' on 'prodrac102' CRS-2676: Start of 'ora.cssdmonitor' on 'prodrac102' succeeded CRS-2672: Attempting to start 'ora.cssd' on 'prodrac102' CRS-2672: Attempting to start 'ora.diskmon' on 'prodrac102' CRS-2676: Start of 'ora.diskmon' on 'prodrac102' succeeded CRS-2676: Start of 'ora.cssd' on 'prodrac102' succeeded CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'prodrac102' CRS-2672: Attempting to start 'ora.ctssd' on 'prodrac102' CRS-2676: Start of 'ora.ctssd' on 'prodrac102' succeeded CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'prodrac102' succeeded CRS-2672: Attempting to start 'ora.asm' on 'prodrac102' CRS-2676: Start of 'ora.asm' on 'prodrac102' succeeded CRS-2672: Attempting to start 'ora.storage' on 'prodrac102' CRS-2676: Start of 'ora.storage' on 'prodrac102' succeeded CRS-2672: Attempting to start 'ora.crf' on 'prodrac102' CRS-2676: Start of 'ora.crf' on 'prodrac102' succeeded CRS-2672: Attempting to start 'ora.crsd' on 'prodrac102' CRS-2676: Start of 'ora.crsd' on 'prodrac102' succeeded CRS-6017: Processing resource auto-start for servers: prodrac102 CRS-2672: Attempting to start 'ora.net1.network' on 'prodrac102' CRS-2676: Start of 'ora.net1.network' on 'prodrac102' succeeded CRS-2672: Attempting to start 'ora.ons' on 'prodrac102' CRS-2676: Start of 'ora.ons' on 'prodrac102' succeeded CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'prodrac101' CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'prodrac101' succeeded CRS-2673: Attempting to stop 'ora.scan1.vip' on 'prodrac101' CRS-2677: Stop of 'ora.scan1.vip' on 'prodrac101' succeeded CRS-2672: Attempting to start 'ora.scan1.vip' on 'prodrac102' CRS-2676: Start of 'ora.scan1.vip' on 'prodrac102' succeeded CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'prodrac102' CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on 'prodrac102' succeeded CRS-6016: Resource auto-start has completed for server prodrac102 CRS-6024: Completed start of Oracle Cluster Ready Services-managed resources CRS-4123: Oracle High Availability Services has been started. 2018/09/01 22:52:27 CLSRSC-343: Successfully started Oracle Clusterware stack 2018/09/01 22:52:44 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded
Database Binaries Installation:-
Let us start the Oracle 12cR1 database software installation.
In the below page, select the third option whereas we are configuring One Node RAC installation.
$ sh /oradb/app/oraInventory/orainstRoot.sh Changing permissions of /oradb/app/oraInventory. Adding read,write permissions for group. Removing read,write,execute permissions for world. Changing groupname of /oradb/app/oraInventory to oinstall. The execution of the script is complete.
Node 1:-
$ sh /oradb/app/oracle/product/12.1.0.2/db_1/root.sh Performing root user operation. The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /oradb/app/oracle/product/12.1.0.2/db_1 Enter the full pathname of the local bin directory: [/usr/local/bin]: The contents of "dbhome" have not changed. No need to overwrite. The contents of "oraenv" have not changed. No need to overwrite. The contents of "coraenv" have not changed. No need to overwrite. Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root script. Now product-specific root actions will be performed.
Node 2:-
sh /oradb/app/oracle/product/12.1.0.2/db_1/root.sh Performing root user operation. The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /oradb/app/oracle/product/12.1.0.2/db_1 Enter the full pathname of the local bin directory: [/usr/local/bin]: The contents of "dbhome" have not changed. No need to overwrite. The contents of "oraenv" have not changed. No need to overwrite. The contents of "coraenv" have not changed. No need to overwrite. Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root script. Now product-specific root actions will be performed.
One Node RAC Database Creation:-
After completing the Oracle 12cR1 database binaries installation, go to the bin directory and start dbca for database creation.
Once the one node RAC installation and database creation is complete, check the database configuration and in which node the database is running by the below commands.
$ srvctl config database -d ORCL
Database unique name: ORCL
Database name: ORCL
Oracle home: /oradb/app/oracle/product/12.1.0.2/db_1
Oracle user: oracle
Spfile: +DBWR_DATA/ORCL/PARAMETERFILE/spfile.278.985981865
Password file: +DBWR_DATA/ORCL/PASSWORD/pwdorcl.276.985981257
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: ORCLPOOL
Disk Groups: DBWR_FRA,DBWR_DATA
Mount point paths:
Services: ORCL.oracledbwr.com
Type: RACOneNode
Online relocation timeout: 30
Instance name prefix: ORCL
Candidate servers:
OSDBA group: dba
OSOPER group: oper
Database instances:
Database is policy managed
$ srvctl status database -d ORCL -v Instance ORCL_1 is running on node prodrac102. Instance status: Open. Online relocation: INACTIVE
From the above output we can see that the instance is running in the second node.
Catch Me On:- Hariprasath Rajaram
Telegram:https://t.me/joinchat/I_f4DhGF_Zifr9YZvvMkRg
LinkedIn:https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page: https://www.facebook.com/dbahariprasath/?
Twitter: https://twitter.com/hariprasathdba
