Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-12154 intermittently

Re: ORA-12154 intermittently

From: Chuck <chuckh_at_softhome.net>
Date: Tue, 20 Aug 2002 11:12:26 -0400
Message-ID: <ajtm8r$1ek4od$1@ID-85580.news.dfncis.de>


It just occurred to me that I didn't mention explicitly how we are resolving database service names, though it could be derived from the config files. We are using oracle names for database service name resolution.

--
Chuck

"Chuck" <chuckh_at_softhome.net> wrote in message
news:ajtm2o$1e6kuf$1_at_ID-85580.news.dfncis.de...

> I am intermittently getting "ORA-12154: TNS:could not resolve service
name"
> when trying to connect to a database with sqlplus 9.0.1.0.1. If I try to
> connect to the same database again it works without changing anything. I
get
> the error every other time I try to connect.I am using exact copies of my
> client config files that I used with sqlplus 8.1.7.0 and never had the
> problem with version 8. Anyone know what's going on?
>
> Here is sample output from sqlplus...
>
> H:\>sqlplus /nolog
>
> SQL*Plus: Release 9.0.1.0.1 - Production on Tue Aug 20 11:00:31 2002
>
> (c) Copyright 2001 Oracle Corporation. All rights reserved.
>
> SQL> connect user/password_at_maxima40
> Connected.
> SQL> connect user/password_at_maxima40
> ERROR:
> ORA-12154: TNS:could not resolve service name
>
>
> Warning: You are no longer connected to ORACLE.
> SQL> connect user/password_at_maxima40
> Connected.
> SQL> connect user/password_at_maxima40
> ERROR:
> ORA-12154: TNS:could not resolve service name
>
>
> Warning: You are no longer connected to ORACLE.
> SQL>
>
> Here are the sqlnet.ora and sdns.ora files. There is no tnsnames.ora file
> (we never use one.). This same configuration worked perfectly with an 8i
> client.
>
> sdns.ora
> ========
> \ = (ADDRESS=(PROTOCOL=IPC)(KEY=ONAMES))
> onames_oz = (ADDRESS=(PROTOCOL=tcp)(HOST=oz)(PORT=1575))
> onames_dbs2 = (ADDRESS=(PROTOCOL=tcp)(HOST=dbs2)(PORT=1575))
>
>
> sqlnet.ora
> ==========
> # SQLNET.ORA Network Configuration File:
> E:\oracle\ora817\NETWORK\ADMIN\sqlnet.ora
> # Generated by Oracle configuration tools.
>
> SQLNET.AUTHENTICATION_SERVICES= (NTS)
>
>
Received on Tue Aug 20 2002 - 10:12:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US