OraFAQ Forum: Networking and Gateways » ORAHome 90- ORA-12541: TNS no listener error

Home » RDBMS Server » Networking and Gateways » ORAHome 90- ORA-12541: TNS no listener error

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORAHome 90- ORA-12541: TNS no listener error [message #3656]

Thu, 10 October 2002 16:18

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

Report message to a moderator

Re: ORAHome 90- ORA-12541: TNS no listener error [message #3661 is a reply to message #3656]

Thu, 10 October 2002 20:21

gp
Messages: 46
Registered: September 2002

Member

have u started the listner.??? or check your tns name file is ok !!!

Report message to a moderator

Re: ORAHome 90- ORA-12541: TNS no listener error [message #3683 is a reply to message #3656]

Fri, 11 October 2002 20:30

Danielle
Messages: 5
Registered: February 2002

Junior Member

Problem is fixed: I just needed to start the Listener service....
Thank you for your help.

Report message to a moderator

Re: ORAHome 90- ORA-12541: TNS no listener error [message #8466 is a reply to message #3683]

Fri, 22 August 2003 08:20

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.

Report message to a moderator

Previous Topic:	8i instance registering with 9i listener in Windoze
Next Topic:	Unable to connect to db using socks server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 03 16:19:31 CDT 2025