OCI DLL NOT FOUND

malshan · June 28, 2015, 8:28am

Dear Experts,

Im really new to this Toad for Oracle so I’m bit helpless here! I’m getting the above error from Toad but i think I have install everything correctly.

SOFTWARE\WOW6432NODE\ORACLE (Oracle Root)
ORACLE_HOME_NAME:
ORACLE_HOME:
ORACLE_SID:
NLS_LANG:
SQLPATH:
LOCAL:
Home directory does not exist!
Home is not valid!
SOFTWARE\WOW6432NODE\ORACLE\KEY_ORACLIENT11G_HOME1
ORACLE_HOME_NAME: OraClient11g_home1
ORACLE_HOME: C:\oraclexe\app\oracle\product\11.2.0\server\bin
ORACLE_SID:
NLS_LANG: AMERICAN_AMERICA.WE8MSWIN1252
SQLPATH: C:\oraclexe\app\oracle\product\11.2.0\server\dbs
LOCAL:
C:\oraclexe\app\oracle\product\11.2.0\server\bin exists.
C:\oraclexe\app\oracle\product\11.2.0\server\bin is in PATH.
Client DLL: C:\oraclexe\app\oracle\product\11.2.0\server\bin\oci.dll
Client Version: 11.2.0.2.0
Home is valid.

my question is why am I getting the oci.dll error even though the ORACLE_HOME is valid! plz help!

7481hzfp

mstaszew · June 28, 2015, 3:26pm

Go to Support Bundle from the Help menu and send the entire contents of that screen so we can have a more complete picture of your setup.

Michael

From: malshan [mailto:bounce-malshan@toadworld.com]

Sent: Sunday, June 28, 2015 11:29 AM

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] OCI DLL NOT FOUND

OCI DLL NOT FOUND

Thread created by malshan

Dear Experts,

Im really new to this Toad for Oracle so I’m bit helpless here! I’m getting the above error from Toad but i think I have install everything correctly.

SOFTWARE\WOW6432NODE\ORACLE (Oracle Root)

ORACLE_HOME_NAME:

ORACLE_HOME:

ORACLE_SID:

NLS_LANG:

SQLPATH:

LOCAL:

Home directory does not exist!

Home is not valid!

SOFTWARE\WOW6432NODE\ORACLE\KEY_ORACLIENT11G_HOME1

ORACLE_HOME_NAME: OraClient11g_home1

ORACLE_HOME: C:\oraclexe\app\oracle\product\11.2.0\server\bin

ORACLE_SID:

NLS_LANG: AMERICAN_AMERICA.WE8MSWIN1252

SQLPATH: C:\oraclexe\app\oracle\product\11.2.0\server\dbs

LOCAL:

C:\oraclexe\app\oracle\product\11.2.0\server\bin exists.

C:\oraclexe\app\oracle\product\11.2.0\server\bin is in PATH.

Client DLL: C:\oraclexe\app\oracle\product\11.2.0\server\bin\oci.dll

Client Version: 11.2.0.2.0

Home is valid.

my question is why am I getting the oci.dll error even though the ORACLE_HOME is valid! plz help!

7481hzfp

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

malshan · June 28, 2015, 5:11pm

Thanks Micheal,

Plz look the below details,

APPLICATION INFORMATION - FULL VERSION

Support Bundle for Toad for Oracle 10.6.1.3

This copy of Toad for Oracle registered to Rahinur Rahaman

Bundle: Toad for Oracle Xpert Add-Ons: DB Admin Module, SQL Optimizer

Local Installation (non-network installation)

Toad for Oracle Executable Location : C:\Program Files (x86)\Quest Software\Toad for Oracle 10.6\Toad.exe

User Profile Directory : C:\Users\Razer’s\AppData\Roaming\Quest Software\Toad for Oracle\10.6\

Knowledge Xpert DLL Location : C:\Program Files (x86)\Quest Software\Toad for Oracle 10.6\Revbase.dll

Knowledge Xpert Version : 5.6.0.6

Formatter Plus DLL Location : C:\Program Files (x86)\Quest Software\Toad for Oracle 10.6\FmtPlus.dll

Formatter Plus Version : 4.8.8.7

