FAQ
DBAs,

Any quick start guides / scripts / notes for having multiple version
listeners on same Solaris box?

Scenario :
I am in process of upgrading.
There are two databases on a machine db6 and db7
db6 <---------> 8.1.6
db7 <---------> 8.1.6
db6 and db7 use the "listener" of version 8.1.6

Now,
db7 migrated to 8.1.6
I am thinking of something like :
db6 <---------> listener of 8.1.6 (status quo)
db7 <---------> listener_817 of 8.1.7 (new version listener)

Two separate listener.ora files

lsnrctl status listener (for 8.1.6 listener)
lsnrctl status listener_817 (for 8.1.7 listener)

Thanks in advance,

-Rachna
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachna Vaidya
INET: rachnavaidya_at_hotmail.com

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: ListGuru_at_fatcity.com (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).

Search Discussions

  • Gene Sais at Oct 16, 2002 at 6:39 pm
    1st thing i do when upgrading db's on a server is to start using the new listener. just have your 816 db's use the 817 listener.

    hth,
    gene
    rachnavaidya_at_hotmail.com 10/16/02 02:12PM >>>
    DBAs,

    Any quick start guides / scripts / notes for having multiple version
    listeners on same Solaris box?

    Scenario :
    I am in process of upgrading.
    There are two databases on a machine db6 and db7
    db6 <---------> 8.1.6
    db7 <---------> 8.1.6
    db6 and db7 use the "listener" of version 8.1.6

    Now,
    db7 migrated to 8.1.6
    I am thinking of something like :
    db6 <---------> listener of 8.1.6 (status quo)
    db7 <---------> listener_817 of 8.1.7 (new version listener)

    Two separate listener.ora files

    lsnrctl status listener (for 8.1.6 listener)
    lsnrctl status listener_817 (for 8.1.7 listener)

    Thanks in advance,

    -Rachna

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Rachna Vaidya
    INET: rachnavaidya_at_hotmail.com

    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: ListGuru_at_fatcity.com (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: Gene Sais
    INET: Gsais_at_co.palm-beach.fl.us

    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: ListGuru_at_fatcity.com (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).
  • Mercadante, Thomas F at Oct 16, 2002 at 6:39 pm
    Rachna,

    Do yourself a favor - use the most recent listener for all databases. Have
    only one listener running on a machine and use that for all databases on
    that machine. In your case, use the 817 listener.

    In the long run, it will be much easier and less confusing.

    Hope this helps.

    Tom Mercadante
    Oracle Certified Professional

    -----Original Message-----
    Sent: Wednesday, October 16, 2002 2:13 PM
    To: Multiple recipients of list ORACLE-L

    DBAs,

    Any quick start guides / scripts / notes for having multiple version
    listeners on same Solaris box?

    Scenario :
    I am in process of upgrading.
    There are two databases on a machine db6 and db7
    db6 <---------> 8.1.6
    db7 <---------> 8.1.6
    db6 and db7 use the "listener" of version 8.1.6

    Now,
    db7 migrated to 8.1.6
    I am thinking of something like :
    db6 <---------> listener of 8.1.6 (status quo)
    db7 <---------> listener_817 of 8.1.7 (new version listener)

    Two separate listener.ora files

    lsnrctl status listener (for 8.1.6 listener)
    lsnrctl status listener_817 (for 8.1.7 listener)

    Thanks in advance,

    -Rachna
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Rachna Vaidya
    INET: rachnavaidya_at_hotmail.com

    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: ListGuru_at_fatcity.com (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: Mercadante, Thomas F
    INET: NDATFM_at_labor.state.ny.us

    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: ListGuru_at_fatcity.com (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).
  • Stephen Lee at Oct 16, 2002 at 6: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: slee_at_dollar.com

    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: ListGuru_at_fatcity.com (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).
  • Deshpande, Kirti at Oct 16, 2002 at 6:39 pm
    You can use the 'higher' version of the listener for all databases running
    on <= higher version, unless you need multiple listeners for other
    reasons.... Net8 Admin Guide should have enough information.

    Kirti

    -----Original Message-----
    Sent: Wednesday, October 16, 2002 1:13 PM
    To: Multiple recipients of list ORACLE-L

    DBAs,

    Any quick start guides / scripts / notes for having multiple version
    listeners on same Solaris box?

    Scenario :
    I am in process of upgrading.
    There are two databases on a machine db6 and db7
    db6 <---------> 8.1.6
    db7 <---------> 8.1.6
    db6 and db7 use the "listener" of version 8.1.6

    Now,
    db7 migrated to 8.1.6
    I am thinking of something like :
    db6 <---------> listener of 8.1.6 (status quo)
    db7 <---------> listener_817 of 8.1.7 (new version listener)

    Two separate listener.ora files

    lsnrctl status listener (for 8.1.6 listener)
    lsnrctl status listener_817 (for 8.1.7 listener)

    Thanks in advance,

    -Rachna
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Rachna Vaidya
    INET: rachnavaidya_at_hotmail.com

    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: ListGuru_at_fatcity.com (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: kirti.deshpande_at_verizon.com

    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: ListGuru_at_fatcity.com (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).
  • Rachna Vaidya at Oct 16, 2002 at 7:23 pm
    Thanks for the inputs.
    This is how I did it.

    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

    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))

    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))

    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"
    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: slee_at_dollar.com

    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: ListGuru_at_fatcity.com (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: rachnavaidya_at_hotmail.com

    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: ListGuru_at_fatcity.com (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).
  • Rachna Vaidya at Oct 16, 2002 at 7:44 pm
    Hmm,

    The db7 (upgraded to 817) automatically registers itself to listener.
    Why?

    And, changing the PORT, wouldn't I need to change all tnsnames.ora ?
    Nabil, your and Kirti's suggestion for one listener has this
    particular benefit.

    Still thinking.........I am.....

    -Rachna

    Original Message -----
    To: "'Rachna Vaidya'"
    Sent: Wednesday, October 16, 2002 2:33 PM
    again,

    I think its better to use one listener. Unless you have some reason for
    needed two of them.

    just me 2 cents

    :-)

    nabil

    -----Original Message-----
    From: Rachna Vaidya
    Sent: Wednesday, October 16, 2002 1:21 PM
    To: LazyDBA.com Discussion
    Subject: Re: Multiple Listeners


    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 -----
    From: "Stephen Lee"
    To: "Multiple recipients of list ORACLE-L"
    Sent: Wednesday, October 16, 2002 2:39 PM
    Subject: RE: Multiple Listeners

    -----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: slee_at_dollar.com

    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: ListGuru_at_fatcity.com (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).
    --------
    Oracle documentation is here:
    http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
    To unsubscribe: send a blank email to oracledba-unsubscribe_at_LAZYDBA.com
    To subscribe: send a blank email to oracledba-subscribe_at_LAZYDBA.com
    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
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Rachna Vaidya
    INET: rachnavaidya_at_hotmail.com

    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: ListGuru_at_fatcity.com (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).
  • Rachna Vaidya at Oct 16, 2002 at 7:50 pm
    Hmm,

    The db7 (upgraded to 817) automatically registers itself to listener.
    Why?

    And, changing the PORT, wouldn't I need to change all tnsnames.ora ?
    Nabil, your and Kirti's suggestion for one listener has this
    particular benefit.

    Still thinking.........I am.....

    Original Message -----
    To: "'Rachna Vaidya'"
    Sent: Wednesday, October 16, 2002 2:33 PM
    again,

    I think its better to use one listener. Unless you have some reason for
    needed two of them.

    just me 2 cents

    :-)

    nabil
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Rachna Vaidya
    INET: rachnavaidya_at_hotmail.com

    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: ListGuru_at_fatcity.com (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).
  • John Weatherman at Oct 16, 2002 at 7:59 pm
    I respectfully disagree. I am currently working on a Sun 4500
    cluster with Veritas. The cluster services each maintain their
    own nic/ip, that's 1 per instance. Obviously, each instance
    also has its own listener. This has been very easy to implement
    and not at all confusing. It also avoids things like where you
    can't use a 8.0.5+ listener for 8.0.4- instances. Each SID has
    its own listener at its own version level. I would suggest
    coming up with a good standard for determining ports and such
    however. For instance, I use 15 concatenated with the last 2
    digits of the assigned IP.

    Before walking into the cluster world, I would have agreed with
    Tom. Of course now I have seperate HOMEs for each instance too.

    John P Weatherman
    Database Administrator
    Replacements Ltd.

    -----Original Message-----
    Sent: Wednesday, October 16, 2002 2:40 PM
    To: Multiple recipients of list ORACLE-L

    Rachna,

    Do yourself a favor - use the most recent listener for all databases. Have
    only one listener running on a machine and use that for all databases on
    that machine. In your case, use the 817 listener.

    In the long run, it will be much easier and less confusing.

    Hope this helps.

    Tom Mercadante
    Oracle Certified Professional

    -----Original Message-----
    Sent: Wednesday, October 16, 2002 2:13 PM
    To: Multiple recipients of list ORACLE-L

    DBAs,

    Any quick start guides / scripts / notes for having multiple version
    listeners on same Solaris box?

    Scenario :
    I am in process of upgrading.
    There are two databases on a machine db6 and db7
    db6 <---------> 8.1.6
    db7 <---------> 8.1.6
    db6 and db7 use the "listener" of version 8.1.6

    Now,
    db7 migrated to 8.1.6
    I am thinking of something like :
    db6 <---------> listener of 8.1.6 (status quo)
    db7 <---------> listener_817 of 8.1.7 (new version listener)

    Two separate listener.ora files

    lsnrctl status listener (for 8.1.6 listener)
    lsnrctl status listener_817 (for 8.1.7 listener)

    Thanks in advance,

    -Rachna
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Rachna Vaidya
    INET: rachnavaidya_at_hotmail.com

    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: ListGuru_at_fatcity.com (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: Mercadante, Thomas F
    INET: NDATFM_at_labor.state.ny.us

    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: ListGuru_at_fatcity.com (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: John Weatherman
    INET: john.weatherman_at_replacements.com

    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: ListGuru_at_fatcity.com (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).
  • John Weatherman at Oct 16, 2002 at 7:59 pm
    Not always. 8.0.5+ listeners can not be used with 8.0.4- databases...

    John P Weatherman
    Database Administrator
    Replacements Ltd.

    -----Original Message-----
    Sent: Wednesday, October 16, 2002 2:40 PM
    To: Multiple recipients of list ORACLE-L

    You can use the 'higher' version of the listener for all databases running
    on <= higher version, unless you need multiple listeners for other
    reasons.... Net8 Admin Guide should have enough information.

    Kirti

    -----Original Message-----
    Sent: Wednesday, October 16, 2002 1:13 PM
    To: Multiple recipients of list ORACLE-L

    DBAs,

    Any quick start guides / scripts / notes for having multiple version
    listeners on same Solaris box?

    Scenario :
    I am in process of upgrading.
    There are two databases on a machine db6 and db7
    db6 <---------> 8.1.6
    db7 <---------> 8.1.6
    db6 and db7 use the "listener" of version 8.1.6

    Now,
    db7 migrated to 8.1.6
    I am thinking of something like :
    db6 <---------> listener of 8.1.6 (status quo)
    db7 <---------> listener_817 of 8.1.7 (new version listener)

    Two separate listener.ora files

    lsnrctl status listener (for 8.1.6 listener)
    lsnrctl status listener_817 (for 8.1.7 listener)

    Thanks in advance,

    -Rachna
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Rachna Vaidya
    INET: rachnavaidya_at_hotmail.com

    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: ListGuru_at_fatcity.com (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: kirti.deshpande_at_verizon.com

    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: ListGuru_at_fatcity.com (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: John Weatherman
    INET: john.weatherman_at_replacements.com

    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: ListGuru_at_fatcity.com (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).
  • Deshpande, Kirti at Oct 16, 2002 at 8:14 pm
    That's because of the new feature of Auto Registration with Listener...
    I guess, it's about time to review docs for changes in 8i Release 2
    (8.1.7)... there could be more such surprises :)

    Kirti

    -----Original Message-----
    Sent: Wednesday, October 16, 2002 2:50 PM
    To: Multiple recipients of list ORACLE-L

    Hmm,

    The db7 (upgraded to 817) automatically registers itself to listener.
    Why?

    And, changing the PORT, wouldn't I need to change all tnsnames.ora ?
    Nabil, your and Kirti's suggestion for one listener has this
    particular benefit.

    Still thinking.........I am.....

    Original Message -----
    To: "'Rachna Vaidya'"
    Sent: Wednesday, October 16, 2002 2:33 PM
    again,

    I think its better to use one listener. Unless you have some reason for
    needed two of them.

    just me 2 cents

    :-)

    nabil
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Rachna Vaidya
    INET: rachnavaidya_at_hotmail.com

    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: ListGuru_at_fatcity.com (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: kirti.deshpande_at_verizon.com

    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: ListGuru_at_fatcity.com (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).
  • Reginald.W.Bailey_at_jpmorgan.com at Oct 16, 2002 at 8:20 pm
    It is better to have a single Listener per server, unless you have multiple
    servers that use high availability fail over between the servers. The
    single listener should be the most recent one on the server. It is
    backwards compatible with Oracle8i versions and Oracle7 databases. There
    is no need to run multiple listeners on the same server, especially when
    the versions are just one release off from each other (e.g. 8.1.6 and
    8.1.7). A single listener and a single Intelligent Agent should be all
    that is needed. It may be clever to see if multiple listeners can run, but
    even Oracle will tell you that running multiple listeners is worse than
    foolish.:) In addition to changing the Oracle Home, the LD_LIBRARY_PATH or
    LIBPATH would have to be changed as well to match the libraries to the
    correct version of the listener.

    Trust me, you only need one version of the Listener up. I have three
    versions of Oracle on a server: Oracle7, Oracle8i v8.1.7 and Oracle9i
    v9.2.0. I use the Oracle9i listener and agent on the servers. It allows
    seamless connections to all the databases.

    RWB

    "Rachna Vaidya" @fatcity.com on 10/16/2002
    02:23:35 PM

    Please respond to ORACLE-L_at_fatcity.com

    Sent by: root_at_fatcity.com

    To: Multiple recipients of list ORACLE-L
    cc:

    Thanks for the inputs.
    This is how I did it.

    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

    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))

    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))

    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"
    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: slee_at_dollar.com

    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: ListGuru_at_fatcity.com (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: rachnavaidya_at_hotmail.com

    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: ListGuru_at_fatcity.com (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:
    INET: Reginald.W.Bailey_at_jpmorgan.com

    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: ListGuru_at_fatcity.com (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).
  • Stephen Lee at Oct 16, 2002 at 8:32 pm

    -----Original Message-----

    The db7 (upgraded to 817) automatically registers itself to listener.
    Why?

    And, changing the PORT, wouldn't I need to change all tnsnames.ora ?
    Nabil, your and Kirti's suggestion for one listener has this
    particular benefit.
    I have seen later versions of the listener find instances on the box and
    automatically listen for them on port 1521. I don't remember the exact
    version that this start happening since I'm not good at remembering these
    kinds of facts. What appears to be happening is the spread of the Microsoft
    philosophy of "Oh here. Let us HELP you with that ... whether you like or
    not."

    The reason we use a listener to match the version of the database is that,
    around here, Murphy has a B-I-G desk, in a corner office, and he works 24
    hours per day, 7 days per week.

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Stephen Lee
    INET: slee_at_dollar.com

    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: ListGuru_at_fatcity.com (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).
  • Deshpande, Kirti at Oct 16, 2002 at 8:37 pm
    May be that was one of bugs in 8.0.5..

    At present we have 9.0.1 listener for 7.3.4, 8.1.6, 8.1.7.2, 8.1.7.3,
    8.1.7.4 and 9.0.1 databases on
    HP-UX. Not a problem.

    Kirti

    -----Original Message-----
    Sent: Wednesday, October 16, 2002 3:00 PM
    To: Multiple recipients of list ORACLE-L

    Not always. 8.0.5+ listeners can not be used with 8.0.4- databases...

    John P Weatherman
    Database Administrator
    Replacements Ltd.

    -----Original Message-----
    Sent: Wednesday, October 16, 2002 2:40 PM
    To: Multiple recipients of list ORACLE-L

    You can use the 'higher' version of the listener for all databases running
    on <= higher version, unless you need multiple listeners for other
    reasons.... Net8 Admin Guide should have enough information.

    Kirti

    -----Original Message-----
    Sent: Wednesday, October 16, 2002 1:13 PM
    To: Multiple recipients of list ORACLE-L

    DBAs,

    Any quick start guides / scripts / notes for having multiple version
    listeners on same Solaris box?

    Scenario :
    I am in process of upgrading.
    There are two databases on a machine db6 and db7
    db6 <---------> 8.1.6
    db7 <---------> 8.1.6
    db6 and db7 use the "listener" of version 8.1.6

    Now,
    db7 migrated to 8.1.6
    I am thinking of something like :
    db6 <---------> listener of 8.1.6 (status quo)
    db7 <---------> listener_817 of 8.1.7 (new version listener)

    Two separate listener.ora files

    lsnrctl status listener (for 8.1.6 listener)
    lsnrctl status listener_817 (for 8.1.7 listener)

    Thanks in advance,

    -Rachna
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Rachna Vaidya
    INET: rachnavaidya_at_hotmail.com

    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: ListGuru_at_fatcity.com (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: kirti.deshpande_at_verizon.com

    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: ListGuru_at_fatcity.com (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: John Weatherman
    INET: john.weatherman_at_replacements.com

    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: ListGuru_at_fatcity.com (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: kirti.deshpande_at_verizon.com

    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: ListGuru_at_fatcity.com (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).
  • Gesler, Rich at Oct 16, 2002 at 8:49 pm
    This is a platform specific statement. What you said is correct for TRU64.

    -----Original Message-----
    Sent: Wednesday, October 16, 2002 4:00 PM
    To: Multiple recipients of list ORACLE-L

    Not always. 8.0.5+ listeners can not be used with 8.0.4- databases...

    John P Weatherman
    Database Administrator
    Replacements Ltd.

    -----Original Message-----
    Sent: Wednesday, October 16, 2002 2:40 PM
    To: Multiple recipients of list ORACLE-L

    You can use the 'higher' version of the listener for all databases running
    on <= higher version, unless you need multiple listeners for other
    reasons.... Net8 Admin Guide should have enough information.

    Kirti

    -----Original Message-----
    Sent: Wednesday, October 16, 2002 1:13 PM
    To: Multiple recipients of list ORACLE-L

    DBAs,

    Any quick start guides / scripts / notes for having multiple version
    listeners on same Solaris box?

    Scenario :
    I am in process of upgrading.
    There are two databases on a machine db6 and db7
    db6 <---------> 8.1.6
    db7 <---------> 8.1.6
    db6 and db7 use the "listener" of version 8.1.6

    Now,
    db7 migrated to 8.1.6
    I am thinking of something like :
    db6 <---------> listener of 8.1.6 (status quo)
    db7 <---------> listener_817 of 8.1.7 (new version listener)

    Two separate listener.ora files

    lsnrctl status listener (for 8.1.6 listener)
    lsnrctl status listener_817 (for 8.1.7 listener)

    Thanks in advance,

    -Rachna
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Rachna Vaidya
    INET: rachnavaidya_at_hotmail.com

    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: ListGuru_at_fatcity.com (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: kirti.deshpande_at_verizon.com

    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: ListGuru_at_fatcity.com (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: John Weatherman
    INET: john.weatherman_at_replacements.com

    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: ListGuru_at_fatcity.com (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: Gesler, Rich
    INET: RGesler_at_lexington.com

    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: ListGuru_at_fatcity.com (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).
  • Stephen Lee at Oct 16, 2002 at 9:05 pm

    -----Original Message-----
    even Oracle will tell you that running multiple listeners is
    worse than
    foolish.:)
    Please supply the link to Oracle's article with this statement.

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Stephen Lee
    INET: slee_at_dollar.com

    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: ListGuru_at_fatcity.com (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).
  • Ramon E. Estevez at Oct 16, 2002 at 9:19 pm
    You are right Kirti

    This is a new feature of 8i. It also does it in 9i.

    Ramon

    -----Original Message-----
    Kirti
    Sent: Wednesday, October 16, 2002 3:15 PM
    To: Multiple recipients of list ORACLE-L

    That's because of the new feature of Auto Registration with Listener...
    I guess, it's about time to review docs for changes in 8i Release 2
    (8.1.7)... there could be more such surprises :)

    Kirti

    -----Original Message-----
    Sent: Wednesday, October 16, 2002 2:50 PM
    To: Multiple recipients of list ORACLE-L

    Hmm,

    The db7 (upgraded to 817) automatically registers itself to listener.
    Why?

    And, changing the PORT, wouldn't I need to change all tnsnames.ora ?
    Nabil, your and Kirti's suggestion for one listener has this particular
    benefit.

    Still thinking.........I am.....

    Original Message -----
    To: "'Rachna Vaidya'"
    Sent: Wednesday, October 16, 2002 2:33 PM
    again,

    I think its better to use one listener. Unless you have some reason
    for needed two of them.

    just me 2 cents

    :-)

    nabil
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Rachna Vaidya
    INET: rachnavaidya_at_hotmail.com

    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: ListGuru_at_fatcity.com (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: kirti.deshpande_at_verizon.com

    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: ListGuru_at_fatcity.com (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: Ramon E. Estevez
    INET: com.banilejas_at_codetel.net.do

    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: ListGuru_at_fatcity.com (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).
  • John Weatherman at Oct 16, 2002 at 9:19 pm
    -----Original Message-----
    Sent: Wednesday, October 16, 2002 4:20 PM

    A single listener and a single Intelligent Agent should be all
    that is needed. It may be clever to see if multiple listeners can run, but
    even Oracle will tell you that running multiple listeners is worse than
    foolish.:) In addition to changing the Oracle Home, the LD_LIBRARY_PATH or
    LIBPATH would have to be changed as well to match the libraries to the
    correct version of the listener.

    -----New Stuff----

    Yes, I cut a lot. :) I will agree that having 1 listener per box is all
    you _should_ need. However, due to experience with past bugs (and who knows

    when similar problems may appear in the future) and as you concede, running
    high availability fail over services, I would disagree with the assertion
    that
    multiple listeners are "worse than foolish". A single listener is a single
    point of failure across multiple instances, eliminating that is not foolish,
    and there are other reasons one might want to run multiple listeners. What
    about extproc (if you need it for some reason). Oracle itself _requires_ 3
    listeners for the apps the last time I checked (1 for the db, 2 for external

    program calls). To analyze network traffic, it is sometimes useful to be
    able
    to isolate particular port traffic. Multiple listeners allow for this kind
    of work too.

    So, while only 1 may be all that is necessary, there is no real reason,
    IMHO,

    that multiple listeners are inherently a bad practice.

    John P Weatherman
    Database Administrator
    Replacements Ltd.
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: John Weatherman
    INET: john.weatherman_at_replacements.com

    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: ListGuru_at_fatcity.com (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).
  • Stephen Lee at Oct 16, 2002 at 9:19 pm

    -----Original Message-----
    but
    even Oracle will tell you that running multiple listeners is
    worse than
    foolish.:)

    Trust me, you only need one version of the Listener up.
    From O'Reilly's "Oracle Net8 Configuration and Troubleshooting" book, pages
    70 - 71, under the sub-topic "Why Use Multiple Listeners?":

    Even though one listener may be all you need, there are some management
    advantages to using more than one: redundancy and separation of
    environments.

    Two listeners can be used to provide redundancy in case one fails. .... Such
    a configuration not only protects you from the failure of one listener, it
    also enables you to more easily make changes that require a listener to be
    restarted. ...

    Separation of environments is another reason to use multiple listeners. If
    you have two databases running on a server, you may not want any part of
    those two database environments intertwined. That way, if you need to
    restart the listener for one database, you don't affect users of the other.
    ...

    End of quote.

    I might add, if you have multiple versions of Oracle running on a box and
    need to patch a version in such a way that requires a complete relinking of
    that version, you can stop only the processes associated with that version.

    The decision to run multiple listeners was not my decision to make here.
    But having worked in this environment for a while, I can say that it has
    never been a problem.

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Stephen Lee
    INET: slee_at_dollar.com

    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: ListGuru_at_fatcity.com (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).
  • Reginald.W.Bailey_at_jpmorgan.com at Oct 16, 2002 at 11:44 pm
    Okay, I will concede the point. Sometimes having multiple listeners can be
    a good thing. Although running older versions of the listener may not be.
    But you pay your money and you take your chances. Thank you for those who
    cited published sources. Please remember: what an Oracle analyst will tell
    you on the phone and what is printed in the documentation do not always
    match. If you have ever had a torturous TAR then you know what I mean.

    RWB

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author:
    INET: Reginald.W.Bailey_at_jpmorgan.com

    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: ListGuru_at_fatcity.com (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).
  • Deshpande, Kirti at Oct 17, 2002 at 1:18 am
    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.

    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

    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))

    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))

    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"
    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: slee_at_dollar.com

    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: ListGuru_at_fatcity.com (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: rachnavaidya_at_hotmail.com

    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: ListGuru_at_fatcity.com (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: kirti.deshpande_at_verizon.com

    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: ListGuru_at_fatcity.com (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).
  • John Hallas at Oct 17, 2002 at 12:04 pm
    There has been much discussion regarding single or multiple listeners
    and there seems to be a split between those who advocate one method over
    the other.
    I am currently working at a site with a large number of
    systems/databases.


    They are well organised and one of the standards that is in place is to
    have a listener per database with the same name as the database.
    The lowest port will be 1526 to avoid any issues with auto registration
    on port 1521.


    The whole concept works very well in my experience; the small overhead
    on the server is outweighed by the ability to stop a listener
    individually without affecting any other service.


    John

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: John Hallas
    INET: john.hallas_at_hcresources.co.uk

    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: ListGuru_at_fatcity.com (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).
  • Rachna Vaidya at Oct 17, 2002 at 12:41 pm
    Here are my current findings....

    Auto Registration :

    Auto Registration takes place with default listener when....

    local_listener="(ADDRESS=(PROTOCOL=TCP)HOST=lightening)(PORT=1526))"
    When the above line was NOT present in init.ora of the database (db7)
    for whcih the second listener is configured, the database Auto registered
    with the old listener (v816, PORT=1521) too. So, that I could connect to
    the database through both listeners.

    2. Auto Registration does NOT take place with default listener when....

    local_listener="(ADDRESS=(PROTOCOL=TCP)HOST=lightening)(PORT=1526))"
    When the above line was present in init.ora of the database (db7)
    for whcih the second listener is configured, the database Auto registered
    with the new listener. So, now I could connect to the database through
    the new listener only!

    Multiple Listeners :

    Is it possible to have single listener?
    You can use the 'higher' version of the listener for all databases
    running on <= higher version, unless you need multiple listeners
    for other reasons.... Net8 Admin Guide should have enough information.
    So, using signel v817 listener for v817 as well as v816 databases was
    possible.

    2. What's involved in configuring multiple listeners?

    There are metalink docs explaining it in details, But in short :
    They have to be of different names.
    Explicit name needs to be used for non default (name other than LISTENER)
    listeners while using lsnrctl command.
    They need to be listening on different ports.
    The KEY value for IPC needs to be different in each listener.ora.

    3. Why I decided to run single listener in the end?

    When I was running two listeners, each was listening on different ports.
    Initially, I had only one listener at PORT=1521.
    So all my client side configuration in tnsnames.ora were pointing
    to PORT=1521. Now with this second listener listening at PORT=1526,
    I would have needed to change all of my client side configuration.
    (We are not using Names Server currently.)

    Thanks for the discussion!

    -Rachna

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Rachna Vaidya
    INET: rachnavaidya_at_hotmail.com

    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: ListGuru_at_fatcity.com (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).
  • Stephen Lee at Oct 17, 2002 at 2:44 pm

    -----Original Message-----
    Okay, I will concede the point. Sometimes having multiple
    listeners can be
    a good thing.
    An example:

    (NOTHING)/etc> ps -eo args | grep smon

    ora_smon_CATT2
    ora_smon_CRCD1
    ora_smon_CRCT1
    ora_smon_DEMO
    ora_smon_DEVL
    ora_smon_DRTD
    ora_smon_DRTD1
    ora_smon_DRTT
    ora_smon_DRTT1
    ora_smon_DSNR2
    ora_smon_DSNR4
    ora_smon_DWHD
    ora_smon_FFLD
    ora_smon_FFLT1
    ora_smon_FLCD
    ora_smon_FTLD
    ora_smon_FTLT
    ora_smon_HLPT
    ora_smon_INTD
    ora_smon_MOBT
    ora_smon_PWRT
    ora_smon_RSAD
    ora_smon_RTWD
    ora_smon_TIMD

    And there are some adhoc databases on the box that are shut down.

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Stephen Lee
    INET: slee_at_dollar.com

    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: ListGuru_at_fatcity.com (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).
  • Hemant K Chitale at Oct 17, 2002 at 3:39 pm
    On most servers I have only one database on the node.
    Where I do have multiple databases, I have seperate ORACLE_HOMEs. Where I
    have
    seperate ORACLE_HOMEs, I have seperate Listeners.
    There's really not much of an effort in managing multiple listeners --
    after all
    you have to issue a seperate sqlplus command for each database [and
    also
    from a seperate ORACLE_HOME each time !], you can also issue a seperate
    "lsnrctl start " command.
    I could be running 8.1.7.2, 8.1.7.3 and 9.2.0.1 on the same box.
    When applying
    a patchset to upgrade to 8.1.7.3 or 8.1.7.4 for one database, I do
    not want to have
    to stop access to the other databases.  Therefore, each database has
    it's own listener.
    Also, try _not_ to use 1521 as the listener port so that no database
    auto-registers
    with a listener.
    Hemant
    At 04:04 AM 17-10-02 -0800, you wrote:
    There has
    been much discussion regarding single or multiple listeners and there
    seems to be a split between those who advocate one method over the
    other.

    I am currently working at a site with a large
    number of systems/databases.



    They are well organised and one of the
    standards that is in place is to have a listener per database with the
    same name as the database.

    The lowest port will be 1526 to avoid any
    issues with auto registration on port 1521.



    The whole concept works very well in my
    experience; the small overhead on the server is outweighed by the ability
    to stop a listener individually without affecting any other
    service.



    John

    Hemant K Chitale
    My web site page is :
    http://hkchital.tripod.com

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Hemant K Chitale
    INET: hkchital@singnet.com.sg

    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: ListGuru@fatcity.com (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).
  • Stephen Andert at Oct 24, 2002 at 11:28 pm
    Test first!!!!

    We discovered a bug on Tru64 that prevented this from working correctly
    in at least a couple versions of Oracle. 8.1.7 was suppossed to fix
    this, but it didn't. 8.1.7.3 did *I think*.
    kirti.deshpande_at_verizon.com 10/16/02 11:39AM >>>
    You can use the 'higher' version of the listener for all databases
    running
    on <= higher version, unless you need multiple listeners for other
    reasons.... Net8 Admin Guide should have enough information.

    Kirti

    -----Original Message-----
    Sent: Wednesday, October 16, 2002 1:13 PM
    To: Multiple recipients of list ORACLE-L

    DBAs,

    Any quick start guides / scripts / notes for having multiple version
    listeners on same Solaris box?

    Scenario :
    I am in process of upgrading.
    There are two databases on a machine db6 and db7
    db6 <---------> 8.1.6
    db7 <---------> 8.1.6
    db6 and db7 use the "listener" of version 8.1.6

    Now,
    db7 migrated to 8.1.6
    I am thinking of something like :
    db6 <---------> listener of 8.1.6 (status quo)
    db7 <---------> listener_817 of 8.1.7 (new version listener)

    Two separate listener.ora files

    lsnrctl status listener (for 8.1.6 listener)
    lsnrctl status listener_817 (for 8.1.7 listener)

    Thanks in advance,

    -Rachna
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Rachna Vaidya
    INET: rachnavaidya_at_hotmail.com

    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: ListGuru_at_fatcity.com (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: kirti.deshpande_at_verizon.com

    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: ListGuru_at_fatcity.com (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: Stephen Andert
    INET: stephenandert_at_firsthealth.com

    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: ListGuru_at_fatcity.com (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).

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedOct 16, '02 at 6:12p
activeOct 24, '02 at 11:28p
posts26
users12
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase