Hi,
After I issued lsnrctl start ORACL816, the 816
listener started, but the status shows "the listener
supports no services."
STATUS of the LISTENER
Alias LISTENER816
Version TNSLSNR for Solaris: Version
8.1.6.0.0 - Production
Start Date 08-APR-2002 13:23:25
Uptime 0 days 0 hr. 7 min. 16 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File
/export/apps/oracle/admin/product/8.1.6/network/admi
listener.ora
Listener Log File
/export/apps/oracle/admin/product/8.1.6/network/log/
stener816.log
The listener supports no services
The command completed successfully
I shutdown and restart the instance, it still cannot
be registered in the listener.
As a result, when I tried to log in, I got:
ORA-12514: TNS:listener could not resolve SERVICE_NAME
given in connect descriptor
Any suggestion? Much appreciated!
Janet
- Oracle User <ora_user_at_hotmail.com> wrote:
>
> Did you try starting them as start <listener_name>.
> In your case, it should
> be
>
> start listener816/listener817
>
> Also try giving 1525 instead of 1522.
> You can also try to enable logging so you can find
> out exactly what went
> wrong. Did you get any errors while trying to start
> the listener?
>
> Hope this helps. If not get back to me and I shall
> help you.
>
> Rgds
> Raj
>
> >From: Janet Linsy <janetlinsy_at_yahoo.com>
> >To: "LazyDBA.com Discussion"
> <oracledba_at_lazydba.com>
> >Subject: two listeners problem ???
> >Date: Fri, 5 Apr 2002 22:09:15 -0800 (PST)
> >
> >Hi,
> >
> >I have two databases ORCL817 and ORCL816 in version
> >817, 816 on the same machine Sun 5.7. I'd like to
> >configure seperate listener for each database. I
> used
> >different port, listener name (1521 and LISTENER817
> >for ORCL817 , 1522 and LISTENER816 for ORCL816),
> but
> >somehow the listener on 1522 cannot be started.
> >Why???
> >
> >Here is the listener.ora and tnsnames.ora for both
> >database:
> >
> >listener.ora for 816
> >=========================
> >LISTENER816 =
> > (DESCRIPTION_LIST =
> > (DESCRIPTION =
> > (ADDRESS_LIST =
> > (ADDRESS = (PROTOCOL = TCP)(HOST =
> >gatech-denver1)(PORT = 1522))
> > )
> > )
> > (DESCRIPTION =
> > (PROTOCOL_STACK =
> > (PRESENTATION = GIOP)
> > (SESSION = RAW)
> > )
> > (ADDRESS = (PROTOCOL = TCP)(HOST =
> >gatech-denver1)(PORT = 2481))
> > )
> > )
> >
> >SID_LIST_LISTENER =
> > (SID_LIST =
> > (SID_DESC =
> > (GLOBAL_DBNAME = ORCL816)
> > (ORACLE_HOME =
> >/export/apps/oracle/admin/product/8.1.6)
> > (SID_NAME = ORCL816)
> > )
> >
> >tnsnames.ora for 816
> >=========================
> >ORCL816 =
> > (DESCRIPTION =
> > (ADDRESS_LIST =
> > (ADDRESS = (PROTOCOL = TCP)(HOST =
> >gatech-denver1)(PORT = 1522))
> > )
> > (CONNECT_DATA =
> > (SERVICE_NAME = ORCL816)
> > )
> > )
> >
> >listener.ora for 817
> >=========================
> >LISTENER817 =
> > (DESCRIPTION_LIST =
> > (DESCRIPTION =
> > (ADDRESS_LIST =
> > (ADDRESS = (PROTOCOL = TCP)(HOST =
> >gatech-denver1)(PORT = 1521))
> > )
> > )
> > (DESCRIPTION =
> > (PROTOCOL_STACK =
> > (PRESENTATION = GIOP)
> > (SESSION = RAW)
> > )
> > (ADDRESS = (PROTOCOL = TCP)(HOST =
> >gatech-denver1)(PORT = 2481))
> > )
> > )
> >
> >SID_LIST_LISTENER =
> > (SID_LIST =
> > (SID_DESC =
> > (GLOBAL_DBNAME = ORCL817)
> > (ORACLE_HOME =
> >/export/apps/oracle/admin/product/8.1.7)
> > (SID_NAME = ORCL817)
> > )
> > )
> >
> >tnsnames.ora
> >=================
> >ORCL817 =
> > (DESCRIPTION =
> > (ADDRESS_LIST =
> > (ADDRESS = (PROTOCOL = TCP)(HOST =
> >gatech-denver1)(PORT = 1521))
> > )
> > (CONNECT_DATA =
> > (SERVICE_NAME = ORCL817)
> > )
> > )
> >
> >Anyone knows what went wrong? Thank you!
> >
> >Janet
> >
> >__________________________________________________
> >Do You Yahoo!?
> >Yahoo! Tax Center - online filing with TurboTax
> >http://taxes.yahoo.com/
> >
> >--------
> >Oracle documentation is here:
> >http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> >To unsubscribe: send a blank email to
> oracledba-unsubscribe_at_LAZYDBA.com
> >To subscribe: send a blank email to
> oracledba-subscribe_at_LAZYDBA.com
> >Visit the list archive:
> http://www.LAZYDBA.com/odbareadmail.pl
> >Tell yer mates about http://www.farAwayJobs.com
> >By using this list you agree to these
> >terms:http://www.lazydba.com/legal.html
> >
>
>
>
>
>
> Get your FREE download of MSN Explorer at
> http://explorer.msn.com/intl.asp.
>
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Janet Linsy
INET: janetlinsy_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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 Mon Apr 08 2002 - 15:33:21 CDT