Chinaunix首页 | 论坛 | 博客
  • 博客访问: 522000
  • 博文数量: 134
  • 博客积分: 7990
  • 博客等级: 少将
  • 技术积分: 1290
  • 用 户 组: 普通用户
  • 注册时间: 2007-10-29 11:43
文章分类

全部博文(134)

文章存档

2009年(7)

2008年(80)

2007年(47)

我的朋友

分类: Oracle

2007-12-20 21:10:57

Verify TNS Networking Files


  Ensure that the TNS networking files are configured on both Oracle RAC nodes in the cluster!


listener.ora

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

Here 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 =%                                   
            
            
阅读(1271) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~