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
How to find the definition or structure of a dropped table? I know the table's name but I don't know the columns and datatypes. It no longer exists. Continue Reading
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
I want to find the length of a numeric datatype field in my table. How can I find it? Continue Reading