FreeLists / oracle-l / Re: RAC VB Application TNS Alias

["Jeremy Paul Schneider" <jeremy.schneider@xxxxxxxxxxxxxx>]

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