Hello. I have 2 nodes of 11.2.0.3 oracle RAC and oracle client 11.1.0 (not 11.2.0 version because EMC Documentum support 11.1.0).
at folder network/admin i have only sqlnet and tnsnames files.
I used search and google too, but I can't completly understand how to configure tnsnames.ora
My task is to minimize downtime if one of the nodes fails
tnsnames.ora where EMC Documentum installed:
DOCU11 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac-scan)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = docu11)
)
)
LISTENERS_DOCU11 =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.*.*.102)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.*.*.101)(PORT = 1521))
)
DOCU111 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.*.*.102)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = docu11)
(INSTANCE_NAME = docu111)
)
)
DOCU112 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.*.*.101)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = docu11)
(INSTANCE_NAME = docu112)
)
)
____________________
cs-rac-test2:~/bin$ echo $ORACLE_SID
docu11
sqlnet
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
ADR_BASE =/u01/oracle
DNS:
rac2-n1 IN A 10.*.*.97
rac2-n2 IN A 10.*.*.99
rac1-priv IN A 192.168.220.1
rac2-priv IN A 192.168.220.2
rac1-vip IN A 10.*.*.101
rac2-vip IN A 10.*.*.102
rac-scan IN A 10.*.*.103
rac-scan IN A 10.*.*.104
Do I need to paste string (FAILOVER=ON) and some prererences for failover?
And one more question.
What is correct string if I want to use thin client?
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.*.*.102)(PORT = 1521))(ADDRESS=(PROTOCOL=TCP)(HOST=10.*.*.101)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=docu11)))
[Updated on: Tue, 06 May 2014 04:50]
Report message to a moderator
] 
Blog
Search
Help
Members
Register
Login
Home
