10g RAC:tnsnames.ora
这里,仅罗列针对Oracle RAC情况下的TNS(本地服务名)的配置文件的状态:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 |
[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。