Do you have a service like Oracle_HOMETNSListener?
I assume that you must. You don't need a separate listener for each
instance. What does the TNSNames.ora entry for LMANAGER look like?
Leslie Lu
<leslie_y_lu To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
@yahoo.com> cc:
Sent by: root Subject: listener problem ???
09/19/2002
03:18 PM
Please
respond to
ORACLE-L
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Thomas Day
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).