Re: TNS 3505 - tnsnames.ora problem

"Neil Cudd" <neil.cudd_at_blueyonder.co.uk> schreef in bericht news:52eae8e0-70df-4e46-a66e-ca97add9cceb_at_s50g2000hsb.googlegroups.com...
> Hi there,
> hope someone's listening on a Sunday ..
>
> Oracle V9.2.0.6 on Solaris 8
>
> I'm trying to configure dataguard and setting up the tnsnames.ora for
> the primary and standby databases.
> On the primary database the current tnsnames.ora config for the db in
> question looks like this :
>
> LIVE =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.1.144)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVER=DEDICATED)
> (SERVICE_NAME = live)
> )
> )
> This works ok - tnsping etc ...
> now when I try to add an entry for <dbname>_PRIMARY or
> <dbname)_STANDBY, I get a TNS-3505 Failed to resolve name.
> I tried various combinations, and eventually I just tried amending the
> above stanza so it reads :
>
> LIVE1 =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.1.144)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVER=DEDICATED)
> (SERVICE_NAME = live)
> )
> )
> When I tnsping LIVE1 :
> $ tnsping LIVE1
> TNS Ping Utility for Solaris: Version 9.2.0.6.0 - Production on 06-
> APR-2008 13:32:44
> Copyright (c) 1997 Oracle Corporation. All rights reserved.
> Used parameter files:
> /app/oracle/product/9206/network/admin/sqlnet.ora
> TNS-03505: Failed to resolve name
>
> sqlnet.ora has only SQLNET.EXPOIRE_TIME = 2 in it.
>
>
> Any help appreciated - my downtime window last for another 2 hours ...
>

First try this:
Change the name to LIVE1 as you did and perform a tnsping to LIVE (not LIVE1).
If LIVE is still found, you might have an other TNSNAMES.ORA somewhere on your system.

Shakespeare Received on Mon Apr 07 2008 - 03:12:34 CDT