[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 12154in cursor 0: but TNSNAMES.ORA is correct!
TNS issues are a game of cat and mouse sometimes. Setting up the proper TNS
entry on all machines is a good start.
I'd also try moving a working .sqr file to the DB server where your SQRw.exe
is located to see if for some reason SQR is looking for a TNS file on the file
server.
As for what should be in an ini file, since your workstation is working, I'd
look for the .ini file on your workstation and compare with the one on the DB
server. Make sure to back up the one you change.
Kyle
On Tue, 24 Jan 2006 10:19:53 -0500, Paul Delange wrote
> 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
___________________________________
Kyle J. Leonard
kyle.leonard@1answersolutions.com
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users