Re: ORA-12514 TNS Client problem....

it looks like the problem does not come from any client... I would check all database links and check tns aliases are all defined in tnsnames in the server !!

Eddie Hernandez wrote:

> 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 Thu May 04 2000 - 00:00:00 CEST