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