Can't run SQL on my Win98 system. ERROR : Tns :no listener

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Wed, 19 Jun 2002 12:38:31 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA7024066D8@lnewton.leeds.lfs.co.uk>

check in the oracle bin folder for lsnrctl.exe (I've got PO 817) and you will find it *is&* there.
click start | run | cmd (or is it command) to get a dos box. lsnrctl start

and that should start it up for you.

Regards,
Norman.

---

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----
From: sppc42_at_rediffmail.com (Sandeep Pathak) [mailto:sppc42_at_rediffmail.com]
Posted At: Wednesday, June 19, 2002 10:25 AM Posted To: server
Conversation: Can't run SQL on my Win98 system. ERROR : Tns :no listener Subject: Can't run SQL on my Win98 system. ERROR : Tns :no listener

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? Received on Wed Jun 19 2002 - 06:38:31 CDT