分类: Oracle
2007-12-20 21:10:57
Ensure that the TNS networking files are configured on both Oracle RAC nodes in the cluster!
listener.oraWe already covered how to create a TNS listener configuration file (listener.ora) for a clustered environment in the section Create TNS Listener Process. The listener.ora file should be properly configured and no modifications should be needed.For clarity, I included a copy of the listener.ora file from my node linux1:
listener.ora # listener.ora.linux1 Network Configuration File: # /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora.linux1 # Generated by Oracle configuration tools. LISTENER_LINUX1 = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = linux1-vip)(PORT = 1521)(IP = FIRST)) (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.100)(PORT = 1521)(IP = FIRST)) ) )
tnsnames.oraHere is a copy of my tnsnames.ora file that was configured by Oracle. This file should already be configured on both of the Oracle RAC nodes in the RAC cluster.You can include any of these entries on other client machines that need access to the clustered database.
tnsnames.ora # tnsnames.ora Network Configuration File: # /u01/app/oracle/product/11.1.0/db_1/network/admin/tnsnames.ora # Generated by Oracle configuration tools. LISTENERS_ORCL = (ADDRESS_LIST =%阅读(1300) | 评论(0) | 转发(0) |给主人留下些什么吧!~~