This discussion is archived
4 Replies Latest reply: May 23, 2013 1:46 PM by PRaju RSS

TNS error with RAC

Walashkar Newbie
Currently Being Moderated
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 Employee ACE
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    Try removing (INSTANCE_NAME=PROD1), (INSTANCE_NAME=PROD2) and keeping just SERVICE_NAME.
  • 4. Re: TNS error with RAC
    PRaju Newbie
    Currently Being Moderated
    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)*
    *)*
    *)*

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points