This discussion is archived
2 Replies Latest reply: Feb 20, 2013 11:07 PM by 581293 RSS

Listener Issue in 10gR2

581293 Newbie
Currently Being Moderated
Hi,

We have the following RAC setup for two databases ( ORACLE1 which is an ERP database & ORACLE2 which is a non ERP database)

1. Two Node RAC database ORACLE1 (ERP) running with 10.2.0.4 CRS on Node1 & Node2
2. Two Node RAC database ORACLE2 (Non ERP) running with 10.2.0.3 on Node1 & Node2

Case1:

After creating the database ORACLE2 using DBCA, the following has been observed.

1. There is a Listener entry of ORACLE1 database in the listener.ora of ORACLE2 instance.
2. There are entries of VIP & port of ORACLE1 database in the tnsnames.ora of ORACLE2 instance.
3. The listener of ORACLE2 instance doesn't start unless an entry is placed in the listener_ifile.ora of ORACLE1 instance.


Case2
1. ORACLE1 is autoconfig enabled , however, the listener is not picking up the listener.ora from $ORACLE_HOME/network/admin/$CONTEXT_NAME directory. However it works fine when a softlink is created from $ORACLE_HOME/network/admin directory to $ORACLE_HOME/network/admin/$CONTEXT_NAME.

Is this the expected behavior or something wrong with the setup.
  • 1. Re: Listener Issue in 10gR2
    Jos van den Oord Newbie
    Currently Being Moderated
    Correct in crs 10g it is not possible to configure the listener to use a tns_admin. The same as it is not possible to use add listener command.
    In 11g it is possible to this see [centralize TNS_NAMES|http://joordsblog.vandenoord.eu/2011/01/central-tnsnamesora-inside-rac-using.html]
    This is also possible for the listener "srvctl setenv listener -l LISTENER_JOORDS -t TNS_ADMIN=/usr/sql/tns

    Cheers Jos
    joordsblog
  • 2. Re: Listener Issue in 10gR2
    581293 Newbie
    Currently Being Moderated
    Hi Jos,

    Thanks for your answers. However , the TNS_ADMIN is correctly configured in my case for both the instances.

    The question here is , without the entry in the listener_ifile.ora of ORACLE1 instance , the listner of ORACLE2 instance doesn't start.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points