Q

Can login through SQL*Plus but not Toad

I am unable to start the OracleOraDb10g_home1TNSListener service log in a local system. In the last two days I am having problems. As a result I am not able to login to my DB via Toad. But I am able to login to SQL*PLUS with the same username and password.

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.
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 last published in July 2006

Dig Deeper on Oracle database design and architecture

PRO+

Content

Find more PRO+ content and other member only offers, here.

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.

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

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close