Why not post the latest of your listener.ora file. It should be quite a bit different then the original that made it to the list.
-----Original Message----- Sent: Monday, April 08, 2002 1:33 PM To: Multiple recipients of list ORACLE-L 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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> > >To: "LazyDBA.com Discussion" > <[EMAIL PROTECTED]> > >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 > [EMAIL PROTECTED] > >To subscribe: send a blank email to > [EMAIL PROTECTED] > >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: [EMAIL PROTECTED] 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: [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: Kimberly Smith INET: [EMAIL PROTECTED] 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: [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).
