Error while trying to retrieve text for error ORA-12222

[dbawork]

I can connect to a Oracle 7.2 database using SQL_Plus 3.2 but thru PL/SQL Developer I get
"Error while trying to retrieve text for error ORA-12222". I have checked the TNSNames.ORA and it has the correct descriptor address.
This problem came after I reinstalled Oracle 7.2 last week. Yeah, 7.2 is still alive at my work.

Would appreciate any help. Thanks!

 

[Marco Kalter]

Since the text for this error cannot be retrieved, it would seem that there is something wrong with the installation of the Oracle Home that PL/SQL Developer is using.

Can you start PL/SQL Developer without connecting, go to Help > About, press the 'Info' button, press the 'Copy all pages' button on this info screen, and paste this text into an e-mail reply?

 

[dbawork]

Here is the what I got from Help>About...
Thanks for the help though.

--- Info ---

PL/SQL Developer
Version 5.1.4.728 (MBCS)
13.16288 - 5 user license
Windows XP version 6.0 (build 2600) Service Pack 1

Physical memory : 523,568 kB (48,676 available)
Paging file : 887,356 kB (510,344 available)
Virtual memory : 2,097,024 kB (2,051,260 available)

Parameters
C:\Program Files\PLSQL Developer\PLSQLDev.exe

Preferences
Session mode: Multi
OCI Library:
Use OCI7: True

Plug-Ins

Aliases

Homes

DLLs
C:\ORANT\bin\oci.dll
C:\ORANT\bin\ORA72.DLL
C:\ORANT\bin\ORA803.DLL
C:\ORANT\bin\ORA804.DLL
C:\ORANT\bin\ORA805.DLL
C:\ORANT\bin\ORANT71.DLL

TNS File
C:\ORANT\Net80\Admin\tnsnames.ora

Using
Home: T:MENBS:BSS
DLL: C:\ORANT\bin\oci.dll
OCI: Version 7.3

--- Registry ---

SOFTWARE\ORACLE
ORACLE_HOME = C:\ORANT
API = C:\ORANT\DBS
NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1
ORACLE_GROUP_NAME = Oracle for Windows NT
RDBMS72 = C:\ORANT\RDBMS72
MSHELP_TOOLS = C:\ORANT\MSHELP
VS10 = C:\ORANT\BIN
RDBMS72_CONTROL = C:\ORANT\DATABASE
RDBMS72_ARCHIVE = C:\ORANT\DATABASE\ARCHIVE
ORACLE_SID = BSS
PLSQL22 = C:\ORANT\PLSQL22
PRO17 = C:\ORANT\PRO17
NLSRTL31 = C:\ORANT\NLSRTL31
ORA_NLS = C:\ORANT\NLSRTL31\DATA
ORA_ORCL_PWFILE = C:\ORANT\DATABASE\PWDORCL.ORA
SQLPATH = C:\ORANT\DBS
PLUS32 = C:\ORANT\PLUS32
EXECUTE_SQL = PLUS32
PRO21 = C:\ORANT\PRO21

SOFTWARE\ORACLE\SECURITY
ORA_ORCL_STARTMODE = TRUE

--- Path ---

C:\ORANT\bin
C:\WINDOWS\system32
C:\WINDOWS
C:\WINDOWS\System32\Wbem
C:\Program Files\Microsoft SQL Server\80\Tools\BINN

C:\ORAWIN\BIN

--- TNS names ---

 

[dbawork]

Marco,

The script above tells me that the pathname to the TNSNames.ora is incorrect. It should be C:\orant\NETWORK\ADMIN\TNSNames.ora instead.
How do I set it right?

 

[Marco Kalter]

Can you go to Tools > Preferences > Options tab page, select ora72.dll from the OCI Library list, restart PL/SQL Developer, and try again?

This may fix both problems (error message + tnsnnames.ora).

 

[dbawork]

Marco,

That fixed it. This is a big relief. In fact, I did not even have to restart it. But I will anyways.
Thanks a ton for the help.