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

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

Thanks to all for these responses.

I added a TNS_ADMIN environmental variable - it bit dangerous since this is
an Oracle server used by many - but it worked, now my SQR runs and there
have been no fires yet!

Thanks again, Paul


|---------+------------------------------------------------>
|         |           "the dragon" <ceprn@hotmail.com>     |
|         |           Sent by:                             |
|         |           sqr-users-bounces+paul.delange=cami.c|
|         |           a@sqrug.org                          |
|         |                                                |
|         |                                                |
|         |           01/24/2006 10:27 AM                  |
|         |           Please respond to "This list is for  |
|         |           discussion about the SQR database    |
|         |           reporting       language from        |
|         |           Hyperion Solutions."                 |
|         |                                                |
|---------+------------------------------------------------>
  
>----------------------------------------------------------------------------------------------|
  |                                                                             
                 |
  |       To:       sqr-users@sqrug.org                                         
                 |
  |       cc:                                                                   
                 |
  |       Subject:  RE: [sqr-users] (SQR 5528) ORACLE OCIServerAttach error 
12154in   cursor 0:  |
  |        but TNSNAMES.ORA is correct!                                         
                 |
  
>----------------------------------------------------------------------------------------------|




I'd troubleshoot first by trying a tnsping off the box that the sqr
executable was running on.  That's the first place I look when I have tns
issues.  If it doesn't connect, then recreate the stanza in the
tnsnames.ora.  For some bizarre reason, in very rare instances, the stanza
*looks* correct but it won't work.

peace,
clark 'the dragon' willis



PSA: Salary <> Slavery. If you earn a salary, your employer is renting your

services for 40 hours a week, not purchasing your soul. Your time is the
only real finite asset that you have, and once used it can never be
recovered, so don't waste it by giving it away.

I work to live; I don't live to work.

"Time is the coin of your life. It is the only coin you have, and only you
can determine how it will be spent. Be careful lest you let other people
spend it for you."

Carl Sandburg
(1878 - 1967)


----Original Message Follows----


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!



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-----

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

_________________________________________________________________
Don't just search. Find. Check out the new MSN Search!
http://search.msn.click-url.com/go/onm00200636ave/direct/01/


_______________________________________________
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