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).

Reply via email to