Rman-04014: startup failed: ora-29760: instance_number parameter not specified

I am getting above error when i ma starting my rac data guard on linux. i specify instance number but still its asking

Pls see the matter and do the needfull.

this is my pfile

timsdr1.__db_cache_size=4345298944
timsdr2.__db_cache_size=4395630592
timsdr2.__java_pool_size=33554432
timsdr1.__java_pool_size=33554432
timsdr1.__large_pool_size=16777216
timsdr2.__large_pool_size=16777216
timsdr1.__shared_pool_size=1191182336
timsdr2.__shared_pool_size=1140850688
timsdr1.__streams_pool_size=0
timsdr2.__streams_pool_size=0
*.audit_file_dest='/u02/app/oracle/product/database/admin/tims/adump'
*.background_dump_dest='/u02/app/oracle/product/database/admin/tims/bdump'
*.cluster_database_instances=2
*.cluster_database=TRUE
*.db_unique_name=TIMSDR
*.compatible='10.2.0.1.0'
*.control_files='/database/timsdr/control01.ctl','/database/timsdr/control02.ctl','/database/timsdr/control03.ctl'
*.core_dump_dest='/u02/app/oracle/product/database/admin/tims/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='tims'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=timsXDB)'
*.fal_client='timsdr'
*.fal_server='tims'
Service_names=’TIMSDR’
timsdr1.instance_number=1
timsdr2.instance_number=2
*.job_queue_processes=10
*.log_archive_dest_1='location=/database/timsdr/archivelog/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES)db_unique_name=TIMSDR'
*.log_archive_dest_2='service=TIMS valid_for=(online_logfiles,primary_role) db_unique_name=TIMS'
Db_file_name_conver=’/database/tims’,’/database/timsdr’
Log_file_name_covnert=’/database/tims’,’/database/timsdr’
*.log_archive_dest_state_2='ENABLE'
*.log_archive_format='ARC_%S_%T_%R'
*.open_cursors=1000
*.pga_aggregate_target=1168113664
*.processes=700
*.remote_listener='LISTENERS_TIMSDR'
*.remote_login_passwordfile='exclusive'
*.sessions=900
*.sga_target=5601492992
*.standby_file_management='auto'
timsdr2.thread=2
timsdr1.thread=1
*.undo_management='AUTO'
timsdr1.undo_tablespace='UNDOTBS1'
timsdr 2.undo_tablespace='UNDOTBS2'
TIMSDR1.LOCAL_LISTENER=LISTENER_TIMSDR_HOST1
TIMSDR2.LOCAL_LISTENER=LISTENER_TIMSDR_HOST2
Log_archive_config=’dg_config=(TIMSDR,TIMS)’
*.user_dump_dest='/u02/app/oracle/product/database/admin/tims/udump'
*.utl_file_dir='/home/oracle'

Thanks in advance..

Regards

SAM

Srvctl is case sensitive so you need to ensure that the instance and database definitions set in the spfile are the same case as those in the OCR and as are used in the srvctl commands. If they are not then either:

1. modify the spfile:

SQL>create pfile from spfile;

edit the pfile to alter all definitions to the correct case

SQL>create spfile from pfile <path to pfile>;

or

2. modify the definitions in the OCR:

srvctl remove instance -d test -i test1

srvctl remove instance -d test -i test2

srvctl remove database -d test

srvctl add database -d TEST -o $ORACLE_HOME

srvctl add instance -d TEST -i TEST1 -n <node1>

srvctl add instance -d TEST -i TEST2 -n <node2>

Thanks

Thanks for immediate reply ..

i already triad with this meta link docs..but still same issue.
p file is here for your reference.

Waiting for replay..

Regards
SAM.

Make sure you have changed in OCR file also.

*db_name='tims'
*.db_unique_name=TIMSDR
timsdr1.instance_number=1
timsdr2.instance_number=2

Thanks

*db_name='tims'
*.db_unique_name=TIMSDR
timsdr1.instance_number=1
timsdr2.instance_number=2

These parameter i already tried with small and capital alpha bates but no success.

i already changed in ocr file with following commands.

srvctl add database -d TIMSDR -o $ORACLE_HOME

srvctl add instance -d TIMSDR -i TIMSDR1 -n db1

srvctl add instance -d TIMSDR -i TIMSDR2 -n db2

Still same error is comming.

Note:-i am starting database with pfile.

Regards,

SAM..

*.db_unique_name=timsdr NOT 'TIMSDR'

Please make sure you starting database correct pfile, you may changing in pfile however you have old spfile in present in ?/dbs directory. so DB will start in old parameters.Better to create spfile after changing pfile.

Next Action: start database from node-1 from sqlplus and post error.

Thanks

your quick answers are appreciated..

Pls shear your advice/suggestion/soln in the light of below points.

1)This is fresh rac-rac stanby setup i am doing on linux 5

2)my database name is tims and unique name of dr is timsdr(is it in 10g parameter file is case sensitive?)

3)what is the reason to getting above problem.

4)pls suggest if any gap in above parameter(pfile parameters).

5)i want to test the things in one node, and i will create spfile later .?

Thanks again..

Regard,
SAM..