TNS 3505 - tnsnames.ora problem

From: Neil Cudd <neil.cudd_at_blueyonder.co.uk>
Date: Sun, 6 Apr 2008 05:31:06 -0700 (PDT)
Message-ID: <52eae8e0-70df-4e46-a66e-ca97add9cceb@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 ... Received on Sun Apr 06 2008 - 07:31:06 CDT

Original text of this message