Skip to Main Content

Unable to Change Instanc_name on NODE2

JhilFeb 26 2018 — edited Feb 26 2018

Dear all,

At that time of converting standalone to RAC .. i did not update  following parameter

<!--Instance Prefix tag is optional starting with 11.2. If left empty, it is derived from db_unique_name.-->

              <n:InstancePrefix>sales</n:InstancePrefix>

[root@RAC1 Desktop]# srvctl config database -d asmdb

Database unique name: asmdb

Database name: asmdb

Oracle home: /u01/app/oracle/product/11.2.0/db_home

Oracle user: oracle

Spfile: +ASM_DG_DATA/spfileasmdb.ora

Domain:

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Server pools: asmdb

Database instances: sales1,sales2

Disk Groups: ASM_DG_DATA,ASM_DG_RECO

Mount point paths:

Services:

Type: RAC

Database is administrator managed

Now  i am trying to rename instance name of the RAC. DB

REF_LINK  : ORACLE DBA: Steps to Rename RAC instance name

I am getting folloimng error only on NODE2

ORA-29760: instance_number parameter not specified

I am using same pfile for both instances.

Unable to startup instance on NODE2 only

SQL> startup;

ORA-29760: instance_number parameter not specified

http://oracleinstance.blogspot.in/2012/01/steps-to-rename-rac-instance-name.html

Comments
Post Details
Added on Feb 26 2018
4 comments
292 views