ORA-609: opiodr aborting process unknown ospid

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

ORA-609: opiodr aborting process unknown ospid

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 subject: ORA-609: opiodr aborting process unknown ospid

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

ORA-609: opiodr aborting process unknown ospid

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

ORA-609: opiodr aborting process unknown ospid

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

Same Problem

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.

Post Reply