Re: RAC VB Application TNS Alias

The connect string looks correct.

What are the init params REMOTE_LISTENERS and LOCAL_LISTENER set to on both
instances?  You might check to see if you're running into this problem:
http://www.ardentperf.com/2007/04/02/local_listener-and-ora-12545/



On 4/27/07, Sanjay Mishra <smishra_97@xxxxxxxxx> wrote:


Hi

I am having 10g RAC with service name ldptsrv created and here is the
status of service on one of the Oracle RAC node

"/export/home/oracle"> srvctl status service -d LDPDB
Service ldptsrv is running on instance(s) LDPDB1, LDPDB2

I can connect to the service with Sqlplus and here is Service entry in
Tnsnames.ora file
ldptsrv =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = ldpsrv1-vip)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = ldpsrv2-vip)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ldptsrv )
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )


Now on the Client side, I am running VB application and using Oracle 10g
Client with TNS entry like shown below
ldptsrv =
  (DESCRIPTION =
   (LOAD_BALANCE = YES)(FAILOVER = YES)
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ldpsrv1-vip)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = ldpsrv2-vip)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ldptsrv )
    )
  )

Now I can see that if I try to access the VP application, it is sometime
connecting but sometime failed and I checked that Sqlnet log sometime shows
ldpsrv2 and sometime ldpsrv1 when it failed to connect with 12545 errors

Am I using right TNS String

TIA
Sanjay

------------------------------
Ahhh...imagining that irresistible "new car" smell?
Check out new cars at Yahoo! 
Autos.<http://us.rd.yahoo.com/evt=48245/*http://autos.yahoo.com/new_cars.html;_ylc=X3oDMTE1YW1jcXJ2BF9TAzk3MTA3MDc2BHNlYwNtYWlsdGFncwRzbGsDbmV3LWNhcnM->





--
Jeremy Schneider
Chicago, IL
http://www.ardentperf.com/category/technical

Other related posts: