10g RAC：tnsnames.ora

Adamhuan 2014年9月9日 No Comments

这里，仅罗列针对Oracle RAC情况下的TNS(本地服务名）的配置文件的状态：

[root@node1 ~]# su - oracle
[oracle@node1 ~]$ cd $ORACLE_HOME/network/admin
[oracle@node1 admin]$ ll
total 16
-rw-r--r-- 1 oracle oinstall  575 Sep  5 20:11 listener.ora
drwxr-x--- 2 oracle oinstall 4096 Sep  5 19:27 samples
-rw-r--r-- 1 oracle oinstall  172 Dec 26  2003 shrept.lst
-rw-r--r-- 1 oracle oinstall 1226 Sep  5 20:47 tnsnames.ora
[oracle@node1 admin]$ cat tnsnames.ora 
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/10/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

LISTENERS_RACDB =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = node1-vip)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = node2-vip)(PORT = 1521))
  )

RACDB2 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = node2-vip)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = RACDB)
      (INSTANCE_NAME = RACDB2)
    )
  )

RACDB1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = node1-vip)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = RACDB)
      (INSTANCE_NAME = RACDB1)
    )
  )

RACDB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = node1-vip)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = node2-vip)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = RACDB)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

[oracle@node1 admin]$

[root@node1 ~]# su - oracle

[oracle@node1 ~]$ cd $ORACLE_HOME/network/admin

[oracle@node1 admin]$ ll

total 16

-rw-r--r-- 1 oracle oinstall 575 Sep 5 20:11 listener.ora

drwxr-x--- 2 oracle oinstall 4096 Sep 5 19:27 samples

-rw-r--r-- 1 oracle oinstall 172 Dec 26 2003 shrept.lst

-rw-r--r-- 1 oracle oinstall 1226 Sep 5 20:47 tnsnames.ora

[oracle@node1 admin]$ cat tnsnames.ora

# tnsnames.ora Network Configuration File: /u01/app/oracle/product/10/dbhome_1/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

LISTENERS_RACDB =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = node1-vip)(PORT = 1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = node2-vip)(PORT = 1521))

)

RACDB2 =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = node2-vip)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = RACDB)

(INSTANCE_NAME = RACDB2)

)

RACDB1 =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = node1-vip)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = RACDB)

(INSTANCE_NAME = RACDB1)

)

RACDB =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = node1-vip)(PORT = 1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = node2-vip)(PORT = 1521))

(LOAD_BALANCE = yes)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = RACDB)

)

EXTPROC_CONNECTION_DATA =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

)

(CONNECT_DATA =

(SID = PLSExtProc)

(PRESENTATION = RO)

)

[oracle@node1 admin]$

其中，
IP地址方面，node1-vip与node2-vip在RAC中属于公共资源。
数据库方面，“(SERVICE_NAME = RACDB)”也是在集群的各个节点上的呈现都是一致的；只有“INSTANCE_NAME”会根据不同的节点而不同。
————————————————————————
Ending。

打赏