Home » Server Options » RAC & Failsafe » ora-29760: instance_number parameter not specified (oracle 10g/os linux5)
ora-29760: instance_number parameter not specified [message #553610] Mon, 07 May 2012 04:20 Go to next message
samihcl
Messages: 3
Registered: February 2010
Location: hydrabad
Junior Member
Dear Friends,

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
Re: ora-29760: instance_number parameter not specified [message #553620 is a reply to message #553610] Mon, 07 May 2012 05:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-29760: instance_number parameter not specified
 *Cause: The init.ora file did not contain a value for the instance_number
         which is required to identify this instance to other instances of
         the database running on the same cluster
 *Action: Assign a value to the instance_number parameter in the init.ora
          parameter file


Quote:
i specify instance number but still its asking


So you didn't start with the parameter file you think.

Use SQL*Plus and copy and paste your session, the WHOLE session.

Before, Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.

Regards
Michel
Re: ora-29760: instance_number parameter not specified [message #553622 is a reply to message #553620] Mon, 07 May 2012 05:32 Go to previous messageGo to next message
samihcl
Messages: 3
Registered: February 2010
Location: hydrabad
Junior Member
Thanks for your immediate replay..

Pls let me know any gap in parameters in parameter file?

pls suggest.. i am unable to start database..

Regards,
Re: ora-29760: instance_number parameter not specified [message #553627 is a reply to message #553622] Mon, 07 May 2012 06:12 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Mon, 07 May 2012 12:23
...
Use SQL*Plus and copy and paste your session, the WHOLE session.

Before, Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.

Regards
Michel

[Updated on: Mon, 07 May 2012 06:12]

Report message to a moderator

Previous Topic: Can I configure an 11gR1 RAC to redirect to different hostnames/IP's based on services
Next Topic: RAC Interconnect Transfer rate vs NIC's Bandwidth
Goto Forum:
  


Current Time: Thu Mar 28 08:17:34 CDT 2024