Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 26 2018
Added on Feb 26 2018
4 comments
435 views