ORA-12222

[winex]

I am having problems logging into PL/SQL Developer. Whenever I attempt to sign in, I get the following message:

Error while trying to retrieve text for error ORA-12222

The tnsnames.ora on this machine is correct, and SQL*Plus has no problem connecting to my databases. Also, the drop down list on the sign on screen does pick up all of my database names from the tnsnames.ora .

The error occurs after I put in my login and password. (Both are valid and correctly typed)

The INFO page shows the following:

PL/SQL Developer
Version 6.0.3.893 (MBCS)
01.16967 - 10 user license
Windows XP version 6.0 (build 2600) Service Pack 1

Physical memory : 523,252 kB (298,544 available)
Paging file : 1,280,164 kB (1,082,488 available)
Virtual memory : 2,097,024 kB (2,043,684 available)

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

Preferences
Session mode: Multi
OCI Library: C:\oracle\ora92\bin\ora805.dll
Use OCI7: False

Plug-Ins

Aliases
AOMC
BEQ-LOCAL
BHC
CMEXAMPLE
crdgux
...

Homes
OraHome92 (C:\oracle\ora92)

DLLs
C:\oracle\ora92\bin\oci.dll
C:\oracle\ora92\bin\ora805.dll

TNS File
C:\oracle\ora92\Net80\Admin\tnsnames.ora

Using
Home: OraHome92
DLL: C:\oracle\ora92\bin\ora805.dll
OCI: Version 8.0

Any help with this problem is appreciated.

Thanks.

 

[winex]

Note: Before starting this thread, I found and read http://www.allroundautomations.com/ubb/ultimatebb.php?ubb=get_topic;f=3;t=000870#000000

Unfortunately, the solution mentioned there did not help. I would appreciate any assistance tech. support can offer.

Thanks.

 

[Marco Kalter]

What happens if you start PL/SQL Developer without logging on, go to Tools > Preferences > Connection page, clear the OCI Library preference, restart PL/SQL Developer, and try again?

 

[winex]

Marco, thanks for replying.

I just cleared out OCI Library and still have the same problem.

For the record, my preferences in that screen are as follows:

Session Mode: Multi Session
Logoff with open transaction: Commit
Check Connection is unchecked
OraHome is set to OraHome92. (This is correct, and it is a single home Oracle environment)
OCI Library is now empty
Force OCI7 mode on OCI8 is unchecked

 

[Marco Kalter]

Can you send me the complete text from the Info page again, like in your first post?

 

[winex]

Here you go. I'll include complete information from all the tabs:

Info

PL/SQL Developer
Version 6.0.3.893 (MBCS)
01.16967 - 10 user license
Windows XP version 6.0 (build 2600) Service Pack 1

Physical memory : 523,252 kB (69,848 available)
Paging file : 1,280,164 kB (770,980 available)
Virtual memory : 2,097,024 kB (2,030,316 available)

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

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

Plug-Ins

Aliases
AOMC
BEQ-LOCAL
BHC
CMEXAMPLE
crdgux
...

Homes
OraHome92 (C:\oracle\ora92)

DLLs
C:\oracle\ora92\bin\oci.dll
C:\oracle\ora92\bin\ora805.dll

TNS File
C:\oracle\ora92\Net80\Admin\tnsnames.ora

Using
Home: OraHome92
DLL: C:\oracle\ora92\bin\oci.dll
OCI: Version 8.0

Registry

SOFTWARE\ORACLE
inst_loc = C:\Program Files\Oracle\Inventory
ORACLE_HOME = C:\oracle\ora92
ORACLE_HOME_NAME = OraHome92
API = C:\oracle\ora92\dbs
ORACLE_GROUP_NAME = Oracle - OraHome92
NLS_LANG = NA
OLEDB = C:\oracle\ora92\oledb\mesg
VOBHOME2.0 = C:\oracle\ora92
OO4O = C:\oracle\ora92\oo4o\mesg

SOFTWARE\ORACLE\ALL_HOMES
HOME_COUNTER = 1
DEFAULT_HOME = OraHome92
LAST_HOME = 0

SOFTWARE\ORACLE\ALL_HOMES\ID0
NAME = OraHome92
PATH = C:\oracle\ora92
NLS_LANG = NA

SOFTWARE\ORACLE\AUTOTUNE9.2.0
help_path = ${vobhome2.0}bin/
debug_flags =
startlog = ${home}autotune/%1.log
trace_report = 0
trace_data = 0
collect_int_in_min = 15
analyze_int_in_hrs = 24
max_errors_allowed = 5
wip_batch = 0
wip_window = 0
wip_logfile = 0
wip_logtable = 0

SOFTWARE\ORACLE\EXPERT9.2.0
home = ${vobhome2.0}sysman/expert
help_path = ${vobhome2.0}bin/
xpcoin = ${vobhome2.0}bin/xpcoin
default_rule_file = xpo000
debug_flags =
sample = ${home}sample/
sample_xdl = ${sample}xppso.xdl
startlog = ${vobhome2.0}sysman/temp/xpexpert.log
trace_report = 0
trace_data = 0
max_orphan_txn_reqs = 100
max_cache_txn_reqs = 50
extract_explain_plan = 0
create_tmp_plan_table = 0
tmp_plan_table = xp_tmp_plan
wip_batch = 0
wip_window = 1
wip_logfile = 0
wip_logtable = 0
quicktour_start = ${vobhome2.0}classes/oracle/sysman/qtour/tune/us/tune.htm
report_viewer = write
startup_wizard = 1
collect_trace_stats = 1
standalone_mode = 0

SOFTWARE\ORACLE\HOME0
ID = 0
ORACLE_GROUP_NAME = Oracle - OraHome92
ORACLE_HOME_NAME = OraHome92
ORACLE_HOME = C:\oracle\ora92
NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252
ORACLE_BUNDLE_NAME = Enterprise
ORAMTS_CP_TRACE_LEVEL = 0
ORAMTS_CP_TRACE_DIR = C:\oracle\ora92\oramts\Trace
ORAMTS_CONN_POOL_TIMEOUT = 120
ORAMTS_SESS_TXNTIMETOLIVE = 120
ORAMTS_NET_CACHE_MAXFREE = 5
ORAMTS_NET_CACHE_TIMEOUT = 120000
ORAMTS_OSCREDS_MATCH_LEVEL = OS_AUTH_LOGIN
SQLPATH = C:\oracle\ora92\dbs
ORACLE_HOME_KEY = Software\ORACLE\HOME0
MSHELP_TOOLS = C:\oracle\ora92\MSHELP

SOFTWARE\ORACLE\iSQLPlus
ServerCount = ServerURIColWidth =

 

[Marco Kalter]

The Oracle client does not seem correct. In an Oracle 9.2 home you have Oracle 8.0 libraries. Perhaps you need to reinstall the Oracle Client?

 

[winex]

It's worth a shot. I will give it a try a little later today and get back with you. Interestingly enough, I have no problem connecting in either SQL*Plus or a demo version of TOAD.

 

[winex]

Marco, sorry for the slow response. I have had some other priorities that prevented me from uninstalling and reinstalling the 9i client.

In any event, that did the trick. I am now able to use PL/SQL Developer. It appears that the 805 stuff that the PL/SQL Developer didn't like was something left over from an Oracle Discoverer installation.

Thanks

 

[Marco Kalter]

Okay, thanks for the update.