Complete procedure for changing instance name in Oracle RAC

The following are some steps to change, but the startup problem still exists.

It is easy to modify the SID of a single-instance database. You only need to modify the pfile-related parameters to mount the database. The RAC environment is actually the same, except for modifying pfile, you also need to modify OCR information.

First, let's look at the RAC status:
[Root @ rac1 tmp] #/u01/app/crs/bin/crs_stat-t
Name Type Target State Host
------------------------------------------------------------
Ora. orcl. db application ONLINE rac1
Ora... l1.inst application ONLINE rac1
Ora... l2.inst application ONLINE rac2
Ora... SM1.asm application ONLINE rac1
Ora... C1.lsnr application ONLINE rac1
Ora. rac1.gsd application ONLINE rac1
Ora. rac1.ons application ONLINE rac1
Ora. rac1.vip application ONLINE rac1
Ora... SM2.asm application ONLINE rac2
Ora... C2.lsnr application ONLINE rac2
Ora. rac2.gsd application ONLINE rac2
Ora. rac2.ons application ONLINE rac2
Ora. rac2.vip application ONLINE rac2

Now the RAC status is normal and all services have been started. Next, we will try to modify the SID of the two RAC machines to orl3 and orcl4, respectively.

1. Create a pfile, and transmit orcl1 ---> orl3 orcl2 ---> orcl4 to another node. Other parameters are not changed.
SQL> conn/as sysdba
Connected.
SQL> create pfile = '/tmp/pfile' from spfile;

File created.

[Oracle @ rac1 companion] $ scp/tmp/pfile 192.168.18.9:/tmp
Pfile 100% 1290 1.3KB/s

[Oracle @ rac1 companion] $ cat/tmp/pfile
Orcl4. _ db_cache_size = 75497472
Orcl3. _ db_cache_size = 58720256
Orcl3. _ java_pool_size = 4194304
Orcl4. _ java_pool_size = 4194304
Orcl3. _ large_pool_size = 4194304
Orcl4. _ large_pool_size = 4194304
Orcl4. _ shared_pool_size = 79691776
Orcl3. _ shared_pool_size = 96468992
Orcl3. _ streams_pool_size = 0
Orcl4. _ streams_pool_size = 0
*. Audit_file_dest = '/u01/app/oracle/admin/orcl/adump'
*. Background_dump_dest = '/u01/app/oracle/admin/orcl/bdump'
*. Cluster_database_instances = 2
*. Cluster_database = true
*. Compatible = '10. 2.0.1.0'
*. Control_files = '+ DATA1/orcl/controlfile/current.260.696461787'
*. Core_dump_dest = '/u01/app/oracle/admin/orcl/cdump'
*. Db_block_size = 8192
*. Db_create_file_dest = '+ DATA1'
*. Db_domain = 'oracle. com'
*. Db_file_multiblock_read_count = 16
*. Db_name = 'orcl'
*. Dispatchers = '(PROTOCOL = TCP) (SERVICE = orclXDB )'
Orcl4.instance _ number = 2
Orcl3.instance _ number = 1
*. Job_queue_processes = 10
*. Log_archive_dest_1 = 'location = + DATA1/orcl /'
*. Log_archive_format = '% t _ % s _ % r. dbf'
*. Open_cursors = 300
*. Pga_aggregate_target = 16777216
*. Processses = 150
*. Remote_listener = 'listeners _ ORCL'
*. Remote_login_passwordfile = 'clusive'
*. Sga_target = 167772160
Orcl4.thread = 2
Orcl3.thread = 1
*. Undo_management = 'auto'
Orcl3.undo _ tablespace = 'undotbs1'
Orcl4.undo _ tablespace = 'undotbs2'
*. User_dump_dest = '/u01/app/oracle/admin/orcl/udump'

1 2 3 Next Page