Re: listener problem ???

From: Thomas Day <tday6_at_csc.com>
Date: Fri, 20 Sep 2002 06:33:25 -0800
Message-ID: <F001.004D4DD8.20020920063325@fatcity.com>

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 <ORACLE-L_at_fatcity.com>       
                    @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: leslie_y_lu_at_yahoo.com

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: ListGuru_at_fatcity.com (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: tday6_at_csc.com

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: ListGuru_at_fatcity.com (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).

Received on Fri Sep 20 2002 - 09:33:25 CDT