RAC 修改实例名

1.将CLUSTER_DATABASE设置为FALSE。

SQL> alter system set cluster_database=false scope=spfile;System altered.

2. 关闭两节点数据库。

[oracle@rac1 ~]$ srvctl stop instance -d ggtarget -i ggtarget1[oracle@rac1 ~]$ srvctl stop instance -d ggtarget -i ggtarget2

3.启动第一节点到MOUNT状态

SQL> startup mount;ORACLE instance started.Total System Global Area  524288000 bytesFixed Size                  2022016 bytesVariable Size             171967872 bytesDatabase Buffers          343932928 bytesRedo Buffers                6365184 bytesDatabase mounted.

4.从SPFILE生成一个新的PFILE文件

SQL> create pfile='/home/oracle/initggtarget1.ora' from spfile;File created.

5. 修改SID

[oracle@rac1 ~]$ nid target=sys/admin dbname=nimngDBNEWID: Release 10.2.0.1.0 - Production on Wed Sep 5 08:34:40 2012Copyright (c) 1982, 2005, Oracle.  All rights reserved.Connected to database GGTARGET (DBID=3458480369)Connected to server version 10.2.0Control Files in database:    /dev/raw/raw23    /dev/raw/raw24Change database ID and database name GGTARGET to NIMNG? (Y/[N]) => yProceeding with operationChanging database ID from 3458480369 to 3834401760Changing database name from GGTARGET to NIMNG    Control File /dev/raw/raw23 - modified    Control File /dev/raw/raw24 - modified    Datafile /dev/raw/raw25 - dbid changed, wrote new name    Datafile /dev/raw/raw38 - dbid changed, wrote new name    Datafile /dev/raw/raw26 - dbid changed, wrote new name    Datafile /dev/raw/raw36 - dbid changed, wrote new name    Datafile /dev/raw/raw37 - dbid changed, wrote new name    Datafile /dev/raw/raw34 - dbid changed, wrote new name    Datafile /dev/raw/raw35 - dbid changed, wrote new name    Control File /dev/raw/raw23 - dbid changed, wrote new name    Control File /dev/raw/raw24 - dbid changed, wrote new name    Instance shut downDatabase name changed to NIMNG.Modify parameter file and generate a new password file before restarting.Database ID for database NIMNG changed to 3834401760.All previous backups and archived redo logs for this database are unusable.Database has been shutdown, open database with RESETLOGS option.Succesfully changed database name and ID.DBNEWID - Completed succesfully.

5. 修改参数文件。

*.audit_file_dest='/home/oracle/admin/ggtarget/adump'*.background_dump_dest='/home/oracle/admin/ggtarget/bdump'*.cluster_database_instances=2*.cluster_database=FALSE*.compatible='10.2.0.1.0'*.control_files='/dev/raw/raw23','/dev/raw/raw24'*.core_dump_dest='/home/oracle/admin/ggtarget/cdump'*.db_block_size=8192*.db_domain=''*.db_file_multiblock_read_count=16*.db_name='nimng'*.dispatchers='(PROTOCOL=TCP) (SERVICE=nimngXDB)'nimng2.instance_number=2nimng1.instance_number=1rac1.instance_name='nimng1'rac2.instance_name='nimng2'*.job_queue_processes=10*.open_cursors=300*.pga_aggregate_target=305135616*.processes=150*.remote_listener='LISTENERS_nimng'*.remote_login_passwordfile='exclusive'*.sga_target=524288000nimng2.thread=2nimng1.thread=1*.undo_management='AUTO'nimng2.undo_tablespace='UNDOTBS2'nimng1.undo_tablespace='UNDOTBS1'*.user_dump_dest='/home/oracle/admin/ggtarget/udump'

7.  修改TNS文件。  两节点上此处要修改。

LISTENERS_NIMNG =  (ADDRESS_LIST =    (ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521))    (ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip)(PORT = 1521))  )

8. 换实例名为NIMNG1，启动库。

SQL> startup mount pfile='/home/oracle/initggtarget1.ora';ORACLE instance started.Total System Global Area  524288000 bytesFixed Size                  2022016 bytesVariable Size             146802048 bytesDatabase Buffers          369098752 bytesRedo Buffers                6365184 bytesDatabase mounted.SQL> alter database open resetlogs;Database altered.

在这里要注意更改SID后需要以RESETLOGS方式打开数据库。

SQL> select instance_name from v$instance;INSTANCE_NAME----------------nimng1

9. 生成SPFILE文件。

SQL> create spfile='/dev/raw/raw22' from pfile='/home/oracle/initggtarget1.ora';File created.

10. 更新OCR信息。

[oracle@rac1 admin]$ srvctl remove database -d ggtargetRemove the database ggtarget? (y/[n]) y[oracle@rac1 admin]$ srvctl add database -d nimng -o $ORACLE_HOME[oracle@rac1 admin]$ srvctl add instance -d nimng -i nimng1 -n rac1[oracle@rac1 admin]$ srvctl add instance -d nimng -i nimng2 -n rac2

11. 启动两节点数据库。

SQL> startupORA-01078: failure in processing system parametersLRM-00109: could not open parameter file '/home/oracle/product/10.2.0/db_1/dbs/initnimng2.ora'

在启动两节点的时候会报这个错误，   我们可以修改PFILE文件。

[oracle@rac2 dbs]$ vi initnimng2.oraSPFILE='/dev/raw/raw22'