Home » RDBMS Server » Networking and Gateways » ORAHome 90- ORA-12541: TNS no listener error
ORAHome 90- ORA-12541: TNS no listener error [message #3656] Thu, 10 October 2002 16:18 Go to next message
Danielle
Messages: 5
Registered: February 2002
Junior Member
Last February I sucessfuly installed ORACLE 9i on my computer at home and was able to write PL/SQL code against my tables. Everything worked fine.
I stopped using it until today (took a job....) and now when I start the Enterprise Manager Console,
it starts in Standalone like it is suppose to and I get the interface where I can see the tree with my 2 databases. When I click on either databases,

I get the following error message:

ORA-12541:TNS: no listener and the OK button.

The Database Connect Information appears with
USERNAME: SYSTEM
PASSWORD: *****
Service: DAN091 (in grey- shaded)
Connect as: SYSDBA

Then I get the same error message again

ORA-12541:TNS: no listener

..............

How can I fix this?

Did I forget how to start the database ????

I just need to start the database and get to SQLPlus...

Thank you for your help,

Danielle
dpaquin@teleport.com
Re: ORAHome 90- ORA-12541: TNS no listener error [message #3661 is a reply to message #3656] Thu, 10 October 2002 20:21 Go to previous messageGo to next message
gp
Messages: 46
Registered: September 2002
Member
have u started the listner.??? or check your tns name file is ok !!!
Re: ORAHome 90- ORA-12541: TNS no listener error [message #3683 is a reply to message #3656] Fri, 11 October 2002 20:30 Go to previous messageGo to next message
Danielle
Messages: 5
Registered: February 2002
Junior Member
Problem is fixed: I just needed to start the Listener service....
Thank you for your help.
Re: ORAHome 90- ORA-12541: TNS no listener error [message #8466 is a reply to message #3683] Fri, 22 August 2003 08:20 Go to previous message
David Baker
Messages: 1
Registered: August 2003
Junior Member
We are running Oracle 9i on Win2k and are getting the same issues. I saw that you had found a way to resolve this issue. Would it be possible to assist us an let me know what you did? Thanks.

David Baker

P.S. If you need more info, I'll be able to send that to you.
Previous Topic: 8i instance registering with 9i listener in Windoze
Next Topic: Unable to connect to db using socks server
Goto Forum:
  


Current Time: Mon May 06 07:06:19 CDT 2024