Add a Node to Oracle 12cR1 RAC on RHEL 6(九)
l/bin ...
Copying coraenv to /usr/local/bin ...
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.
Add Instance to Clustered Database
A database instance will be established on the new node. Specifically, an instance named "zwc3" will be added to "zwc" – a pre-existing clustered database.
Satisfy Node Instance Dependencies
Satisfy all node instance dependencies, such as init.ora parameters, etc.
From the new node "zhongwc3", run the following commands to create the passwordfile, "init.ora" file, and "oratab" entry for the new instance
[oracle@zhongwc3 ~]$ cd $ORACLE_HOME/dbs
[oracle@zhongwc3 dbs]$ mv initzwc1.ora initzwc3.ora
[oracle@zhongwc3 dbs]$ echo "zwc:$ORACLE_HOME:N" >> /etc/oratab
From a node with an existing instance of "zwc" issue the following commands to create the needed public log thread, undo tablespace, and "init.ora" entries for the new instance
[oracle@zhongwc1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Mon Oct 21 22:03:06 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
SQL> alter database add logfile thread 3 group 5 ('+DATADG','+FRADG') size 50M, group 6 ('+DATADG','+FRADG') size 50M;
Database altered.
SQL> alter database enable public thread 3;
Database altered.
SQL> create undo tablespace undotbs3 datafile '+DATADG' size 200M autoextend on;
Tablespace created.
SQL>
alter system set undo_tablespace='undotbs3' scope=spfile sid='zwc3';
System altered.
SQL> alter system set instance_number=3 scope=spfile sid='zwc3';
System altered.
SQL> alter system set cluster_database_instances=3 scope=spfile sid='*';
System altered.
Update Oracle Cluster Registry (OCR)
The OCR will be updated to account for a new instance – "zwc3" – being added to the "zwc" cluster database .
[oracle@zhongwc3 ~]$ srvctl add instance -d zwc -i zwc3 -n zhongwc3
[oracle@zhongwc3 ~]$ srvctl status database -d zwc -v
Instance zwc1 is running on node zhongwc1 with online services crm. Instance status: Open.
Instance zwc2 is running on node zhongwc2 with online services erp. Instance status: Open.
Instance zwc3 is not running on node zhongwc3
[oracle@zhongwc3 ~]$
[oracle@zhongwc3 ~]$ srvctl config database -d zwc
Database unique name: zwc
Database name: zwc
Oracle home: /u01/app/oracle/product/12.1.0/db_1
Oracle user: oracle
Spfile: +DATADG/zwc/spfilezwc.ora
Password file: +DATADG/zwc/orapwzwc
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: zwc
Database instances: zwc1,zwc2,zwc3
Disk Groups: FRADG,DATADG
Mount point paths:
Services: crm,erp
Type: RAC
Start concurrency:
Stop concurrency:
Database is administrator managed
Start "zwc3" Instance
Now that all the prerequisites have been satisfied and OCR updated, the "zwc3" instance will be started.
Start the newly created instance – "zwc3" – and verify
[oracle@zhongwc3 ~]$ srvctl start ins