I am using a 10.1.0 client and plsdev 7 (had same problem with 6.0.6). Was able to connect via SQL*Plus, and the plsdev logon window recognized my tnsnames.ora and all the entries. But when I attempted to connect, I got a small window with nothing by an OK button in it. Set my Oracle Home and OCI lib path explicitly, with same result. It was only when I added an ORACLE_HOME environment variable that I was able to connect. I think this is a bug in plsdev, because Oracle no longer requires an ORACLE_HOME enviroment variable on Windows -- it reads it from the registry. (In fact, OUI will complain about the ORACLE_HOME variable if you are installing more than one OH). Apparently so do portions of plsdev (I never had to tell it where tnsnames.ora was), but not the actual connect call.
Cannot connect using 10g client
- Thread starter syscw
- Start date
The ORACLE_HOME environment variable is not required, it will merely be used to find an Oracle10g Instant Client. If you are using an Oracle10g Instant Client, then the PATH must include the Instant Client directory though. Otherwise you can get these errors.
If this does not apply, can you go to Help > Support Info, press the 'Copy all pages' button on this info screen, and paste this text into an e-mail?
If this does not apply, can you go to Help > Support Info, press the 'Copy all pages' button on this info screen, and paste this text into an e-mail?
I am not using Instant Client -- I am using a full Enterprise Edition install. Here is the support info (if it matters, I was connected using the ORACLE_HOME variable at the time).
--- Info ---
PL/SQL Developer
Version 7.0.0.1050 (MBCS)
01.32396 - 1 user license
Windows XP version 6.0 (build 2600) Service Pack 2
Physical memory : 2,088,304 kB (1,198,296 available)
Paging file : 4,030,848 kB (3,246,672 available)
Virtual memory : 2,097,024 kB (1,996,296 available)
Parameters
C:\Program Files\PLSQL Developer\plsqldev.exe
Preferences
Session mode: Multi
OCI Library:
Use OCI7: False
Plug-Ins
Aliases
ats-sun7
BIGIP_TEST
crprd
DSHBPROD
emea_dms
...
Homes
OraDb10g_home1 (C:\oracle\product\10.1.0.0)
DLLs
C:\oracle\product\10.1.0.0\bin\oci.dll
TNS File
C:\oracle\product\10.1.0.0\Network\Admin\tnsnames.ora
Using
Home: OraDb10g_home1
DLL: C:\oracle\product\10.1.0.0\bin\oci.dll
OCI: version 9.2
Oracle Database 10g Enterprise Edition Release 10.1.0.4.2
Character size: 3 byte(s)
--- Registry ---
SOFTWARE\ORACLE
inst_loc = C:\Program Files\Oracle\Inventory
ORA_CRS_HOME = C:\oracle\product\10.1.0.0
SOFTWARE\ORACLE\Calendar
Version = 10.1.1.0.0
AppPath = C:\Program Files\Oracle\Calendar\
SOFTWARE\ORACLE\Desktop Sharing Run-Time
SOFTWARE\ORACLE\Desktop Sharing Run-Time\Driver Usage
{6EC12D06-9C55-4609-9105-C33093D5717C} =
SOFTWARE\ORACLE\KEY_OraDb10g_home1
ORACLE_HOME = C:\oracle\product\10.1.0.0
ORACLE_HOME_NAME = OraDb10g_home1
ORACLE_GROUP_NAME = Oracle - OraDb10g_home1
ORACLE_BUNDLE_NAME = Enterprise
NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252
OLEDB = C:\oracle\product\10.1.0.0\oledb\mesg
OO4O = C:\oracle\product\10.1.0.0\oo4o\mesg
SQLPATH = C:\oracle\product\10.1.0.0\dbs
ORACLE_HOME_KEY = SOFTWARE\ORACLE\KEY_OraDb10g_home1
ORACLE_BASE = C:\oracle\product
MSHELP_TOOLS = C:\oracle\product\10.1.0.0\MSHELP
RDBMS_CONTROL = C:\oracle\product\10.1.0.0\DATABASE
RDBMS_ARCHIVE = C:\oracle\product\10.1.0.0\DATABASE\ARCHIVE
ORA_RUPERT_AUTOSTART = TRUE
ORA_RUPERT_SHUTDOWN = TRUE
ORA_RUPERT_SHUTDOWNTYPE = immediate
ORA_RUPERT_SHUTDOWN_TIMEOUT = 90
ORACLE_SID = rupert
SOFTWARE\ORACLE\KEY_OraDb10g_home1\ODP.NET
TraceFileName = C:\ODPNET.trc
TraceLevel = 0
TraceOption = 0
SOFTWARE\ORACLE\KEY_OraDb10g_home1\OLEDB
CacheType = Memory
ChunkSize = 100
DistribTX = 1
FetchSize = 100
OSAuthent = 0
PLSQLRset = 0
PwdChgDlg = 1
SchRstLng = 10000
UserDefFn = 0
DisableRetClause = 1
VCharNull = 1
TraceCategory = 0
TraceFileName = c:\OraOLEDB.trc
TraceLevel = 0
TraceOption = 0
SPPrmDefVal = 0
SOFTWARE\ORACLE\KEY_OraDb10g_home1\OO4O
CacheBlocks = 20
FetchLimit = 100
FetchSize = 4096
HelpFile = C:\oracle\product\10.1.0.0\oo4o\doc\oracleo.hlp
PerBlock = 16
SliceSize = 256
TempFileDirectory = c:\temp
OO4O_HOME = C:\oracle\product\10.1.0.0\oo4o
SOFTWARE\ORACLE\Messenger
Fatal URL = http://rtc.oracle.com/imtapp/im/messenger/omreport.jsp
SOFTWARE\ORACLE\Messenger\Modules
SOFTWARE\ORACLE\Messenger\Setup
source_dir = C:\DOCUME~1\swegner\LOCALS~1\Temp\RWT7284.tmp
dest dir = C:\Program Files\Oracle\Messenger
auto_update =
SOFTWARE\ORACLE\Ocr
ocrconfig_loc = C:\oracle\product\10.1.0.0\cdata\localhost\local.ocr
Local_Only = TRUE
SOFTWARE\ORACLE\Outlook Connector
SOFTWARE\ORACLE\Outlook Connector\3.6
AppPath = C:\Program Files\Oracle\Outlook Connector
CompanyName = Oracle Corporation
InstallKey =
SyncLog = Send Log Version = 10.1.2.0.0
Label =
NoAccounts = InstallDate = 03070225105
UserID =
UserName = user
CfgSettings =
SOFTWARE\ORACLE\RTC
SOFTWARE\ORACLE\RTC\OfficeAddin
FormName = RTCConference
InstallPath = C:\Program Files\Oracle\RTC Addin\
InstallState = SCFBytes = IPM.Appointment.RTCConference SNBytes = IPM.Note.RDNoteReadPage
SRBytes = IPM.Appointment.RTCConference
OutlookVersion =
SOFTWARE\ORACLE\RTC\ServiceHub
ServerURL = http://strtc.oracle.com
cchecklast =
--- Info ---
PL/SQL Developer
Version 7.0.0.1050 (MBCS)
01.32396 - 1 user license
Windows XP version 6.0 (build 2600) Service Pack 2
Physical memory : 2,088,304 kB (1,198,296 available)
Paging file : 4,030,848 kB (3,246,672 available)
Virtual memory : 2,097,024 kB (1,996,296 available)
Parameters
C:\Program Files\PLSQL Developer\plsqldev.exe
Preferences
Session mode: Multi
OCI Library:
Use OCI7: False
Plug-Ins
Aliases
ats-sun7
BIGIP_TEST
crprd
DSHBPROD
emea_dms
...
Homes
OraDb10g_home1 (C:\oracle\product\10.1.0.0)
DLLs
C:\oracle\product\10.1.0.0\bin\oci.dll
TNS File
C:\oracle\product\10.1.0.0\Network\Admin\tnsnames.ora
Using
Home: OraDb10g_home1
DLL: C:\oracle\product\10.1.0.0\bin\oci.dll
OCI: version 9.2
Oracle Database 10g Enterprise Edition Release 10.1.0.4.2
Character size: 3 byte(s)
--- Registry ---
SOFTWARE\ORACLE
inst_loc = C:\Program Files\Oracle\Inventory
ORA_CRS_HOME = C:\oracle\product\10.1.0.0
SOFTWARE\ORACLE\Calendar
Version = 10.1.1.0.0
AppPath = C:\Program Files\Oracle\Calendar\
SOFTWARE\ORACLE\Desktop Sharing Run-Time
SOFTWARE\ORACLE\Desktop Sharing Run-Time\Driver Usage
{6EC12D06-9C55-4609-9105-C33093D5717C} =
SOFTWARE\ORACLE\KEY_OraDb10g_home1
ORACLE_HOME = C:\oracle\product\10.1.0.0
ORACLE_HOME_NAME = OraDb10g_home1
ORACLE_GROUP_NAME = Oracle - OraDb10g_home1
ORACLE_BUNDLE_NAME = Enterprise
NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252
OLEDB = C:\oracle\product\10.1.0.0\oledb\mesg
OO4O = C:\oracle\product\10.1.0.0\oo4o\mesg
SQLPATH = C:\oracle\product\10.1.0.0\dbs
ORACLE_HOME_KEY = SOFTWARE\ORACLE\KEY_OraDb10g_home1
ORACLE_BASE = C:\oracle\product
MSHELP_TOOLS = C:\oracle\product\10.1.0.0\MSHELP
RDBMS_CONTROL = C:\oracle\product\10.1.0.0\DATABASE
RDBMS_ARCHIVE = C:\oracle\product\10.1.0.0\DATABASE\ARCHIVE
ORA_RUPERT_AUTOSTART = TRUE
ORA_RUPERT_SHUTDOWN = TRUE
ORA_RUPERT_SHUTDOWNTYPE = immediate
ORA_RUPERT_SHUTDOWN_TIMEOUT = 90
ORACLE_SID = rupert
SOFTWARE\ORACLE\KEY_OraDb10g_home1\ODP.NET
TraceFileName = C:\ODPNET.trc
TraceLevel = 0
TraceOption = 0
SOFTWARE\ORACLE\KEY_OraDb10g_home1\OLEDB
CacheType = Memory
ChunkSize = 100
DistribTX = 1
FetchSize = 100
OSAuthent = 0
PLSQLRset = 0
PwdChgDlg = 1
SchRstLng = 10000
UserDefFn = 0
DisableRetClause = 1
VCharNull = 1
TraceCategory = 0
TraceFileName = c:\OraOLEDB.trc
TraceLevel = 0
TraceOption = 0
SPPrmDefVal = 0
SOFTWARE\ORACLE\KEY_OraDb10g_home1\OO4O
CacheBlocks = 20
FetchLimit = 100
FetchSize = 4096
HelpFile = C:\oracle\product\10.1.0.0\oo4o\doc\oracleo.hlp
PerBlock = 16
SliceSize = 256
TempFileDirectory = c:\temp
OO4O_HOME = C:\oracle\product\10.1.0.0\oo4o
SOFTWARE\ORACLE\Messenger
Fatal URL = http://rtc.oracle.com/imtapp/im/messenger/omreport.jsp
SOFTWARE\ORACLE\Messenger\Modules
SOFTWARE\ORACLE\Messenger\Setup
source_dir = C:\DOCUME~1\swegner\LOCALS~1\Temp\RWT7284.tmp
dest dir = C:\Program Files\Oracle\Messenger
auto_update =
SOFTWARE\ORACLE\Ocr
ocrconfig_loc = C:\oracle\product\10.1.0.0\cdata\localhost\local.ocr
Local_Only = TRUE
SOFTWARE\ORACLE\Outlook Connector
SOFTWARE\ORACLE\Outlook Connector\3.6
AppPath = C:\Program Files\Oracle\Outlook Connector
CompanyName = Oracle Corporation
InstallKey =
SyncLog = Send Log Version = 10.1.2.0.0
Label =
NoAccounts = InstallDate = 03070225105
UserID =
UserName = user
CfgSettings =
SOFTWARE\ORACLE\RTC
SOFTWARE\ORACLE\RTC\OfficeAddin
FormName = RTCConference
InstallPath = C:\Program Files\Oracle\RTC Addin\
InstallState = SCFBytes = IPM.Appointment.RTCConference SNBytes = IPM.Note.RDNoteReadPage
SRBytes = IPM.Appointment.RTCConference
OutlookVersion =
SOFTWARE\ORACLE\RTC\ServiceHub
ServerURL = http://strtc.oracle.com
cchecklast =
And how does this look without the ORACLE_HOME setting?
Similar threads
- Discussion