查询oracle rac实例名,ORACLE RAC 修改实例名（实际操作记录分享）

备份全库和spfile

backup as compressed backupset database plus archivelog;

expdp dbank/dbank directory=dmp_dir dumpfile=dbank_2015623.dmp logfile=dbank.log parallel=5 SCHEMAS=DBANK

Create pfile from spfile;

收集数据库信息

$DB_HOME/bin/srvctl config database -d -a

$DB_HOME/bin/srvctl config service -d

创建一个新的pfile

Create pfile from spfile;

关闭所有节点

crsctl stop cluster -all

重命名或编辑实例名称和其他参数使用实例名称。

For example: instance_name, service_names

创建新的实例之一Sid名字节点新密码文件。复制密码文件到其他节点和重命名它与相应的新的SID的名字。

If Data guard is in use, copy the password file from the primary $ORACLE_HOMEs to the standby server and rename it with the corresponding standby SID name.

Startup the database with new pfile file and create a spfile using new pfile.

Remove the old instance name and add a new instance name using srvctl command. ( Follow below for all instances whose names are changed )

$ srvctl remove instance -d -i

$ srvctl add instance -d -i -n

Configure the services back (if necessary)

$ srvctl modify service -d -s

Start the database

$ srvctl start database -d

SQL> select instance_name,status from gv$instance

Check tnsnames.ora, if INSTANCE_NAME is used, rename it accordingly.

For example:

net_service_name=

(DESCRIPTION=

(ADDRESS=...)

(ADDRESS=...)

(CONNECT_DATA=

(SERVICE_NAME=sales.us.example.com)

(INSTANCE_NAME=sales1)))