Home » Server Options » RAC & Failsafe » RAC tnsnames.ora
RAC tnsnames.ora [message #613388] Tue, 06 May 2014 04:36
asp_
Messages: 7
Registered: April 2014
Location: msk
Junior Member
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

Previous Topic: Cost in explain plan
Next Topic: ASM mirroring
Goto Forum:
  


Current Time: Tue Sep 30 16:28:12 CDT 2014

Total time taken to generate the page: 0.09304 seconds