This content has been marked as final. Show 4 replies
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...