[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

[sqr-users] (SQR 5528) ORACLE OCIServerAttach error 12154 in cursor0: but TNSNAMES.ORA is correct!

Hi All,

I'm trying to run an SQR off our db server for speed reasons & get the
following error;

(SQR 5528) ORACLE OCIServerAttach error 12154 in cursor 0:
   ORA-12154: TNS:could not resolve service name
(SQR 4701) Cannot logon to the database.

There is only one TNSNAMES.ORA file on this box & it does contain the
database in question. I suppose it's concievable that SQR is somehow
finding a TNSNAMES file on the network (somewhere) that is not uptodate.

I can login the the database on the same machine with SQLPlus no problem.

Can anyone shed some light on this? Is there a setting I can make that will
SQR look on the local drive for tnsnames.ora?

Thanks, Paul



_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users