-
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
Fabio Arienzo
Rome (Italy)
-
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
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
Fabio Arienzo
Rome (Italy)
-
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))
)
)
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
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.....
Fabio Arienzo
Rome (Italy)
-
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
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
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.
Fabio Arienzo
Rome (Italy)
-
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.
Fabio Arienzo
Rome (Italy)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|