QSEServer DLL Location : C:\Program Files (x86)\Quest Software\Toad for Oracle 10.6\qse.dll

QSEServer Version : 10.6.0.44

QP5 DLL Location : C:\Program Files (x86)\Quest Software\Toad for Oracle 10.6\QP5.dll

QP5 Version : 5.163.1008.3004

TOAD Policy Location : C:\Program Files (x86)\Quest Software\Toad for Oracle 10.6\Toad.pdl

TEAM CODING

No Team Coding sessions active.

MANAGED ITEMS

Not a managed environment.

ORACLE CLIENT INFORMATION

Not Connected!

ORACLE SERVER INFORMATION

Not Connected!

SYSTEM INFORMATION

Operating System : Unknown (64 bit) (Build 9200)

Is Terminal Server: No

Physical Memory Load : 32.99 %

Physical Memory (Total) : 8003 MB

Physical Memory (Free) : 5363 MB

Virtual Memory (Total) : 2047 MB

Virtual Memory (Free) : 1782 MB

Swap Space (Total) : 16195 MB

Swap Space (Free) : 13294 MB

Toad Page File Usage (Virtual Memory) : 68 MB

Toad Working Set Usage (RAM) : 78 MB

Environment Variable (PATH) :

D:\app\product\11.2.0\client_1

C:\oraclexe\app\oracle\product\11.2.0\server\bin

C:\Users\Razers\Documents\product\11.2.0\client_1\bin

C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common

C:\ProgramData\Oracle\Java\javapath

C:\WINDOWS\system32

C:\WINDOWS

C:\WINDOWS\System32\Wbem

C:\WINDOWS\System32\WindowsPowerShell\v1.0\

C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\

C:\Program Files\Microsoft SQL Server\100\Tools\Binn\

C:\Program Files\Microsoft SQL Server\100\DTS\Binn\

C:\Program Files\IBM\SPSS\Statistics\22\JRE\bin

C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\

C:\Program Files\Microsoft SQL Server\110\Tools\Binn\

C:\Program Files\Microsoft SQL Server\110\DTS\Binn\

C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\

C:\Program Files (x86)\Microsoft SQL Server\110\DTS\Binn\

C:\Program Files (x86)\QuickTime\QTSystem\

C:\Program Files\Microsoft\Web Platform Installer\

C:\Program Files (x86)\Microsoft ASP.NET\ASP.NET Web Pages\v1.0\

C:\Program Files (x86)\Windows Kits\8.0\Windows Performance Toolkit\

C:\Program Files (x86)\Skype\Phone\

C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\PrivateAssemblies\

C:\Program Files\Intel\WiFi\bin\

C:\Program Files\Common Files\Intel\WirelessCommon\

C:\Program Files\Intel\WiFi\bin\

C:\Program Files\Common Files\Intel\WirelessCommon\

C:\Python27

.

Environment Variable (TNS_ADMIN) : TNS_ADMIN is not a declared environment variable.

ORACLE HOMES DATA

(Oracle Root)

inst_loc = C:\Program Files (x86)\Oracle\Inventory

KEY_OraClient11g_home1

ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server\bin

ORACLE_HOME_NAME = OraClient11g_home1

ORACLE_GROUP_NAME = Oracle - OraClient11g_home1

ORACLE_BUNDLE_NAME = Express

NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252

OLEDB = C:\oraclexe\app\oracle\product\11.2.0\server\oledb\mesg

OO4O = C:\Users\Razers\Documents\product\11.2.0\client_1\oo4o\mesg

ORACLE_HOME_KEY = SOFTWARE\ORACLE\KEY_OraClient11g_home1

MSHELP_TOOLS = C:\Users\Razers\Documents\product\11.2.0\client_1\MSHELP

SQLPATH = C:\oraclexe\app\oracle\product\11.2.0\server\dbs

KEY_OraClient11g_home2 ***** This is the home currently used by Toad *****

ORACLE_HOME = D:\app\product\11.2.0\client_1

ORACLE_HOME_NAME = OraClient11g_home2

ORACLE_GROUP_NAME = Oracle - OraClient11g_home2

NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252

WINDOW USAGE

