Hi all,

We have Apps 11.0.3, Oracle 8.0.5 on NT 4.

We have single Oracle Home and only one TNSNAMES.ORA file.

SID,instance name is TEST but I see foll. error msg in sqlnet.log.

Fatal OSN Connect Error 12154, Connecting to : PROD even though there is an entry of TEST in tnsnames.ora i.e TEST.tsr and TEST.trm, it searches for PROD.

Because of this, I am unable to sign on in my Oracle Application.

I checked TNSNAMES.ora file. There is no reference of PROD.

Can someone tell me from where it tries to look for PROD instance instead of TEST?

Thanks in advance

Sam