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 issued the command "svrmgrl," I got the svrmgr prompt. The 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 didn't help. Please help me. How do I connect to the database?
Make sure you set ORACLE_SID and not oracle_sid, remember that Unix and Linux are case sensitive. In the UNIX/LINUX universe ORACLE_SID and ORACE_HOME are upper case.
Dig Deeper on Oracle database design and architecture
Related Q&A from Mike Ault
I am trying to remove carriage returns at the end of clob fields in SQL*Plus. This just nulls out the field in the table. What do I need to change to... Continue Reading
We're using the following string to connect to the Oracle DB Server through the OraOLEDB Driver. We want to read WSID from this string in the ... Continue Reading
I want to find the length of a numeric datatype field in my table. How can I find it? Continue Reading