Q
Problem solve Get help with specific problems with your technologies, process and projects.

Problem connecting to the database

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.

This was last published in September 2004

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close