Ocienvcreate failed with return code 1 but error message text was not available

User-1077881737 posted

Hi,

We have a requirement to connect to oracle from ASP.NET and we installed ODAC(ODAC1110621) components  on the server but still we are getting the following error while opening the connection. Please find the details below:-

OCIEnvCreate failed with return code -1 but error message text was not available.

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: OCIEnvCreate failed with return code -1 but error message text was not available.

Source Error:

Line 16:     {
Line 17:         OracleConnection con = new OracleConnection(ConfigurationManager.ConnectionStrings["HRDBA"].ConnectionString);
Line 18:         con.Open();
Line 19:         Label1.Text = con.State.ToString();
Line 20:         con.Close();

[Exception: OCIEnvCreate failed with return code -1 but error message text was not available.]
   System.Data.OracleClient.OciHandle..ctor(OciHandle parentHandle, HTYPE handleType, MODE ocimode, HANDLEFLAG handleflags) +376
   System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName) +151
   System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions) +133
   System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) +40
   System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +29
   System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +433
   System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +72
   System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +457
   System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +100
   System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +116
   System.Data.OracleClient.OracleConnection.Open() +40
   Webpage1.Page_Load(Object sender, EventArgs e) in \hs003fs01-02.homebase.comwfmpWebpage1.aspx.cs:18
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +50
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627

I would be greteful if you could please suggest how i can fix this. The user is having full permissions on the Oracle folder.

Many Thanks,

Madhu

<!— [Exception]: OCIEnvCreate failed with return code -1 but error message text was not available. at System.Data.OracleClient.OciHandle..ctor(OciHandle parentHandle, HTYPE handleType, MODE ocimode, HANDLEFLAG handleflags) at System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String
userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName) at System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions) at System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions
options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection
owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.OracleClient.OracleConnection.Open() at Webpage1.Page_Load(Object sender, EventArgs e) in \hs003fs01-02.homebase.comwfmpWebpage1.aspx.cs:line
18 at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) [HttpUnhandledException]: Exception of type ‘System.Web.HttpUnhandledException’ was thrown. at System.Web.UI.Page.HandleError(Exception e)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest()
at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context) at System.Web.UI.Page.ProcessRequest(HttpContext context) at ASP.webpage1_aspx.ProcessRequest(HttpContext context) in c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Filesroot7971936fa687e91App_Web_vnm9shij.2.cs:line
0 at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) —>

Hello,

I am new using the Oracle Data Access components.  My company 32-bit .NET 4.0 VB.NET application uses the ODAC 12c libraries and it runs for an 2 plus hours and then crashes with the following:

Exception Level 1: Execption Type: Exception Exception Level 1: Error Description: OCIEnvCreate failed with return code -1 but error message text was not available.

Exception Level 1: Source:System.Data.OracleClient

Exception Level 1: Stack Trace:   at System.Data.OracleClient.OciHandle..ctor(OciHandle parentHandle, HTYPE handleType, MODE ocimode, HANDLEFLAG handleflags)

1:    at System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)

1:    at System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions)

1:    at System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)

1:    at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)

1:    at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)

1:    at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

1:    at System.Data.OracleClient.OracleConnection.Open()

1:    at Microsoft.Practices.EnterpriseLibrary.Data.Database.GetNewOpenConnection()

1:    at Microsoft.Practices.EnterpriseLibrary.Data.Database.GetWrappedConnection()

1:    at Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteNonQuery(DbCommand command)

1:    at USG.LinX.PrintAndApply.DataObjects.OracleDataProvider.LogEvent(String msg, String MessageType, String OrgCode, Nullable`1 LineNumber, Char LegLetter, Nullable`1 StackerNumber, String ServerName) in C:Visual Studio 2013ProjectsPrintAndApplyDataObjectsOracleDataProvider.vb:line 984

1:    at USG.LinX.PrintAndApply.Utilities.EventLogger.LogEvent() in C:Visual Studio 2013ProjectsPrintAndApplyUtilitiesEventLogger.vb:line 62

1:    at USG.LinX.PrintAndApply.Utilities.AppEvents.Log(String msg, EventType EventType, String OrgCode, Int32 LineNumber, Char Leg, Int32 StackerNumber) in C:UsersPKonstantDocumentsVisual Studio 2013ProjectsPrintAndApplyUtilitiesAppEvents.vb:line 38

1:    at USG.LinX.PrintAndApply.BusinessObjects.BLineReader.Run() in C:Visual Studio 2013ProjectsPrintAndApplyBusinessObjectsServiceBLineReader.vb:line 821

1:    at USG.LinX.PrintAndApply.BusinessObjects.BLineReader.StartProcessingCore() in C:Visual Studio 2013ProjectsPrintAndApplyBusinessObjectsServiceBLineReader.vb:line 139

Exception Level 1: Target Site:Void .ctor(System.Data.OracleClient.OciHandle, HTYPE, MODE, HANDLEFLAG)

Event Viewer has the following:

Faulting application printandapply.exe, version 1.0.0.0, stamp 53c81478, faulting module oraociei12.dll, version 12.1.0.0, stamp 51cfc80d, debug? 0, fault address 0x00bd768c.

I am using Visual Studio 2013 with the Oracle Developer Tools for Visual Studio (12.1.0.1.2) libraries.  Any help would be surely appreciated.

Many Thanks

Peter

[{«Product»:{«code»:»SS9S6B»,»label»:»IBM Cognos Controller»},»Business Unit»:{«code»:»BU059″,»label»:»IBM Software w/o TPS»},»Component»:»Controller»,»Platform»:[{«code»:»PF033″,»label»:»Windows»}],»Version»:»10.1.1″,»Edition»:»»,»Line of Business»:{«code»:»LOB10″,»label»:»Data and AI»}}]