[Re: two listeners problem ???]

Check your tnsnames.ora and verify in CONNECT_DATA you have SERVICE_NAME (instead of SID) and the value of SERVICE_NAME=db_name.db_domain. For example, if your db_name=orcl01 and db_domain=world then SERVICE_NAME=orcl01.world.

Janet Linsy wrote:
>
> 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Suzy Vordos
  INET: lvordos_at_qwest.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).