TProjectManagerForm - 16

TFormToadEditor - 1

TFormSupportBundle - 1

TWindowForm - 0

TJobClassForm - 0

TChainForm - 0

TDataCompareForm - 0

TTableForm - 0

TProgramForm - 0

TSchedulerJobForm - 0

TScheduleForm - 0

TSegmentAdvisorForm - 0

TIndexMonitoringForm - 0

TThreadedQueryViewerForm - 0

TUndoAdvisorForm - 0

TMultiObjectPrivForm - 0

TTaskSchedulerForm - 0

TWindowGroupForm - 0

TAuditSQLForm - 0

TAuditForm - 0

TQueueForm - 0

TDBProbeForm - 0

TServiceMgrForm - 0

TfrmTCViewer - 0

TFormWrap - 0

TDataImportForm - 0

TfrmComp1DBObj - 0

TDBrowserForm - 0

TFormERD - 0

TFormCRM - 0

TExportWatchForm - 0

TFormModRPlan - 0

TRefreshGroupForm - 0

TDiffHolderForm - 0

TFormModRGroup - 0

TClusterForm - 0

TfrmTCVCSBrowser - 0

TSessionBrowserForm - 0

TFormRPlanSchedule - 0

TExportBrowserForm - 0

TFormExecuteScript - 0

TSBLegendForm - 0

TQueryConditionForm - 0

TQBForm - 0

TNewCodeHealthCheckForm - 0

TFormToadAppDesigner - 0

TTraceFileBrowserForm - 0

TfrmJava2PLSqlUI - 0

TFormGridSaveAs - 0

TMDIDescribeForm - 0

TCreateDataForm - 0

TAlertLogForm - 0

TSearchInFilesForm - 0

TQuickDescribeForm - 0

TTransformationForm - 0

TFormServerSideObjects - 0

TFormSQLOptimizer - 0

TF4HolderForm - 0

TCopyTableDataForm - 0

TExplainPlanCompareForm - 0

TADDMReportForm - 0

TDiskGroupForm - 0

TASMForm - 0

TReportsForm - 0

TDataPumpImportForm - 0

TDataPumpExportForm - 0

TFormRefCursorResults - 0

TDataPumpManagerForm - 0

TDBMSRedefForm - 0

TFlashbackArchiveForm - 0

TStatsPackBrowserForm - 0

TDBMS_SQLTuneForm - 0

TAWRBrowserForm - 0

TToadOnlineForm - 0

TContextForm - 0

TToadAdvisorForm - 0

TFormExportDDL - 0

TFlashbackForm - 0

TZipArchiveForm - 0

TfrmComp1Obj - 0

TCompareSchemasForm - 0

TfrmDepend - 0

TfrmTblFilter - 0

TSchemaScriptForm - 0

TExportWizardForm - 0

TfrmLogMiner - 0

TSQLLoader - 0

TImportWizardForm - 0

TfrmExPlan - 0

TEstimateTabSizeForm - 0

TfrmTrace - 0

TfrmAnalyze - 0

TEstimateIndSizeForm - 0

TMasterDetailForm - 0

TfrmTabDupes - 0

TfrmSessionInfo - 0

TfrmUsersList - 0

TfrmDbmsMDI - 0

TfrmOraInit - 0

TfrmTopSess - 0

TfrmExtents - 0

TfrmNLSParams - 0

TDBHealthCheckForm - 0

TIMonitor - 0

TfrmMain - 0

TOSMonitorForm - 0

TInstanceManagerForm - 0

TfrmTableSpaces - 0

TfrmFreeDeficit - 0

TfrmChainedRows - 0

TfrmLogSwitch - 0

TRedoLogManagerForm - 0

TPinnedPackageForm - 0

TfrmServerStats - 0

TTablespaceMapForm - 0

TDBCreateWizardForm - 0

TfrmControlFiles - 0

TfrmRebuildTable - 0

TScriptManagerForm - 0

TNetworkForm - 0

TfrmSchemaDoc - 0

TfrmTKProf - 0

TTOADFTP - 0

TViewForm - 0

TTablespaceForm - 0

TfrmObjects - 0

TfrmCreateUser - 0

