I joined in a bit late on this thread, so you might have your problem fixed. Your SID_LIST_LISTENER entry in the listener.ora should say SID_LIST_LISTENER816 and SID_LIST_LISTENER817. When starting the listener, do the following:
(w/environment set for 816) lsnrctl start listener816 (w/environment set for 817) lsnrctl start listener817 In theory, you don't have to specify the sids, because the databases can register themselves with the listener, but I have had issues with this, so I just use the old sid list method. Which reminds me, you databases will all register with the default listener (on port 1521) unless you tell them otherwise with this init.ora entry: local_listener = "(address = (protocol = tcp)(host = gatech-devner1)(port = 1522))" I forget when this local_listener entry was implemented, but I know it is there for 8.1.7. One reason for having different listeners is for running databases in a cluster. Depending on how you have your cluster configured, you will need at least one listener per node. Jay Hostetter Oracle DBA D. & E. Communications Ephrata, PA USA >>> [EMAIL PROTECTED] 04/08/02 12:16PM >>> Please excuse my idiotic curiosity. Why do you need 2 listeners on the same machine? I always install the listener of the higher version and disable the previous one. Yechiel Adar. Mehish ----- Original Message ----- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Saturday, April 06, 2002 8:08 AM > 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter 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).
