This content has been marked as final. Show 8 replies
tutus wrote:parameter [instance_number|http://www.sc.ehu.es/siwebso/KZCC/Oracle_10g_Documentacion/server.101/b10755/initparams085.htm] is missing from the init.ora file you are using to start that instance.
Could anyone know how to help me with this?
you will need put that parameter in your initialization file if you want to start it.
What's more interesting... When I copy file from ASM locally like that:
[oracle@nod2 dbs]$ cp /u01/app/oracle/admin/+ASM/pfile/init.ora initorcl2.ora
and set instance_number=2, then during startup instance I've got an error:
ORA-00304: requested INSTANCE_NUMBER is busy
Right now, I don't know what's going on....
tutus wrote:How interesting ?
Do anyone know how can I start second instance?
Do you have the problem on ASM or not?
Please check pfile on node1
Actually, you should copy pfile from node1 to node2
scp node01:$ORACLE_HOME/dbs/dbs/init+ASM1.ora $ORACLE_HOME/dbs/dbs/init+ASM2.ora
scp node01: $ORACLE_HOME/dbs/dbs/initorcl1.ora $ORACLE_HOME/dbs/dbs/initorcl2.ora
that's idea ... you can adapt with your idea...
sqlpus / as sysdba
and post error :
Byt the way if you need to solve instance's not start by "srvctl"
you can review at $ORACLE_HOME/log/nod2/racg/imon* files