TTNSNamesEditorForm - 0

TTriggerForm - 0

TDimensionForm - 0

TCompareDatabasesForm - 0

TDatabaseScriptForm - 0

TfrmJavaManager - 0

TWindowsRegistryParmsForm - 0

TUNIXKernelParmsForm - 0

TOutputFrm - 0

TSchedulerForm - 0

TtdProfileAnalysisForm - 0

TfrmImportExport - 0

TfrmDbLinks - 0

TfrmConsDef - 0

TFDataModeler - 0

TFormObjectSearch - 0

TfrmIndRbld - 0

TSecurityForm - 0

TDataSubsetWizardForm - 0

TDirectoryForm - 0

TSnapshotLogForm - 0

TSnapshotForm - 0

TTableForm - 0

TfrmSynonyms - 0

TfrmMakeSeq - 0

TLibraryForm - 0

TIndexForm - 0

TRBSForm - 0

TProfileForm - 0

GTDG · June 28, 2015, 5:19pm

Is your oracle client a 64 bit client? If so, you need a 32 bit client to work with 32 bit Toad

On Jun 28, 2015, at 8:12 PM, malshan bounce-malshan@toadworld.com wrote:

RE: OCI DLL NOT FOUND

Reply by malshan
Thanks Micheal,

Plz look the below details,

APPLICATION INFORMATION - FULL VERSION

Support Bundle for Toad for Oracle 10.6.1.3

This copy of Toad for Oracle registered to Rahinur Rahaman

Bundle: Toad for Oracle Xpert Add-Ons: DB Admin Module, SQL Optimizer

Local Installation (non-network installation)

Toad for Oracle Executable Location : C:\Program Files (x86)\Quest Software\Toad for Oracle 10.6\Toad.exe

User Profile Directory : C:\Users\Razer's\AppData\Roaming\Quest Software\Toad for Oracle\10.6\

Knowledge Xpert DLL Location : C:\Program Files (x86)\Quest Software\Toad for Oracle 10.6\Revbase.dll

Knowledge Xpert Version : 5.6.0.6

Formatter Plus DLL Location : C:\Program Files (x86)\Quest Software\Toad for Oracle 10.6\FmtPlus.dll

Formatter Plus Version : 4.8.8.7

QSEServer DLL Location : C:\Program Files (x86)\Quest Software\Toad for Oracle 10.6\qse.dll

QSEServer Version : 10.6.0.44

QP5 DLL Location : C:\Program Files (x86)\Quest Software\Toad for Oracle 10.6\QP5.dll

QP5 Version : 5.163.1008.3004

TOAD Policy Location : C:\Program Files (x86)\Quest Software\Toad for Oracle 10.6\Toad.pdl

TEAM CODING

No Team Coding sessions active.

MANAGED ITEMS

Not a managed environment.

ORACLE CLIENT INFORMATION

Not Connected!

ORACLE SERVER INFORMATION

Not Connected!

SYSTEM INFORMATION

Operating System : Unknown (64 bit) (Build 9200)

Is Terminal Server: No

Physical Memory Load : 32.99 %

Physical Memory (Total) : 8003 MB

Physical Memory (Free) : 5363 MB

Virtual Memory (Total) : 2047 MB

Virtual Memory (Free) : 1782 MB

Swap Space (Total) : 16195 MB

Swap Space (Free) : 13294 MB

Toad Page File Usage (Virtual Memory) : 68 MB

Toad Working Set Usage (RAM) : 78 MB

Environment Variable (PATH) :

D:\app\product\11.2.0\client_1

C:\oraclexe\app\oracle\product\11.2.0\server\bin

C:\Users\Razers\Documents\product\11.2.0\client_1\bin

C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common

C:\ProgramData\Oracle\Java\javapath

C:\WINDOWS\system32

C:\WINDOWS

C:\WINDOWS\System32\Wbem

C:\WINDOWS\System32\WindowsPowerShell\v1.0\

C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\

C:\Program Files\Microsoft SQL Server\100\Tools\Binn\

C:\Program Files\Microsoft SQL Server\100\DTS\Binn\

C:\Program Files\IBM\SPSS\Statistics\22\JRE\bin

C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\

