ORA-12514 TNS Client problem....

From: Eddie Hernandez <eddie.hernandez_at_mdintouch.com>
Date: 2000/04/24
Message-ID: <3904C845.7E75278F@mdintouch.com>#1/1

I have an 8.1.6 database which has a rogue client calling it every 10-15 minutes with a misconfigured TNSNAMES.ORA file. I would like to fix the client, only problem is I don't know which machine it is. I believe its an automated client but we have quite a few that call the db. HEre's the only clues I have.....

within Alert.log file

---

Mon Apr 24 15:18:12 2000
Errors in file F:\disk1\mdd\bdump\mddRECO.TRC: ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor

within reco.trc file

---

• 2000-04-24 15:18:12.281 ERROR, tran=14.86.54, session#=1, ose=0: ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor

I went into OEM and looked up session#1 thinking it would tell me what client is causing this but it didn't help much...this is what I found

SessionID=1
Status=Active
Username=
OS User=SYSTEM
MachineName=<host name of db>
Program=Oracle.exe

any help would be appreciated....

thx,
-Eddie Hernandez
Received on Mon Apr 24 2000 - 00:00:00 CDT