Thanks for the inputs. This is how I did it. 1. There are two listener.ora files /opt/app/oracle/product/816/listener.ora : FILE816 /opt/app/oracle/product/817/listener.ora : FILE817 FILE817 is a copy of FILE816
2. Entries for db7 are removed from FILE816 FILE816 listner name is left unchanged as LISTENER FILE816 entry for IPC was left unchanged : (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) FILE816 entry for PORT was left unchanged : (ADDRESS = (PROTOCOL = TCP)(HOST = lightening)(PORT = 1521)) 3. Entries for db6 are removed from FILE817 and ORACLE_HOME path changes are made FILE817 listner name was changed to LISTENER_817 FILE817 entry for IPC was changed as : (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_817)) ORACLE_HOME path changes were made to FILE817 FILE817 entry for PORT was changed as : (ADDRESS = (PROTOCOL = TCP)(HOST = lightening)(PORT = 1526)) 4. To use 816 listener ORACLE_HOME=$/opt/app/oracle/product/816 cd $ORACLE_HOME/network/admin $ORACLE_HOME/bin/lsnrctl stop listener $ORACLE_HOME/bin/lsnrctl start listener $ORACLE_HOME/bin/lsnrctl status listener 9. To use 817 listener ORACLE_HOME=$/opt/app/oracle/product/817 cd $ORACLE_HOME/network/admin $ORACLE_HOME/bin/lsnrctl stop listener_817 $ORACLE_HOME/bin/lsnrctl start listener_817 $ORACLE_HOME/bin/lsnrctl status listener_817 And I think I am having a. two separate Listeners b. for two different databases c. in different version (having different ORACLE_HOME) d. listening at different ports Am I correct or there is some mistake / improvement? Thanks for the inputs. -Rachna ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, October 16, 2002 2:39 PM > > > > -----Original Message----- > > Any quick start guides / scripts / notes for having multiple version > > listeners on same Solaris box? > > ------------------------------------ > > It works fine. Here is an example of some commands to put into a general > Oracle startup script. > > export ORACLE_BASE=/oracle/app/oracle > export LOGFILE=${ORACLE_BASE}/log/ora-startup.log > > exec >> $LOGFILE 2>&1 > > touch $LOGFILE > chmod a+r $LOGFILE > > print "\nStarting ora-startup" > date > > # Automatically export all variables > set -a > > # Start the databases > $ORACLE_BASE/admin/dbascripts/init.d/dbstart > > # Start the listeners > export ORACLE_HOME=$ORACLE_BASE/product/9.2.0 > $ORACLE_HOME/bin/lsnrctl start LIST_V920 > > export ORACLE_HOME=$ORACLE_BASE/product/9.0.1 > $ORACLE_HOME/bin/lsnrctl start LIST_V901 > > #Start the listeners > export ORACLE_HOME=$ORACLE_BASE/product/8.1.7 > $ORACLE_HOME/bin/lsnrctl start LIST_DSNR4 > $ORACLE_HOME/bin/lsnrctl start LIST_V817 > $ORACLE_HOME/bin/lsnrctl start LIST_V817_2 > > export ORACLE_HOME=$ORACLE_BASE/product/8.1.7.4 > $ORACLE_HOME/bin/lsnrctl start LIST_V8174 > > etc. > etc. > etc. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Stephen Lee > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > 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: Rachna Vaidya INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).