Monday, September 21, 2009

RAC 10g: Adding Listener OCR and TNS-admin

In 10g is is not possible to do this.
To add a listener to the RAC node you need NETCA to do this.
This tool will ceate the listener and does the OCR registration.

TNS_ADMIN is often used as a user environment variable on database servers. If you are using this
variable in a RAC environment, you need to set this in the cluser respository (OCR).

Do this by using the following command:
servctl setenv database -d db_name -t TNS_ADMIN=tns_admin_path
With 11.1, you can now use the srvctl add listener command to add the listener resource to the OCR. However, it’s simpler to use NETCA

rac-server1$ export ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1 rac-server1$ export PATH=/bin:rac-server1$ netca /silent /responsefile /network/install/netca_typ.rsp /nodeinfo rac-server5

Click on RAC 10g: Adding Listener OCR and TNS-admin for more information