Ask the Expert

Can login through SQL*Plus but not Toad

I am unable to start the OracleOraDb10g_home1TNSListener service log in a local system. When I first downloaded 10g, everything was working fine; all the services were starting up. In the last two days I am having problems. As a result I am not able to login to my DB via Toad. But the strange thing is I am able to login to SQL*PLUS with the same username and password.

    Requires Free Membership to View

There could be many reasons why the service will not start. Did you look at the server's Event Viewer to see if there were any error messages which can help you diagnose the problem? Also look at %ORACLE_HOME%\network\log\listener.log to see if error messages are there. Without meaningful error messages, it is close to impossible to diagnose your problem.

This was first published in July 2006

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: