This content has been marked as final. Show 4 replies
What do you mean "instance id" and "oracle id"?
Belows are rights?
instance id -> instanse_number
oracle id -> oracle SID
the oracle id i meant was, we login as oracle user id.
For the instance id, i was referring to the database instance id, which is the oracle SID
Edited by: 976663 on Dec 17, 2012 10:46 PM
Use .bash_profile file for setting Oracle environments or
Please check : http://docs.oracle.com/cd/E11882_01/install.112/e24326/toc.htm
export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 export ORACLE_SID=orcl -- or your SID cd $ORACLE_HOME ./sqlplus / as sysdba SQL> startup
Mahir M. Quluzade
Thanks a lot for your reply. Actually the problem we face is that there is a database instance that we failed to startup. We do not know on which machine the database is located. The listener status command shows all databases were up except that particular one. We were told that it is a separate instance from the instance we are starting, and was told to start it using the instruction I posted.
Service "db1..." has 1 instance(s).
Instance "db1", status UNKNOWN, has 1 handler(s) for this service...