Re: Cannot logon to the database error ORA-12154

[david allen <dave.allen@USI.NET>]

Make sure Tsnnames is set up to recognize the database you are logging onto.  Check with DBA to insure the correct name is being used

-----Original Message-----
From:   Charu Srinivas [SMTP:C._Srinivas/dsisys/US@DSISYS.COM]
Sent:   Wednesday, December 09, 1998 1:37 PM
To:     Multiple recipients of list SQR-USERS
Subject:        Cannot logon to the database error ORA-12154

Hi everybody,
                               My customer is using SQR 3.0.18.1,
PeopleSoft ver 5.12, Oracle 7.3.4 on Windows NT.
We are trying to install SQRW on one of the clients and when we run an SQR
and click on the OK button, we get the following error:
 SQR 4701           Cannot logon to the database.
SQR 5528 ORACLE ORLON error ORA-12154 in cursor 0:
 Error while trying to retrieve text for error ORA -12154

The SQRDIR is set in the SQR.ini file. The path has the ORACLE bin
directory and the pstools.ini also has the SQRDIR set correctly.

I have no more ideas on how to proceed. So any suggestions or thoughts will
be greatly appreciated.

Thanks in advance.

Charu