Please help me in this regard. The scenario looks like this: I connected to the Sun server using a telnet client and got connected to the server. After this, I issued a command at the prompt like this:
$ sudo su - oracle password
It got connected as Oracle home. When I issue the command svrmgrl, I got the svrmgr prompt, and there I typed connect /as sysdba. It is connected, but the main problem is that when I issue a SQL statement, it's saying "Oracle Not Available." But there are multiple instances running. I also exported ORACLE_SID and ORACLE_HOME, but it's no use. Please help me -- how do I connect to the database?
What version of Oracle? svrmgrl is not supported from 9i onward. Try using SQL*Plus instead.
Once you have executed the sudo command and are connected as Oracle, make sure that ORACLE_HOME and ORACLE_SID are set correctly, then start SQL*Plus and try to log on as a non-DBA user.
This was first published in October 2004