Q

TNSListener service not starting

My TNSListener service is not starting when I start my laptop. When I first downloaded 10g I was able to connect to the local DB and other test and development DBs via Toad and SQL*Plus. But for the last two to three days I am having problems connecting. Sometimes I get the ORA-12170 error and sometimes I get ORA-1253.

My OracleOraDb10g_home1TNSListener service is not starting when I start my laptop. When I first downloaded 10g on my laptop there were no issues and I was able to connect to the local DB and other test and development DBs via Toad and SQL*Plus. But for the last two to three days I am having problems connecting to the local DB and other connections (test, dev). Sometimes I get the ORA-12170 error and sometimes I get ORA-1253. My laptop is running Windows XP (SP2). The strange part is I can log into SQL*Plus but not into Toad. Can you help?
Check that the listener service on your laptop is configured to start automatically. If it is set to manually start, this would explain why the listener does not start when your laptop starts. Right-click on the listener service in the Services panel, choose Properties and ensure that the startup type is "automatic."

The second problem you describe where you cannot connect to other databases using Toad may have to do with the

release compatibility of Toad and Oracle Net. I believe Toad requires an installation of the Oracle Client software, so the version of the client you now have may not be compatible. You should visit the Quest Software support site for further information on what the specific requirements are for Toad.

This was first published in July 2006

Dig deeper on Oracle database installation, upgrades and patches

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:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close