OraFAQ Forum: Windows » TNS : No Listener -------help newbie

Home » Infrastructure » Windows » TNS : No Listener -------help newbie

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

TNS : No Listener -------help newbie [message #100016]

Tue, 18 June 2002 20:11

Sandeep Pathak
Messages: 3
Registered: March 2002

Junior Member

i have installed Oracle8i, personal edition and want to run my PC as a standalone local database system. On running SQL*PLUS, i enter the following parameteres -

NAME : scott
PASS : tiger
HOST : localhost

this runs absolutely fine, as it removed my earlier error (TNS : protocol adapter error) . but now i new error is displayed at the SQL*PLUS screen :

TNS : No Listener

now to correct this , i went thru all the help files, which advised me to run the "lsnrctl" utility. but ,to add to the problem, there is no such file on my PC! please help me out by telling me how to resolve this error and getting me help start my SQL.

Also, if the above error is removed and my SQL starts, please tell me how to get the connectivity between D2K and SQL*PLUS?

Report message to a moderator

Re: TNS : No Listener -------help newbie [message #100133 is a reply to message #100016]

Thu, 01 August 2002 23:03

mayur chudnaik
Messages: 4
Registered: July 2002

Junior Member

i think there isno need to give host string name when you are running personal oracle. as it is not needed. listener is required only when u r running it on intranet

Report message to a moderator

Re: TNS : No Listener -------help newbie [message #100256 is a reply to message #100016]

Mon, 23 September 2002 14:27

Winston Callan
Messages: 3
Registered: September 2002

Junior Member

I'm in contact with several people trying to solve the listener utility problem with Windows ME. If your running ME e-mail me at wecallan@earthlink.net and I'll let you know if I find a solution. PLEASE let me know if you find one.

Report message to a moderator

Previous Topic:	Which Oracle version for standalone PC
Next Topic:	Re: Oracle installer won't start

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 20:12:29 CDT 2024