Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-12154 intermittently
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...Received on Tue Aug 20 2002 - 10:12:26 CDT
> 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)
>
>
![]() |
![]() |