I felt myself stupid when I lost a few minutes to undestand this error:
SQL> startup pfile=init_corpdb.ora ORA-29760: instance_number parameter not specified
Do you belive the solution was simply to set a number in ORACLE_SID?
Take a look:
dbsrvr>echo $ORACLE_SID corpdb dbsrvr>export ORACLE_SID=corpdb_1 dbsrvr>sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Sun Jun 28 00:18:05 2015 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to an idle instance. SQL> startup pfile=init_corpdb.ora ORACLE instance started. Total System Global Area 4275781632 bytes Fixed Size 2220200 bytes Variable Size 889196376 bytes Database Buffers 3372220416 bytes Redo Buffers 12144640 bytes Database mounted. Database opened.
I hope neve miss time with this again… 😛
Matheus.
thank you. You made my day.
[oracle@rac1 ~]$ echo $ORACLE_SID
test1
[oracle@rac1 ~]$ !sql
sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Wed Oct 12 23:08:49 2016
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup spfile=’+data/test/spfiletest.ora’
SP2-0714: invalid combination of STARTUP options
SQL> startup
ORA-29760: instance_number parameter not specified
Hello Debashis,
I’m sorry by the late. But this is really the name of your instance? (give a shot with “_1”)
Can you please give a cat in spfile and show me?