C:\Program Files\Microsoft SQL Server\110\Tools\Binn\

C:\Program Files\Microsoft SQL Server\110\DTS\Binn\

C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\

C:\Program Files (x86)\Microsoft SQL Server\110\DTS\Binn\

C:\Program Files (x86)\QuickTime\QTSystem\

C:\Program Files\Microsoft\Web Platform Installer\

C:\Program Files (x86)\Microsoft ASP.NET[ASP.NET](http://ASP.NET) Web Pages\v1.0\

C:\Program Files (x86)\Windows Kits\8.0\Windows Performance Toolkit\

C:\Program Files (x86)\Skype\Phone\

C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\PrivateAssemblies\

C:\Program Files\Intel\WiFi\bin\

C:\Program Files\Common Files\Intel\WirelessCommon\

C:\Program Files\Intel\WiFi\bin\

C:\Program Files\Common Files\Intel\WirelessCommon\

C:\Python27

.

Environment Variable (TNS_ADMIN) : TNS_ADMIN is not a declared environment variable.

ORACLE HOMES DATA

(Oracle Root)

inst_loc = C:\Program Files (x86)\Oracle\Inventory

KEY_OraClient11g_home1

ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server\bin

ORACLE_HOME_NAME = OraClient11g_home1

ORACLE_GROUP_NAME = Oracle - OraClient11g_home1

ORACLE_BUNDLE_NAME = Express

NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252

OLEDB = C:\oraclexe\app\oracle\product\11.2.0\server\oledb\mesg

OO4O = C:\Users\Razers\Documents\product\11.2.0\client_1\oo4o\mesg

ORACLE_HOME_KEY = SOFTWARE\ORACLE\KEY_OraClient11g_home1

MSHELP_TOOLS = C:\Users\Razers\Documents\product\11.2.0\client_1\MSHELP

SQLPATH = C:\oraclexe\app\oracle\product\11.2.0\server\dbs

KEY_OraClient11g_home2 ***** This is the home currently used by Toad *****

ORACLE_HOME = D:\app\product\11.2.0\client_1

ORACLE_HOME_NAME = OraClient11g_home2

ORACLE_GROUP_NAME = Oracle - OraClient11g_home2

NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252

WINDOW USAGE

TProjectManagerForm - 16

TFormToadEditor - 1

TFormSupportBundle - 1

TWindowForm - 0

TJobClassForm - 0

TChainForm - 0

TDataCompareForm - 0

TTableForm - 0

TProgramForm - 0

TSchedulerJobForm - 0

TScheduleForm - 0

TSegmentAdvisorForm - 0

TIndexMonitoringForm - 0

TThreadedQueryViewerForm - 0

TUndoAdvisorForm - 0

TMultiObjectPrivForm - 0

TTaskSchedulerForm - 0

TWindowGroupForm - 0

TAuditSQLForm - 0

TAuditForm - 0

TQueueForm - 0

TDBProbeForm - 0

TServiceMgrForm - 0

TfrmTCViewer - 0

TFormWrap - 0

TDataImportForm - 0

TfrmComp1DBObj - 0

TDBrowserForm - 0

TFormERD - 0

TFormCRM - 0

TExportWatchForm - 0

TFormModRPlan - 0

TRefreshGroupForm - 0

TDiffHolderForm - 0

TFormModRGroup - 0

TClusterForm - 0

TfrmTCVCSBrowser - 0

TSessionBrowserForm - 0

TFormRPlanSchedule - 0

TExportBrowserForm - 0

TFormExecuteScript - 0

TSBLegendForm - 0

TQueryConditionForm - 0

TQBForm - 0

TNewCodeHealthCheckForm - 0

TFormToadAppDesigner - 0

TTraceFileBrowserForm - 0

TfrmJava2PLSqlUI - 0

TFormGridSaveAs - 0

TMDIDescribeForm - 0

TCreateDataForm - 0

TAlertLogForm - 0

TSearchInFilesForm - 0

TQuickDescribeForm - 0

TTransformationForm - 0

TFormServerSideObjects - 0

TFormSQLOptimizer - 0

TF4HolderForm - 0

TCopyTableDataForm - 0

TExplainPlanCompareForm - 0

TADDMReportForm - 0

TDiskGroupForm - 0

TASMForm - 0

TReportsForm - 0

TDataPumpImportForm - 0

TDataPumpExportForm - 0

TFormRefCursorResults - 0

TDataPumpManagerForm - 0

TDBMSRedefForm - 0

TFlashbackArchiveForm - 0

TStatsPackBrowserForm - 0

TDBMS_SQLTuneForm - 0

TAWRBrowserForm - 0

TToadOnlineForm - 0

TContextForm - 0

TToadAdvisorForm - 0

TFormExportDDL - 0

TFlashbackForm - 0

TZipArchiveForm - 0

TfrmComp1Obj - 0

TCompareSchemasForm - 0

TfrmDepend - 0

TfrmTblFilter - 0

TSchemaScriptForm - 0

TExportWizardForm - 0

TfrmLogMiner - 0

TSQLLoader - 0

TImportWizardForm - 0

TfrmExPlan - 0

TEstimateTabSizeForm - 0

TfrmTrace - 0

TfrmAnalyze - 0

TEstimateIndSizeForm - 0

TMasterDetailForm - 0

TfrmTabDupes - 0

TfrmSessionInfo - 0

TfrmUsersList - 0

TfrmDbmsMDI - 0

TfrmOraInit - 0

TfrmTopSess - 0

TfrmExtents - 0

TfrmNLSParams - 0

TDBHealthCheckForm - 0

TIMonitor - 0

TfrmMain - 0

TOSMonitorForm - 0

TInstanceManagerForm - 0

TfrmTableSpaces - 0

TfrmFreeDeficit - 0

TfrmChainedRows - 0

TfrmLogSwitch - 0

TRedoLogManagerForm - 0

TPinnedPackageForm - 0

TfrmServerStats - 0

TTablespaceMapForm - 0

TDBCreateWizardForm - 0

TfrmControlFiles - 0

TfrmRebuildTable - 0

TScriptManagerForm - 0

TNetworkForm - 0

TfrmSchemaDoc - 0

TfrmTKProf - 0

TTOADFTP - 0

TViewForm - 0

TTablespaceForm - 0

TfrmObjects - 0

TfrmCreateUser - 0

TTNSNamesEditorForm - 0

TTriggerForm - 0

TDimensionForm - 0

TCompareDatabasesForm - 0

TDatabaseScriptForm - 0

TfrmJavaManager - 0

TWindowsRegistryParmsForm - 0

TUNIXKernelParmsForm - 0

TOutputFrm - 0

TSchedulerForm - 0

TtdProfileAnalysisForm - 0

TfrmImportExport - 0

TfrmDbLinks - 0

TfrmConsDef - 0

TFDataModeler - 0

TFormObjectSearch - 0

TfrmIndRbld - 0

TSecurityForm - 0

TDataSubsetWizardForm - 0

TDirectoryForm - 0

TSnapshotLogForm - 0

TSnapshotForm - 0

TTableForm - 0

TfrmSynonyms - 0

TfrmMakeSeq - 0

TLibraryForm - 0

TIndexForm - 0

TRBSForm - 0

TProfileForm - 0

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

malshan · June 29, 2015, 6:14am

Yes Micheal, I have 32bit oracle and my server is 64bit express, will that be an issue?

mstaszew · June 29, 2015, 6:30am

That was Greg, but no that would not be an issue. Your version of Toad is 32-bit so you must use a 32-bit client. It’s OK that the server is 64-bit.

Is OraClient11g_home2 an instant client? If so your version of Toad has a bug with the “installed” instant clients. Instant clients setup by the Oracle Universal Installer create a registry key for the client and Toad can’t handle that. It only supports the unzipped clients. Newer versions of Toad have this resolved.

You have two homes installed. Try selecting OraClient11g_home1 as the active client on the login window. Can you connect with it?

Michael

malshan · June 29, 2015, 7:00am

well at the moment I removed all the clients and server! I’m reinstalling it and will get back to you with the new installation.

malshan · June 29, 2015, 7:07am

Hi Micheal Thanks for the support, Installation fixed the issue! I still dont know what caused it RIBBIT!