Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

TNS 3505 - tnsnames.ora problem

333 views
Skip to first unread message

Neil Cudd

unread,
Apr 6, 2008, 8:31:06 AM4/6/08
to
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 ...

Neil Cudd

unread,
Apr 6, 2008, 9:06:41 AM4/6/08
to
Strangely, setting the TNS_ADMIN variable works :-/

anyone explain to me why that would work ?

I have an identical setup on the standby server and that does not have
TNS_ADMIN set and still works ????

Thanks for any help,
Neil.

Ana C. Dent

unread,
Apr 6, 2008, 3:21:55 PM4/6/08
to
Neil Cudd <neil...@blueyonder.co.uk> wrote in news:a8d0681d-eed9-4b21-
a4c8-41b...@q27g2000prf.googlegroups.com:

It might have something to do with the contents of sqlnet.ora;
then again it might be something different.

Neil Cudd

unread,
Apr 7, 2008, 3:48:04 AM4/7/08
to
On 6 Apr, 20:21, "Ana C. Dent" <anaced...@hotmail.com> wrote:
> Neil Cudd <neil.c...@blueyonder.co.uk> wrote in news:a8d0681d-eed9-4b21-
> a4c8-41b23f64c...@q27g2000prf.googlegroups.com:

>
> > Strangely, setting the TNS_ADMIN variable works :-/
>
> > anyone explain to me why that would work ?
>
> > I have an identical setup on the standby server and that does not have
> > TNS_ADMIN set and still works ????
>
> > Thanks for any help,
> > Neil.
>
> It might have something to do with the contents of sqlnet.ora;
> then again it might be something different.

that misspelling of EXPIRE is not in the actual sqnet.ora ...

I'm flummoxed .... I think that's how it's spelt ...

Shakespeare

unread,
Apr 7, 2008, 4:12:34 AM4/7/08
to

"Neil Cudd" <neil...@blueyonder.co.uk> schreef in bericht
news:52eae8e0-70df-4e46...@s50g2000hsb.googlegroups.com...

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


0 new messages