Hi all, I have a database LMANAGER (817 on win2000), it's on my local machine. I can log into it using svrmgrl. But when I connect using sqlplus, I got "ORA-12541: TNS:no listener". LMANAGER is already in listener.ora file, and lsnrctl status shows LMANAGER is there:
(c) Copyright 1998 Oracle Corporation. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for 32-bit Windows: Version 8.1.7.0.0 - Produ tion Start Date 19-SEP-2002 12:01:44 Uptime 0 days 0 hr. 5 min. 1 sec Trace Level off Security OFF SNMP OFF Listener Parameter File C:\oracle\oracle81\network\admin\listener.ora Listener Log File C:\oracle\oracle81\network\log\listener.log Services Summary... LMANAGER has 1 service handler(s) prod has 1 service handler(s) The command completed successfully However, I don't see a service in NT services like Oracle_HOMETNSListenerLMANAGER. How do I create it? Thank you in advance! Leslie __________________________________________________ Do you Yahoo!? New DSL Internet Access from SBC & Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leslie Lu INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).