Steps for ORACLE RAC change instance Name

The following are some of the steps to change, but the startup problem still exists and the person is complete.

A single instance database modification SID is simpler, and you can mount the database simply by modifying the pfile related parameters. The RAC environment is in fact the same, except that the OCR information needs to be modified in addition to modifying the pfile.

First look at the status of the RAC:

[Root@rac1 tmp]#/u01/app/crs/bin/crs_stat-t

Name Type Target State Host

------------------------------------------------------------

Ora.orcl.db Application Online Online Rac1

Ora....l1.inst Application Online Online Rac1

Ora....l2.inst Application Online Online RAC2

Ora ..... Sm1.asm Application Online Online Rac1

Ora ..... C1.lsnr Application Online Online Rac1

ORA.RAC1.GSD Application Online Online Rac1

Ora.rac1.ons Application Online Online Rac1

ORA.RAC1.VIP Application Online Online Rac1

Ora ..... Sm2.asm Application Online Online RAC2

Ora ..... C2.lsnr Application Online Online RAC2

ORA.RAC2.GSD Application Online Online RAC2

Ora.rac2.ons Application Online Online RAC2

ORA.RAC2.VIP Application Online Online RAC2

Now the RAC State is all right and all services have been started. Here's how to modify the SID of 2 RAC Machines, respectively: Orcl3, Orcl4

1. Create Pfile, then ORCL1--->orcl3 orcl2--->orcl4, and transfer 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 00:00

[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