Hi All,
I went through most the OTN forum links and google before i reach out here.
Oracle 11GR2 LINUX 5.1 release
its a 3 node RAC cluster.
ASM shared storage.
I was able to successfully create a database called TEST.
I entered the RAC related parametes in pfile and when i start up i am encountering this error.
I tried lot of options like, SPFILE on shared location .
lower case and upper case.
tried starting it up with pfile and spfile in ASM
tried to add instance, database using srvctl.
still i keep getting the same. error. Can you please help what i am missign here?
FYI: This is a new database i am creating on this. As a standalone database its up and running with ASM storage.
But i am facing issue when i include RAC related parameters and start it up with pfile.
Below is the pfile i am pasting. pls let me know if you have any question.
ORA-29760: instance_number parameter not specified
TEST1.__db_cache_size=3758096384
TEST2.__db_cache_size=3758096384
TEST3.__db_cache_size=3758096384
TEST1.__java_pool_size=1073741824
TEST2.__java_pool_size=1073741824
TEST3.__java_pool_size=1073741824
TEST1.__large_pool_size=268435456
TEST2.__large_pool_size=268435456
TEST3.__large_pool_size=268435456
TEST1.__oracle_base='/u01/app/grid'#ORACLE_BASE set from environment
TEST2.__oracle_base='/u01/app/grid'
TEST3.__oracle_base='/u01/app/grid'
TEST1.__pga_aggregate_target=12079595520
TEST2.__pga_aggregate_target=12079595520
TEST3.__pga_aggregate_target=12079595520
TEST1.__sga_target=15032385536
TEST2.__sga_target=15032385536
TEST3.__sga_target=15032385536
TEST1.__shared_io_pool_size=0
TEST2.__shared_io_pool_size=0
TEST3.__shared_io_pool_size=0
TEST1.__shared_pool_size=9126805504
TEST2.__shared_pool_size=9126805504
TEST3.__shared_pool_size=9126805504
TEST1.__streams_pool_size=536870912
TEST2.__streams_pool_size=536870912
TEST3.__streams_pool_size=536870912
*.audit_file_dest='/u01/app/oracle/admin/TEST/adump'
*.audit_trail='NONE'
*.cluster_database=true
*.compatible='11.2.0.0.0'
*.control_files='+DATA/TEST/controlfile/current.301.810391179','+FRA/TEST/controlfile/current.267.810391179'#Oracle managed file
*.db_block_size=8192
*.db_create_file_dest='+DATA'
*.db_domain=''
*.db_name='TEST'
*.db_recovery_file_dest='+FRA'
*.db_recovery_file_dest_size=3882M
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=TESTXDB)'
TEST1.instance_name=TEST1
TEST2.instance_name=TEST2
TEST3.instance_name=TEST3
TEST3.instance_number=3
TEST2.instance_number=2
TEST1.instance_number=1
*.memory_target=27034386432
*.open_cursors=300
*.parallel_max_servers=0
*.processes=500
*.remote_login_passwordfile='exclusive'
*.undo_tablespace='UNDOTBS1'
TEST1.thread=1
TEST2.thread=2
TEST3.thread=3
TEST1.undo_tablespace='UNDOTBS1'
TEST2.undo_tablespace='UNDOTBS2'
TEST3.undo_tablespace='UNDOTBS3'
Thanks,
John