Q

Unable to connect to database using svrmgrl

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

Dig deeper on Oracle database performance problems and tuning

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close