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 bytes
Fixed Size                  2022016 bytes
Variable Size             171967872 bytes
Database Buffers          343932928 bytes
Redo Buffers                6365184 bytes
Database mounted.

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

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

5. 修改SID

[oracle@rac1 ~]$ nid target=sys/admin dbname=nimng
DBNEWID: Release 10.2.0.1.0 - Production on Wed Sep 5 08:34:40 2012
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
Connected to database GGTARGET (DBID=3458480369)
Connected to server version 10.2.0
Control Files in database:
    /dev/raw/raw23
    /dev/raw/raw24
Change database ID and database name GGTARGET to NIMNG? (Y/[N]) => y
Proceeding with operation
Changing database ID from 3458480369 to 3834401760
Changing 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 down
Database 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=2
nimng1.instance_number=1
rac1.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=524288000
nimng2.thread=2
nimng1.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 bytes
Fixed Size                  2022016 bytes
Variable Size             146802048 bytes
Database Buffers          369098752 bytes
Redo Buffers                6365184 bytes
Database 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 ggtarget
Remove 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> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/home/oracle/product/10.2.0/db_1/dbs/initnimng2.ora'

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

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