Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
-
DJ82
- Posts: 2
- Joined: Tue 25 Aug 2009 06:40
- Location: Switzerland
Post
by DJ82 » Tue 25 Aug 2009 06:48
Hello
I'm an ORA DBA and our developers use dotConnect for Oracle.
Since they use this Client we report many Errors in Ora Log.
Code: Select all
24.08.2009-22:10:23 -> ...
24.08.2009-22:10:23 -> ns secondary err code: 12560
24.08.2009-22:10:23 -> nt main err code: 0
24.08.2009-22:10:23 -> nt secondary err code: 0
24.08.2009-22:10:23 -> nt OS err code: 0
24.08.2009-22:10:23 -> ORA-609 : opiodr aborting process unknown ospid (920_2348)
24.08.2009-22:10:23 -> ...
24.08.2009-22:10:23 -> ns secondary err code: 12560
24.08.2009-22:10:23 -> nt main err code: 0
24.08.2009-22:10:23 -> nt secondary err code: 0
24.08.2009-22:10:23 -> nt OS err code: 0
24.08.2009-22:10:23 -> ORA-609 : opiodr aborting process unknown ospid (920_2236)
24.08.2009-22:10:23 -> ...
Any idea whats happen?
Thanks for your help
Daniel[/code]
-
Shalex
- Site Admin
- Posts: 9543
- Joined: Thu 14 Aug 2008 12:44
Post
by Shalex » Tue 25 Aug 2009 14:59
These are the general errors:
http://ora-609.ora-code.com/
http://ora-12560.ora-code.com/
1. We need more detailed information to identify the problem: a call stack, the error messages, a piece of code or a test project to reproduce the error will be appreciated.
2. Also please specify the version of dotConnect for Oracle you are using and the connection mode (Direct or OCI; if OCI, please tell us the version of Oracle client).
3. What version of Oracle server are you working with?
-
DJ82
- Posts: 2
- Joined: Tue 25 Aug 2009 06:40
- Location: Switzerland
Post
by DJ82 » Wed 26 Aug 2009 06:26
Shalex wrote:
1. We need more detailed information to identify the problem: a call stack, the error messages, a piece of code or a test project to reproduce the error will be appreciated.
2. Also please specify the version of dotConnect for Oracle you are using and the connection mode (Direct or OCI; if OCI, please tell us the version of Oracle client).
3. What version of Oracle server are you working with?
1. will send you later
2.
dotConnect for Oracle Professional 5.0.22.0
Oracle Client 10.2
3. We work with Oracle Database 11.1.0.7
Oracle Trace File:
Code: Select all
Oracle Database 11g Release 11.1.0.7.0 - 64bit Production
Windows NT Version V6.0 Service Pack 1
CPU : 2 - type 8664, 2 Physical Cores
Process Affinity : 0x0000000000000000
Memory (Avail/Total): Ph:836M/2046M, Ph+PgF:3608M/6002M
Instance name: dev
Redo thread mounted by this instance: 1
Oracle process number: 16
Windows thread id: 3956, image: ORACLE.EXE (SHAD)
*** 2009-08-26 07:42:23.102
*** CLIENT ID:() 2009-08-26 07:42:23.102
*** SERVICE NAME:() 2009-08-26 07:42:23.102
*** MODULE NAME:() 2009-08-26 07:42:23.102
*** ACTION NAME:() 2009-08-26 07:42:23.102
opiino: Attach failed due to ORA-12537
-
Shalex
- Site Admin
- Posts: 9543
- Joined: Thu 14 Aug 2008 12:44
Post
by Shalex » Wed 26 Aug 2009 07:15
We recommend you to upgrade to the latest 5.25.39 version of dotConnect for Oracle. If the problem persists, please contact us via our contact form (
http://www.devart.com/company/contact.html), and specify the call stack, error messages, and a piece of code or a test project with the link to this post.
-
kevin.weir
- Posts: 12
- Joined: Wed 17 Sep 2008 22:25
Post
by kevin.weir » Tue 10 Nov 2009 00:21
We are getting the same error which I am able to reproduce.
The following appears in our Oracle alert log:
Fatal NI connect error 12537, connecting to:
(LOCAL=NO)
VERSION INFORMATION:
TNS for 32-bit Windows: Version 11.1.0.7.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 11.1.0.7.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 11.1.0.7.0 - Production
Time: 09-NOV-2009 18:10:31
Tracing not turned on.
Tns error struct:
ns main err code: 12537
TNS-12537: TNS:connection closed
ns secondary err code: 12560
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
ORA-609 : opiodr aborting process unknown ospid (8032_5772)
The following class contains the executing code that produces the error:
Imports System.Configuration
Imports Devart.Data.Oracle
Public Class DatabaseConnection
Private _OracleConnection As OracleConnection
Public Sub New()
_OracleConnection = New OracleConnection(ConfigurationManager.ConnectionStrings("MOEDBDIRECT").ConnectionString)
_OracleConnection.Open()
End Sub
Public Function GetConnection() As OracleConnection
Return _OracleConnection
End Function
Public Sub CloseConnection()
If _OracleConnection.State = ConnectionState.Open Then
_OracleConnection.Close()
End If
End Sub
End Class
When the _OracleConnection.Open() is called the error above appears in the alert log.
Our connection string is as follows:
<add name="MOEDBDIRECT" connectionString="User Id=USERNAME;Password=PASSWORD;Server=EYPS_PRD;Direct=True;Sid=ENTP;Persist Security Info=True;min pool size=0;max pool size=125;connection lifetime=864000;"
providerName="Devart.Data.Oracle" />
Our environment is as follows:
Devart.Data.Oracle.dll version # is 5.25.30.0
Our Oracle database version # is 11.1.0.7
Our Oracle client is not applicable since we are using DIRECT mode.
-
kevin.weir
- Posts: 12
- Joined: Wed 17 Sep 2008 22:25
Post
by kevin.weir » Tue 10 Nov 2009 00:23
My apologies. We are using Devart.Data.Oracle.dll version # 5.25.39.0 which is the latest release.
-
Shalex
- Site Admin
- Posts: 9543
- Joined: Thu 14 Aug 2008 12:44
Post
by Shalex » Wed 11 Nov 2009 17:06
We cannot reproduce the problem with the same environment. It seems, the reason of the problem is ORA-12560. It occurs when there is no opportunity to determine the service name from ConnectionString. Please make sure, you have configured your server correctly and set the right service name in your connection string.
-
kevin.weir
- Posts: 12
- Joined: Wed 17 Sep 2008 22:25
Post
by kevin.weir » Wed 11 Nov 2009 23:15
Shalex the connection is ACTUALLY MADE but the error still appears in the Oracle alert log. Our Oracle service name is configured correctly.
Our test envionment is running Oracle Server 11.1.0.7 which produces the errors in the alert log. Our production environment is running Oracle 10.2.0.4 and NO ERRORS appear in that alert log. Other than the different database server versions the test and production environments are configured the same. Also, the connection strings are the same for production and test environments accept for Server= and Sid= values.
The problem definetly appears to be related to using Devart.Data.Oracle.dll version # 5.25.39.0 with Oracle Server 11.1.0.7
dotConnect for Oracle connection string:
<add name="MOEDBDIRECT" connectionString="User Id=USERNAME;Password=PASSWORD;Server=EYPS_TST;Direct=True;Sid=ENTT;Persist Security Info=True;min pool size=0;max pool size=125;connection lifetime=864000;"
providerName="Devart.Data.Oracle" />
Our Oracle SPFILE has the following values for service_name:
service_names='EYPS_TST.WORLD','EYPS_TST'
Our Oracle listener file is configured as follows:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\Ora11g\Home)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = EYPS_TST)
(ORACLE_HOME = D:\Ora11g\Home)
(SID_NAME = ENTT)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = server.ourdomain.com)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
-
kevin.weir
- Posts: 12
- Joined: Wed 17 Sep 2008 22:25
Post
by kevin.weir » Wed 11 Nov 2009 23:31
Shalex in my last reply I didn't mention a couple of SPFILE settings that may be relevant:
db_domain='WORLD'
db_name='EYPS_TST'
-
Shalex
- Site Admin
- Posts: 9543
- Joined: Thu 14 Aug 2008 12:44
Post
by Shalex » Mon 16 Nov 2009 17:39
We think these errors arise during execution of some server code (e.g., triggers), and they are not caused by our provider. Try another provider - probably, the result will be the same.
-
kevin.weir
- Posts: 12
- Joined: Wed 17 Sep 2008 22:25
Post
by kevin.weir » Tue 17 Nov 2009 23:02
Shalex no triggers are firing since there are none. The error occurs when connections are being opened.
As I mentioned above in sample code the error occurs at the exact moment _OracleConnection.Open() is called. I have confirmed this by running in debugger and immediately looking in Oracle alert log.
-
Shalex
- Site Admin
- Posts: 9543
- Joined: Thu 14 Aug 2008 12:44
Post
by Shalex » Wed 18 Nov 2009 08:31
Does this problem persist with other providers?
-
kevin.weir
- Posts: 12
- Joined: Wed 17 Sep 2008 22:25
Post
by kevin.weir » Wed 18 Nov 2009 23:28
I will try another provider at some point but this week it won't be possible. I'll re-post once I have the results.
-
[email protected]
- Posts: 3
- Joined: Tue 16 Mar 2010 18:30
Post
by [email protected] » Tue 20 Apr 2010 19:33
Was there any resolution to this problem?
We have the same problem. To answer the last post, we did not have these errors in the logs with ODP.NET or the Microsoft .NET provider.
We are using dotConnect version 5.60.102.0
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0
-
Shalex
- Site Admin
- Posts: 9543
- Joined: Thu 14 Aug 2008 12:44
Post
by Shalex » Fri 23 Apr 2010 15:26
We have reproduced the mentioned error in the Direct mode. We will investigate the issue and notify you about the results as soon as possible.