Congratulations.... !!
Now one more point---
If one uses default listener name (listener) and default port (1521),
databases (8i,+) will auto register with this listener first.
Either do not use default names and ports, or make sure that you set your
init.ora parameters (service_names?) correctly to register them with the
listener you wanted those databases to use.
I think there is Note on Metalink discussing this issue. I forget the note
number at the moment....
- Kirti
-----Original Message-----
Sent: Wednesday, October 16, 2002 2:24 PM
To: Multiple recipients of list ORACLE-L
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Deshpande, Kirti
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).
