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

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


There will need to be a tnsnames file with an entry for your database on
every machine involved - servers and clients.

Richard Knapp
Database Programmer/Analyst
Institutional Research and Planning
University of Missouri System
573-882-8856
knappr@umsystem.edu

-----Original Message-----
From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org
[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of
Paul Delange
Sent: Tuesday, January 24, 2006 8:36 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] (SQR 5528) ORACLE OCIServerAttach error 12154 in
cursor 0: 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

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