ORA-12154 intermittently

From: Chuck <chuckh_at_softhome.net>
Date: Tue, 20 Aug 2002 11:06:30 -0400
Message-ID: <ajtltu$1ds019$1@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:06:30 CDT