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

["Paul Delange" <Paul.Delange@cami.ca>]

In this case the client and the server are the same machine. I am running
my SQR on the Oracle db server for speed reasons. SQR executables are
located on a different machine.

BTW, the SQR runs fine on my workstation.

Thanks, and let me know if you have other ideas!



|---------+------------------------------------------------>
|         |           "Knapp, Richard"                     |
|         |           <KnappR@umsystem.edu>                |
|         |           Sent by:                             |
|         |           sqr-users-bounces+paul.delange=cami.c|
|         |           a@sqrug.org                          |
|         |                                                |
|         |                                                |
|         |           01/24/2006 10:01 AM                  |
|         |           Please respond to "This list is for  |
|         |           discussion about the SQR database    |
|         |           reporting       language from        |
|         |           Hyperion Solutions."                 |
|         |                                                |
|---------+------------------------------------------------>
  
>----------------------------------------------------------------------------------------------|
  |                                                                             
                 |
  |       To:       "This list is for discussion about the SQR database 
reportinglanguage from   |
  |        Hyperion Solutions." <sqr-users@sqrug.org>                           
                 |
  |       cc:                                                                   
                 |
  |       Subject:  RE: [sqr-users] (SQR 5528) ORACLE OCIServerAttach error 
12154 in  cursor 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







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