error launching PL/SQL developer
- Thread starter Naveed
- Start date
This problem is caused by a Net8 / Net9 installation issue. PL/SQL Developer attempts to load OCI.DLL (the Oracle Net library), which subsequently cannot find on of its required modules. This is usually a PATH related problem.
Can you 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? This should allow me to provide a solution.
------------------
Marco Kalter
Allround Automations
Can you 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? This should allow me to provide a solution.
------------------
Marco Kalter
Allround Automations
--- Info ---
PL/SQL Developer
Version 5.0.1.480
01.8207 - Unlimited user license
Windows 2000 version 5.0 (build 2195) Service Pack 2
Parameters
C:\Program Files\PLSQL Developer\PLSQLDev.exe
Preferences
Session mode: Multi
OCI Library:
Use OCI7: False
Aliases
*******as_dbsvr
*******gu_dbsvr
ak_dbsvr
ak-dbsvr
al_dbsvr
al-dbsvr
ar_dbsvr
ar-dbsvr
az_dbsvr
az-dbsvr
c1n11_qies
c1n11_sdpswhst
c1n13_qies
c1n13_sdpswhsr
c1n5_qies
c1n9_ptlc1n9
c1n9_qies
c1n9_sdps
c1s80_sdps
c1s80_sdps_ris
c2n11_sdpspn2r
c2n11_sdpspnrr
c2n11_sdpspr2r
c2n11_sdpsprnr
c2n13_ptlc2n13
c2n3_sdpspnrp
c2n3_sdpsprnp
c2n7_ptlc2n7
c2n7_sdpsprn
c2n7_sdpsprns
c2n9_ptlc2n9
c2n9_sdpspnrt
c2n9_sdpsprnt
c2n9_test1
c2qnu01_sdpspnrp
c2qnu01_sdpsprnp
ca_dbsvr
ca-dbsvr
cdwd
co_dbsvr
co-dbsvr
ct_dbsvr
ct-dbsvr
dc_dbsvr
dc-dbsvr
de_dbsvr
de-dbsvr
DEVDBSVR
DEVDTEST
fl_dbsvr
fl-dbsvr
ga_dbsvr
ga-dbsvr
hi_dbsvr
hi-dbsvr
ia_dbsvr
ia-dbsvr
id_dbsvr
id-dbsvr
il_dbsvr
il-dbsvr
in_dbsvr
in-dbsvr
ks_dbsvr
ks-dbsvr
ky_dbsvr
ky-dbsvr
la_dbsvr
la-dbsvr
ma_dbsvr
ma-dbsvr
md_dbsvr
md-dbsvr
me_dbsvr
me-dbsvr
MEDQICP
MEDQICT
mi_dbsvr
mi-dbsvr
mn_dbsvr
mn-dbsvr
mo_dbsvr
mo-dbsvr
ms_dbsvr
ms-dbsvr
mt_dbsvr
mt-dbsvr
nc_dbsvr
nc-dbsvr
nd_dbsvr
nd-dbsvr
ne_dbsvr
ne-dbsvr
nh_dbsvr
nh-dbsvr
nj_dbsvr
nj-dbsvr
nm_dbsvr
nm-dbsvr
nv_dbsvr
nv-dbsvr
ny_dbsvr
ny-dbsvr
oh_dbsvr
oh-dbsvr
ok_dbsvr
ok-dbsvr
or_dbsvr
or-dbsvr
pa_dbsvr
pa-dbsvr
pr_dbsvr
pr-dbsvr
proddbsv
repos_sdps
ri_dbsvr
ri-dbsvr
sc_dbsvr
sc-dbsvr
sd_dbsvr
sd-dbsvr
sdpscdwp
tn_dbsvr
tn-dbsvr
trndbsvr
TST_DBSVR
TSTDBSVR
tx_dbsvr
tx-dbsvr
ut_dbsvr
ut-dbsvr
va_dbsvr
va-dbsvr
vi_dbsvr
vt_dbsvr
vt-dbsvr
wa_dbsvr
wa-dbsvr
wi_dbsvr
wi-dbsvr
wv_dbsvr
wv-dbsvr
wy_dbsvr
wy-dbsvr
Homes
oracle_817 (C:\ORACLE\ORA81a)
Oracle_9_2 (C:\ORACLE\ORA92)
OraHome81 (C:\oracle\ora81)
OraHome817 (C:\oracle\ora817)
DLLs
C:\ORACLE\ORA81a\bin\oci.dll
TNS File
C:\ORACLE\ORA81a\Network\Admin\tnsnames.ora
Using
Home: oracle_817
DLL: C:\ORACLE\ORA81a\bin\oci.dll
OCI: Version 8.1
--- Registry ---
SOFTWARE\ORACLE
inst_loc = C:\Program Files\Oracle\Inventory
ORACLE_HOME = C:\oracle\ora81
ORACLE_HOME_NAME = OraHome81
API = C:\oracle\ora81\DBS
ORACLE_GROUP_NAME = Oracle for Windows NT
NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1
COMPANY_NAME = CMS
CORE40 = C:\oracle\ora81\CORE40
NET80 = C:\oracle\ora81\NET80
NLSRTL33 = C:\oracle\ora81\NLSRTL33
OI_NLS32 = C:\oracle\ora81\orainst\NLB
OLEDB = C:\oracle\ora817\oledb\mesg
OO4O = C:\oracle\ora817\oo4o\mesg
ORA_NLS33 = C:\oracle\ora81\NLSRTL33\DATA
OTRACE80 = C:\oracle\ora81\OTRACE80
PLSQL80 = C:\oracle\ora81\PLSQL80
PRO80 = C:\oracle\ora81\PRO80
RDBMS80 = C:\oracle\ora81\RDBMS80
SHARED_ORACLE_HOME = C:\oracle\ora81
VOBHOME2.0 = C:\ORACLE\ORA92
SOFTWARE\ORACLE\ALL_HOMES
HOME_COUNTER = 4
DEFAULT_HOME = OraHome81
LAST_HOME = 3
SOFTWARE\ORACLE\ALL_HOMES\ID0
NAME = OraHome81
PATH = C:\oracle\ora81
NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1
SOFTWARE\ORACLE\ALL_HOMES\ID1
NAME = OraHome817
PATH = C:\oracle\ora817
NLS_LANG = NA
SOFTWARE\ORACLE\ALL_HOMES\ID2
NAME = oracle_817
PATH = C:\ORACLE\ORA81a
NLS_LANG = NA
SOFTWARE\ORACLE\ALL_HOMES\ID3
NAME = Oracle_9_2
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 for Windows NT
ORACLE_HOME_NAME = OraHome81
ORACLE_HOME = C:\oracle\ora81
API = C:\oracle\ora81\DBS
COMPANY_NAME = CMS
D2K60_DRIVERS = DataDirect ODBC Drivers
D2K60_GROUP = DataDirect ODBC Group
NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1
SHARED_ORACLE_HOME = C:\oracle\ora81
SOFTWARE\ORACLE\HOME1
ID = 1
ORACLE_GROUP_NAME = Oracle - OraHome817
ORACLE_HOME_NAME = OraHome817
ORACLE_HOME = C:\oracle\ora817
NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1
ORACLE_HOME_KEY = Software\ORACLE\HOME1
SQLPATH = C:\oracle\ora817\dbs
MSHELP_TOOLS = C:\oracle\ora817\MSHELP
SOFTWARE\ORACLE\HOME2
ID = 2
ORACLE_GROUP_NAME = Oracle - oracle_817
ORACLE_HOME_NAME = oracle_817
ORACLE_HOME = C:\ORACLE\ORA81a
NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1
ORACLE_HOME_KEY = Software\ORACLE\HOME2
SQLPATH = C:\ORACLE\ORA81a\dbs
MSHELP_TOOLS = C:\ORACLE\ORA81a\MSHELP
SOFTWARE\ORACLE\HOME3
ID = 3
ORACLE_GROUP_NAME = Oracle - Oracle_9_2
ORACLE_HOME_NAME = Oracle_9_2
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\HOME3
MSHELP_TOOLS = C:\ORACLE\ORA92\MSHELP
SOFTWARE\ORACLE\iSQLPlus
ServerCount = ServerURIColWidth =
PL/SQL Developer
Version 5.0.1.480
01.8207 - Unlimited user license
Windows 2000 version 5.0 (build 2195) Service Pack 2
Parameters
C:\Program Files\PLSQL Developer\PLSQLDev.exe
Preferences
Session mode: Multi
OCI Library:
Use OCI7: False
Aliases
*******as_dbsvr
*******gu_dbsvr
ak_dbsvr
ak-dbsvr
al_dbsvr
al-dbsvr
ar_dbsvr
ar-dbsvr
az_dbsvr
az-dbsvr
c1n11_qies
c1n11_sdpswhst
c1n13_qies
c1n13_sdpswhsr
c1n5_qies
c1n9_ptlc1n9
c1n9_qies
c1n9_sdps
c1s80_sdps
c1s80_sdps_ris
c2n11_sdpspn2r
c2n11_sdpspnrr
c2n11_sdpspr2r
c2n11_sdpsprnr
c2n13_ptlc2n13
c2n3_sdpspnrp
c2n3_sdpsprnp
c2n7_ptlc2n7
c2n7_sdpsprn
c2n7_sdpsprns
c2n9_ptlc2n9
c2n9_sdpspnrt
c2n9_sdpsprnt
c2n9_test1
c2qnu01_sdpspnrp
c2qnu01_sdpsprnp
ca_dbsvr
ca-dbsvr
cdwd
co_dbsvr
co-dbsvr
ct_dbsvr
ct-dbsvr
dc_dbsvr
dc-dbsvr
de_dbsvr
de-dbsvr
DEVDBSVR
DEVDTEST
fl_dbsvr
fl-dbsvr
ga_dbsvr
ga-dbsvr
hi_dbsvr
hi-dbsvr
ia_dbsvr
ia-dbsvr
id_dbsvr
id-dbsvr
il_dbsvr
il-dbsvr
in_dbsvr
in-dbsvr
ks_dbsvr
ks-dbsvr
ky_dbsvr
ky-dbsvr
la_dbsvr
la-dbsvr
ma_dbsvr
ma-dbsvr
md_dbsvr
md-dbsvr
me_dbsvr
me-dbsvr
MEDQICP
MEDQICT
mi_dbsvr
mi-dbsvr
mn_dbsvr
mn-dbsvr
mo_dbsvr
mo-dbsvr
ms_dbsvr
ms-dbsvr
mt_dbsvr
mt-dbsvr
nc_dbsvr
nc-dbsvr
nd_dbsvr
nd-dbsvr
ne_dbsvr
ne-dbsvr
nh_dbsvr
nh-dbsvr
nj_dbsvr
nj-dbsvr
nm_dbsvr
nm-dbsvr
nv_dbsvr
nv-dbsvr
ny_dbsvr
ny-dbsvr
oh_dbsvr
oh-dbsvr
ok_dbsvr
ok-dbsvr
or_dbsvr
or-dbsvr
pa_dbsvr
pa-dbsvr
pr_dbsvr
pr-dbsvr
proddbsv
repos_sdps
ri_dbsvr
ri-dbsvr
sc_dbsvr
sc-dbsvr
sd_dbsvr
sd-dbsvr
sdpscdwp
tn_dbsvr
tn-dbsvr
trndbsvr
TST_DBSVR
TSTDBSVR
tx_dbsvr
tx-dbsvr
ut_dbsvr
ut-dbsvr
va_dbsvr
va-dbsvr
vi_dbsvr
vt_dbsvr
vt-dbsvr
wa_dbsvr
wa-dbsvr
wi_dbsvr
wi-dbsvr
wv_dbsvr
wv-dbsvr
wy_dbsvr
wy-dbsvr
Homes
oracle_817 (C:\ORACLE\ORA81a)
Oracle_9_2 (C:\ORACLE\ORA92)
OraHome81 (C:\oracle\ora81)
OraHome817 (C:\oracle\ora817)
DLLs
C:\ORACLE\ORA81a\bin\oci.dll
TNS File
C:\ORACLE\ORA81a\Network\Admin\tnsnames.ora
Using
Home: oracle_817
DLL: C:\ORACLE\ORA81a\bin\oci.dll
OCI: Version 8.1
--- Registry ---
SOFTWARE\ORACLE
inst_loc = C:\Program Files\Oracle\Inventory
ORACLE_HOME = C:\oracle\ora81
ORACLE_HOME_NAME = OraHome81
API = C:\oracle\ora81\DBS
ORACLE_GROUP_NAME = Oracle for Windows NT
NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1
COMPANY_NAME = CMS
CORE40 = C:\oracle\ora81\CORE40
NET80 = C:\oracle\ora81\NET80
NLSRTL33 = C:\oracle\ora81\NLSRTL33
OI_NLS32 = C:\oracle\ora81\orainst\NLB
OLEDB = C:\oracle\ora817\oledb\mesg
OO4O = C:\oracle\ora817\oo4o\mesg
ORA_NLS33 = C:\oracle\ora81\NLSRTL33\DATA
OTRACE80 = C:\oracle\ora81\OTRACE80
PLSQL80 = C:\oracle\ora81\PLSQL80
PRO80 = C:\oracle\ora81\PRO80
RDBMS80 = C:\oracle\ora81\RDBMS80
SHARED_ORACLE_HOME = C:\oracle\ora81
VOBHOME2.0 = C:\ORACLE\ORA92
SOFTWARE\ORACLE\ALL_HOMES
HOME_COUNTER = 4
DEFAULT_HOME = OraHome81
LAST_HOME = 3
SOFTWARE\ORACLE\ALL_HOMES\ID0
NAME = OraHome81
PATH = C:\oracle\ora81
NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1
SOFTWARE\ORACLE\ALL_HOMES\ID1
NAME = OraHome817
PATH = C:\oracle\ora817
NLS_LANG = NA
SOFTWARE\ORACLE\ALL_HOMES\ID2
NAME = oracle_817
PATH = C:\ORACLE\ORA81a
NLS_LANG = NA
SOFTWARE\ORACLE\ALL_HOMES\ID3
NAME = Oracle_9_2
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 for Windows NT
ORACLE_HOME_NAME = OraHome81
ORACLE_HOME = C:\oracle\ora81
API = C:\oracle\ora81\DBS
COMPANY_NAME = CMS
D2K60_DRIVERS = DataDirect ODBC Drivers
D2K60_GROUP = DataDirect ODBC Group
NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1
SHARED_ORACLE_HOME = C:\oracle\ora81
SOFTWARE\ORACLE\HOME1
ID = 1
ORACLE_GROUP_NAME = Oracle - OraHome817
ORACLE_HOME_NAME = OraHome817
ORACLE_HOME = C:\oracle\ora817
NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1
ORACLE_HOME_KEY = Software\ORACLE\HOME1
SQLPATH = C:\oracle\ora817\dbs
MSHELP_TOOLS = C:\oracle\ora817\MSHELP
SOFTWARE\ORACLE\HOME2
ID = 2
ORACLE_GROUP_NAME = Oracle - oracle_817
ORACLE_HOME_NAME = oracle_817
ORACLE_HOME = C:\ORACLE\ORA81a
NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1
ORACLE_HOME_KEY = Software\ORACLE\HOME2
SQLPATH = C:\ORACLE\ORA81a\dbs
MSHELP_TOOLS = C:\ORACLE\ORA81a\MSHELP
SOFTWARE\ORACLE\HOME3
ID = 3
ORACLE_GROUP_NAME = Oracle - Oracle_9_2
ORACLE_HOME_NAME = Oracle_9_2
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\HOME3
MSHELP_TOOLS = C:\ORACLE\ORA92\MSHELP
SOFTWARE\ORACLE\iSQLPlus
ServerCount = ServerURIColWidth =
If you add C:\ORACLE\ORA81a\bin to the PATH environment variable, or use the Oracle Home Selector (a standard oracle utility) to select a Primary Oracle Home, this problem should be fixed.
------------------
Marco Kalter
Allround Automations
------------------
Marco Kalter
Allround Automations
Similar threads
- Discussion
