4 Replies Latest reply: May 23, 2013 3:46 PM by PRaju RSS

    TNS error with RAC

    Walashkar
      Dear all,

      11.5.10.2 on DB RAC 10.2.0.5

      We are getting the below error :
       tnsping PROD_806_BALANCE
      
      TNS Ping Utility for Linux: Version 8.0.6.3.0 - Production on 13-MAR-2013 22:55:58
      
      (c) Copyright 1997 Oracle Corporation.  All rights reserved.
      
      TNS-03507: Failure looking for ADDRESS keyword
      tnsnames. ora contains.
      PROD_806_BALANCE=
          (DESCRIPTION_LIST=
              (DESCRIPTION=
                      (ADDRESS=(PROTOCOL=tcp)(HOST=MEDVIPdb1.imanational.com)(PORT=1521))
                  (CONNECT_DATA=
                      (SERVICE_NAME=PROD)
                      (INSTANCE_NAME=PROD1)
                  )
              )
              (DESCRIPTION=
                      (ADDRESS=(PROTOCOL=tcp)(HOST=MEDVIPdb2.imanational.com)(PORT=1521))
                  (CONNECT_DATA=
                      (SERVICE_NAME=PROD)
                      (INSTANCE_NAME=PROD2)
                  )
              )
          )
      from the database server, the same entry is working fine
      tnsping PROD_806_BALANCE
      
      TNS Ping Utility for Linux IA64: Version 10.2.0.5.0 - Production on 13-MAR-2013 23:06:48
      
      Copyright (c) 1997,  2010, Oracle.  All rights reserved.
      
      
      
      
      Used TNSNAMES adapter to resolve the alias
      Attempting to contact (DESCRIPTION_LIST= (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=MEDVIPdb1.imanational.com)(PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=PROD) (INSTANCE_NAME=PROD1))) (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=MEDVIPdb2.imanational.com)(PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=PROD) (INSTANCE_NAME=PROD2))))
      OK (0 msec)
      Any idea ?

      Edited by: 936074 on Mar 13, 2013 1:21 PM
        • 1. Re: TNS error with RAC
          Hussein Sawwan-Oracle
          Can you ping "MEDVIPdb1.imanational.com" and MEDVIPdb2.imanational.com" from the application server?

          Did you follow all the steps in (Configuring Oracle Applications Release 11i with Oracle10g Release 2 Real Application Clusters and Automatic Storage Management [ID 362135.1])?

          Thanks,
          Hussein
          • 2. Re: TNS error with RAC
            alvaromiranda
            hello

            first check the pings as the previous post suggest,

            what call my attention here, is why the rac nodes looks like are using the hostname instead of vip ??

            what is the vip hostname for those servers?

            when you enabled rac, did you pass the vip hostname?

            did you run autoconfig on both db nodes and app later?

            Alvaro.
            • 3. Re: TNS error with RAC
              user397464
              Try removing (INSTANCE_NAME=PROD1), (INSTANCE_NAME=PROD2) and keeping just SERVICE_NAME.
              • 4. Re: TNS error with RAC
                PRaju
                Hi ,

                As previous Gurus said , make sure your vipca execution status,

                Typical load balance entry should be like below,


                PROD_806_BALANCE=
                *(DESCRIPTION=*
                *(ADDRESS_LIST=*
                *(LOAD_BALANCE=YES)*
                *(FAILOVER=YES)*
                *(ADDRESS=(PROTOCOL=tcp)(HOST=MEDVIPdb1-vip.imanational.com)(PORT=1521))*
                *(ADDRESS=(PROTOCOL=tcp)(HOST=MEDVIPdb2-vip.imanational.com)(PORT=1521))*
                *)*
                *(CONNECT_DATA=*
                *(SERVICE_NAME=PROD)*
                *)*
                *)*