2 Replies Latest reply: Feb 21, 2013 1:07 AM by 581293 RSS

    Listener Issue in 10gR2

    581293
      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
          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
            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.