Tnsnames config
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Tnsnames config

  1. #1
    Join Date
    May 2001
    Location
    Rome - Italy
    Posts
    24
    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)

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    OPS, right?
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

  3. #3
    Join Date
    May 2001
    Location
    Rome - Italy
    Posts
    24
    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)

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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
    email: ocp_9i@yahoo.com

  5. #5
    Join Date
    May 2001
    Location
    Rome - Italy
    Posts
    24
    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)

  6. #6
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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
    email: ocp_9i@yahoo.com

  7. #7
    Join Date
    May 2001
    Location
    Rome - Italy
    Posts
    24
    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)

  8. #8
    Join Date
    May 2001
    Location
    Rome - Italy
    Posts
    24
    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
  •  



Click Here to Expand Forum to Full Width