when you start your second listener, make sure ALL the environment variables are correct and pointing to that version of Oracle
--- Janet Linsy <[EMAIL PROTECTED]> wrote: > 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/ > -- > 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). __________________________________________________ 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: Rachel Carmichael 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).
