No question at this time
DBA Top 10
1 M. Cadot 6500
2 B. Vroman 2700
3 J. PĂ©ran 1600
4 P. Tsongayinwe 1500
5 P. Wisse 1200
6 A. Kavsek 1100
7 D. Walgude 400
7 J. Schnackenberg 400
9 J. Alcroft 200
10 A. Hudspith 100
10 D. Johnson 100
10 B. B 100
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48695
Total active users1320
Act. users last 24h0
Act. users last hour0
Registered user hits last week12
Registered user hits last month347
Go up

Multiple Connection DESCRIPTION in tnsnames.ora file
Next thread: how to add temp file in oracle 11g rac2 asm
Prev thread: QUERY OPTIMIZATION

Message Score Author Date
Hi Professionals, I have following connection s...... imran raza Jan 16, 2014, 08:48
Is this not what is happening? If not add "(FAI...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Michel Cadot Jan 16, 2014, 09:32
Thanks Michel, Please see my new connection str...... imran raza Jan 16, 2014, 09:57
Yes, I think so. Regards Michel ... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Michel Cadot Jan 16, 2014, 10:09
Thanks, DB1 and DB2 both are RAC Databases havi...... imran raza Jan 16, 2014, 10:23
There is no overall best practices as it depends...... Michel Cadot Jan 16, 2014, 10:29

Follow up by mail Click here


Subject: Multiple Connection DESCRIPTION in tnsnames.ora file
Author: imran raza, Pakistan
Date: Jan 16, 2014, 08:48, 3183 days ago
Os info: Oracle 11G
Oracle info: RHEL 5.8
Message: Hi Professionals,

I have following connection string in tnsnames.ora file for the two Different Databases DB1 and DB2, these databases exist on different machines. In my case user session is created on any of nodes of DB1 or any of the node of DB2. Our requirement is to prefer the DB1. If connection fail to all nodes of DB1 then sessions should try to connect to DB2 nodes. Kindly help me for that.

NAME=
(DESCRIPTION_LIST=
(DESCRIPTION=
(CONNECT_TIMEOUT=60)(RETRY_COUNT=3)
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=SCAN_IP1)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=SCAN_IP2)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=SCAN_IP3)(PORT=1521)))
(LOAD_BALANCE = yes)
(CONNECT_DATA=(SERVICE_NAME=DB1)))
(DESCRIPTION=
(CONNECT_TIMEOUT=60)(RETRY_COUNT=1)
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=SCAN_IP1)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=SCAN_IP2)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=SCAN_IP3)(PORT=1521)))
(LOAD_BALANCE = yes)
(CONNECT_DATA=(SERVICE_NAME=DB2))))


Thanks & Regards
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Multiple Connection DESCRIPTION in tnsnames.ora file
Author: Michel Cadot, France
Date: Jan 16, 2014, 09:32, 3183 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message:
Is this not what is happening?
If not add "(FAILOVER=on)" but it is normaly the default value.

Regards
Michel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Multiple Connection DESCRIPTION in tnsnames.ora file
Author: imran raza, Pakistan
Date: Jan 16, 2014, 09:57, 3183 days ago
Message: Thanks Michel,

Please see my new connection string:

EXADATA1=
(DESCRIPTION_LIST=(LOAD_BALANCE=OFF)(FAILOVER=ON)
(DESCRIPTION=
(CONNECT_TIMEOUT=3)(TRANSPORT_CONNECT_TIMEOUT=2)(RETRY_COUNT=3)
(ADDRESS_LIST=(LOAD_BALANCE=ON)(FAILOVER=ON)
(ADDRESS=(PROTOCOL=tcp)(HOST=SCANIP1)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=SCANIP2)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=SCANIP3)(PORT=1521)))
(CONNECT_DATA=(SERVICE_NAME=DB1)))
(DESCRIPTION=
(CONNECT_TIMEOUT=5)(TRANSPORT_CONNECT_TIMEOUT=3)(RETRY_COUNT=3)
(ADDRESS_LIST=(LOAD_BALANCE=ON)(FAILOVER=ON)
(ADDRESS=(PROTOCOL=tcp)(HOST=SCANIP1)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=SCANIP2)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=SCANIP3)(PORT=1521)))
(CONNECT_DATA=(SERVICE_NAME=Db2))))

I added (LOAD_BALANCE=OFF)(FAILOVER=ON) after (DESCRIPTION_LIST=

I think (LOAD_BALANCE=OFF) handles it to try DB1 nodes first and in case no DB1 node is available then sessions look for DB2 nodes.

Am I right in my concepts?

Regards
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Multiple Connection DESCRIPTION in tnsnames.ora file
Author: Michel Cadot, France
Date: Jan 16, 2014, 10:09, 3183 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message:
Yes, I think so.

Regards
Michel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Multiple Connection DESCRIPTION in tnsnames.ora file
Author: imran raza, Pakistan
Date: Jan 16, 2014, 10:23, 3183 days ago
Message: Thanks,

DB1 and DB2 both are RAC Databases having 4 nodes each. Is the connection string according to the RAC best practices?


Regards
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Multiple Connection DESCRIPTION in tnsnames.ora file
Author: Michel Cadot, France
Date: Jan 16, 2014, 10:29, 3183 days ago
Message:
There is no overall best practices as it depends on your environment but the parameters you gave are correct. Now the values (timeout, retries...) depend on your requirements and hardware and workload.

Regards
Michel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here