locked
Configure Oracle 11gR2 32bit on Win2008 RRS feed

  • Question

  • User-960441985 posted

    I am configuring Oracle client on Windows 2008 and unable to figure out why I am getting following  error upon running asp.net application on a <st1:stockticker>NEW</st1:stockticker> server

    Version: Oracle 11gR2 32 bit.

    Proper TNS names.ora, sqlNet.ora

    Oracle Home directory path is C:\Oracle\product\11.2.0\client_1\bin;

    Server Error in '/OracleCN' Application.


    System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.

    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

    Exception Details: System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.

    Source Error:

    An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.


    Stack Trace:

     

    [Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.]

       System.Data.OracleClient.OCI.DetermineClientVersion() +429286

       System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName) +121

       System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions) +157

       System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) +58

       System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +54

       System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424440

       System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +92

       System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +1657

       System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +83

       System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +250071

       System.Data.OracleClient.OracleConnection.Open() +47

       System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) +53

       System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +188

       System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +573

       System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +161

       System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +2784038

       System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +27

       System.Web.UI.WebControls.DataBoundControl.PerformSelect() +261

       System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82

       System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +95

       System.Web.UI.Control.EnsureChildControls() +146

       System.Web.UI.Control.PreRenderRecursiveInternal() +61

       System.Web.UI.Control.PreRenderRecursiveInternal() +224

       System.Web.UI.Control.PreRenderRecursiveInternal() +224

       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3394

    Monday, October 24, 2011 11:30 AM

Answers

  • User1918766559 posted

    Check the  Oracle data provider for .NET in Oracle Client 11.4 ODP.NET is installed or not.

    Try out the following steps:

     1. Log on to Windows as a user with Administrator privileges.

    2. Launch Windows Explorer from the Start Menu and and navigate to the ORACLE_HOME folder. This is typically the "Ora11" folder under the "Oracle" folder.

    3. Right-click on the ORACLE_HOME folder and choose the "Properties" option from the drop down list. A "Properties" window should appear.

    4. Click on the "Security" tab of the "Properties" window.

    5. Click on "Authenticated Users" item in the "Name" list .

    6. Uncheck the "Read and Execute" box in the "Permissions" list under the "Allow" column .

    7. Re-check the "Read and Execute" box under the "Allow" column (this is the box you just unchecked).

    8. Click the "Advanced" button and in the "Permission Entries" list make sure you see the "Authenticated Users" listed there with: Permission = Read & Execute Apply To = This folder, subfolders and files If this is NOT the case, edit that line and make sure the "Apply onto" drop-down box is set to "This folder, subfolders and files". This should already be set properly but it is important that you verify this.

    9. Click the "Ok" button until you close out all of the security properties windows. The cursor may present the hour glass for a few seconds as it applies the permissions you just changed to all subfolders and files. 10. Reboot your computer to assure that these changes have taken effect. 

    Thanks,

    Anindita

    http://anindita9.wordpress.com

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, October 24, 2011 11:44 AM
  • User-960441985 posted

    Fix it after installing ODP 32 bit and setting application pool to 32 bit (that specific application).

    way to go!!

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, October 24, 2011 4:20 PM

All replies

  • User1918766559 posted

    Check the  Oracle data provider for .NET in Oracle Client 11.4 ODP.NET is installed or not.

    Try out the following steps:

     1. Log on to Windows as a user with Administrator privileges.

    2. Launch Windows Explorer from the Start Menu and and navigate to the ORACLE_HOME folder. This is typically the "Ora11" folder under the "Oracle" folder.

    3. Right-click on the ORACLE_HOME folder and choose the "Properties" option from the drop down list. A "Properties" window should appear.

    4. Click on the "Security" tab of the "Properties" window.

    5. Click on "Authenticated Users" item in the "Name" list .

    6. Uncheck the "Read and Execute" box in the "Permissions" list under the "Allow" column .

    7. Re-check the "Read and Execute" box under the "Allow" column (this is the box you just unchecked).

    8. Click the "Advanced" button and in the "Permission Entries" list make sure you see the "Authenticated Users" listed there with: Permission = Read & Execute Apply To = This folder, subfolders and files If this is NOT the case, edit that line and make sure the "Apply onto" drop-down box is set to "This folder, subfolders and files". This should already be set properly but it is important that you verify this.

    9. Click the "Ok" button until you close out all of the security properties windows. The cursor may present the hour glass for a few seconds as it applies the permissions you just changed to all subfolders and files. 10. Reboot your computer to assure that these changes have taken effect. 

    Thanks,

    Anindita

    http://anindita9.wordpress.com

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, October 24, 2011 11:44 AM
  • User-960441985 posted

    Thanks for your reply, I am using System.data.oracleClient namespace (which is deprecated but supported), do i still have to install ODP.Net?

    I want to make sure which ODP.net to install, Can you please share the link..

     

    Monday, October 24, 2011 3:16 PM
  • User-960441985 posted

    I am getting following error after installing ODAC112021Xcopy_32bit. I don't know which process is 64 bit (Oracle client and ODP is 32bit).

    Server Error in '/OracleCN' Application.


    An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B)

    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

    Exception Details: System.BadImageFormatException: An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B)

    Source Error:

    An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.


    Stack Trace:

    [BadImageFormatException: An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B)]
       System.Data.Common.UnsafeNativeMethods.OCILobCopy2(IntPtr svchp, IntPtr errhp, IntPtr dst_locp, IntPtr src_locp, UInt64 amount, UInt64 dst_offset, UInt64 src_offset) +0
       System.Data.OracleClient.OCI.DetermineClientVersion() +397
    
    [InvalidOperationException: Attempt to load Oracle client libraries threw BadImageFormatException.  This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed.]
       System.Data.OracleClient.OCI.DetermineClientVersion() +430074
       System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName) +121
       System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions) +157
       System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) +58
       System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +54
       System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424440
       System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +92
       System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +1657
       System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +83
       System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +250071
       System.Data.OracleClient.OracleConnection.Open() +47
       System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) +53
       System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +188
       System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +573
       System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +161
       System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +2784038
       System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +27
       System.Web.UI.WebControls.DataBoundControl.PerformSelect() +261
       System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82
       System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +95
       System.Web.UI.Control.EnsureChildControls() +146
       System.Web.UI.Control.PreRenderRecursiveInternal() +61
       System.Web.UI.Control.PreRenderRecursiveInternal() +224
       System.Web.UI.Control.PreRenderRecursiveInternal() +224
       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3394
    



    Version Information: Microsoft .NET Framework Version:2.0.50727.4963; ASP.NET Version:2.0.50727.4955

    Monday, October 24, 2011 3:58 PM
  • User-960441985 posted

    Fix it after installing ODP 32 bit and setting application pool to 32 bit (that specific application).

    way to go!!

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, October 24, 2011 4:20 PM