The scenario looks like this: I connected to the Sun server using a telnet client and got connected to the server....
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
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
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'm having a problem with dynamic SQL, specifically getting my incoming parameter into the SQL statement. I am using Oracle 9i and this procedure ...continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.