Tnsnames config

[farienzo]

Hi all,
I'm trying to test a client connect string with two different hostname address (where just one is on) , so, like explain in Oracle Net Manual (8.1.7) I expect Net8 should try to use the first host available.
The behavior it's right only if the node in on-line status is the first one, otherwise, reverting the two hostname I get tns-12535 Operation time out.
It seems , It just try the first address and without switch to try the second one!!!

This is the connect string :
DBX =
(DESCRIPTION =
(ADDRESS_LIST = (ADDRESS =(PROTOCOL = TCP)(Host = node1)(Port = 1521))
(ADDRESS_LIST = (ADDRESS =(PROTOCOL = TCP)(Host = node2)(Port = 1521))
)
(CONNECT_DATA = (SID=DBPD) (SERVER=DEDICATED))
))

Any suggestion ?

Thanks in advance

[julian]

OPS, right?

[farienzo]

It will be Fail Safe configuration on cluster, but I would like to know if the connection works right without FailSafe on server , just testing two different address using the on-line one.

Thanks

[julian]

Originally posted by farienzo
It will be Fail Safe configuration on cluster, but I would like to know if the connection works right without FailSafe on server , just testing two different address using the on-line one.

Thanks

Then you are NOW, not aiming for Failsafe but for FMD (= Failover with Multiple Descriptions). Try this:

DBX =
(DESCRIPTION_LIST =
(FAILOVER = true)
(LOAD_BALANCE = false)
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =(PROTOCOL = TCP)(Host = node1)(Port = 1521))
)
(CONNECT_DATA = (SERVICE_NAME = node1))
)
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =(PROTOCOL = TCP)(Host = node2)(Port = 1521))
)
(CONNECT_DATA = (SERVICE_NAME = node2))
)
)

[farienzo]

Thank you Julian,
I guess there is something wrong on the sintax, It returns TNS-03506 Failed to create address binding

I can't solve it.....

[julian]

Try to follow these Oracle rules:

a. the alias name must start in column 1 otherwise: sqlplus fails ORA-12154: TNS:could not resolve service name tnsping fails TNS-03505: Failed to resolve name

b. the DESCRIPTION may start in column 1 but is not required to be


c. the ADDRESS_LIST must start from column 2 onwards otherwise: sqlplus fails ORA-12154: TNS:could not resolve service name tnsping fails TNS-03506: Failed to create address binding


d. all other sections must start from column 2 onwards otherwise: sqlplus fails ORA-06401: NETCMN: invalid driver designator tnsping fails TNS-03506: Failed to create address binding

e. the final closing parentheses may be in column 1 but is not required to be

[farienzo]

OK Julian,
now I tuned the sintax but the problem still remain.

It returns: tns-12535 tns: Operation time out

It seems it doesn't switch to the second host address !!

I guess it's just client problem, right ?

Thanks again.

[farienzo]

Hi all,
I solved the question,
using sqlplus connection everything works fine,
I discovered that TNSPING command doesn't support several nodes connections on same service.
Thanks again.