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

Problems connecting after installation of 10g

My question is about Oracle 10g. I used the Oracle Enterprise Manager Console and created a new database, but I can't connect. I checked the listener.ora file and net service but they don't work. I get the error "ORA-12541: TNS:No Listener." Can you help me?

My question is about Oracle 10g. I can install Oracle 10g on Windows XP 2005, and the Universal Installer says that the installation was completed successfully. I had no Microsoft active directory on my system. I installed version 5.1 on my computer and installed Visual Studio .NET 2003 and I want to create a new database in Oracle. I used the Oracle Enterprise Manager Console and created a new database, but I can't connect. I checked the listener.ora file and net service but they don't work. I get the error "ORA-12541: TNS:No Listener." I searched on the Internet for a solution and I found some but I can't solve the problem. I can't find lsnrCtl Batch or command file on my computer, so I thought that maybe the installation was not complete. I uninstalled Oracle 10g and installed it again, but the problem was not solved. I use Microsoft SQL Server on my local host without any problem. I installed Oracle 10g in administrator mode and I want to use it on LocalHost. Can you help me?
If you are getting an ORA-12541 check to see that the listener on your database server is, in fact, running. You can do that one of two ways.

Open up Services from Control Panel and check for a service called OracleOraDb10g_homeTNSListener (yours may be called something slightly different). If the Status is blank, this means it has not been started. Right-click on the service and choose Start.

The second method of starting the listener is from the command prompt. Open a Command Prompt window and type:

lsnrctl status
If you receive error messages about "TNS no listener," this means the listener has not been started. To start the listener from the command prompt, type:
lsnrctl start
Try connecting with SQL*Plus on the database server by choosing Start-->All Programs-->Oracle-OraDb10g_home1-->Application Development-->SQL Plus. Note that it may take a minute or so for the database to register with the listener, so if this still fails, wait at least 60 seconds and then try again.
This was last published in October 2005

Dig Deeper on Oracle database installation, upgrades and patches

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