Step1: Create a duplicate stand alone database from the RAC db follow the steps in
Step2: Follow the notes as described in Note ID: [ ID 747457.1 ]
*.cluster_database = TRUE
Step2: Follow the notes as described in Note ID: [ ID 747457.1 ]
- Modify the single instance pfile for the RAC specific parameters
*.cluster_database = TRUE
*.cluster_database_instances = 2
*.undo_management=AUTO
prod1.undo_tablespace=UNDOTBS1
prod1.instance_name=prod1
prod1.instance_number=1
prod1.thread=1
<prod1.local_listener=listener_ocvmrh2103>
<prod2.local_listener=listener_ocvmrh2190>
prod1.remote_listener=<scan listener>
prod2.remote_listener=<scan listener>
prod2.instance_name=prod2
prod2.instance_number=2
prod2.thread=2
prod2.undo_tablespace=UNDOTBS2
- create spfile from pfile
export ORACLE_SID=PROD1 sqlplus "/ as sysdba" create spfile='+DATA/PROD/spfilePROD.ora' from pfile='/tmp/initPROD.ora'; exit
- Create the password file for instance1
orapwd file=orapwORCL1 password=oracle
- start the database in mount stage
export ORACLE_SID=prod1 <this is most important one instance 1>
- Open your database and run $ORACLE_HOME/rdbms/admin/catclust.sql to create cluster database specific views.
- Now can start ur 2nd instance follow the same steps as earlier i.e. export ORACLE_SID=<instance 2> create a password file for 2nd instance and start the second instance.
- Add the newly created RAC database to cluster
- srvctl add database -d <database name> -o <ORACLE_HOME path> -p <spfile location and name>
- srvctl add instance -d <database name> -i <instance 1 name> -n <node 1 name > srvctl add instance -d <database name> -i <instance 2 name> -n <node 2 name >
No comments:
Post a Comment