No question at this time
DBA Top 10
1 M. Cadot 3900
2 B. Vroman 700
2 P. Tsongayinwe 700
2 P. Wisse 700
5 M. Pagac 400
6 G. De Paep3 200
6 A. Deledda 200
6 D. Walgude 200
6 J. Schnackenberg 200
6 B. M 200
About
DBA-Village
Advertise here
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48757
Total active users1320
Act. users last 24h0
Act. users last hour0
Registered user hits last week24
Registered user hits last month1443
Go up

opiodr aborting process unknown ospid (92) as a result of ORA-609
Next thread: how to connect old oracle client to new 19 db with ALLOW_WEAK_CRYPTO_CLIENTS = FALSE on the server
Prev thread: DR configuration on Windows

Message Score Author Date
Hi Team We have a DB server that has 5 instance...... Phuti Tsongayinwe May 29, 2023, 15:23
<pre>ORA-00609: could not attach to incoming con...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Michel Cadot May 29, 2023, 16:25
Thanks, Michel We have the Tns error struct: ns...... Phuti Tsongayinwe May 29, 2023, 20:47
Have a look at sqlnet.log file. If not enough i...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Michel Cadot May 29, 2023, 22:38
Thanks, Michel I will have a look. Thanks ...... Phuti Tsongayinwe May 29, 2023, 22:46
As an update, we had resource issues in the global...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Phuti Tsongayinwe May 31, 2023, 10:03
Thanks for the feedback, it is also appreciated....... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Michel Cadot May 31, 2023, 11:15

Follow up by mail Click here

Subject: opiodr aborting process unknown ospid (92) as a result of ORA-609
Author: Phuti Tsongayinwe, South Africa
Date: May 29, 2023, 15:23, 119 days ago
Os info: Oracle Solaris 11.4 SPARC.
Oracle info: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.13.0.0.0
Error info: 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
opiodr aborting process unknown ospid (2165) as a result of ORA-609
Mon May 29 15:19:54 2023
Message: Hi Team

We have a DB server that has 5 instances running on it.

We are experiencing slow response on the applications, and upon investigation, I found out that all the DB alerts have this 'opiodr aborting process unknown ospid (2165)' as a result of ORA-609.

What might be the cause of the issue?

Thanks
Phuti
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here
Subject: Re: opiodr aborting process unknown ospid (92) as a result of ORA-609
Author: Michel Cadot, France
Date: May 29, 2023, 16:25, 119 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: 
ORA-00609: could not attach to incoming connection

 *Cause:  Oracle process could not answer incoming connection

 *Action: If the situation described in the next error on the stack

         can be corrected, do so; otherwise contact Oracle Support.

What is the next error on the stack?

Regards
Michel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here
Subject: Re: opiodr aborting process unknown ospid (92) as a result of ORA-609
Author: Phuti Tsongayinwe, South Africa
Date: May 29, 2023, 20:47, 118 days ago
Message: Thanks, Michel

We have the Tns error struct: ns main err code: 12535 in the alert log and also these TNS-12535: TNS:operation timed out ns secondary err code: 12606

Thanks
Phuti
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here
Subject: Re: opiodr aborting process unknown ospid (92) as a result of ORA-609
Author: Michel Cadot, France
Date: May 29, 2023, 22:38, 118 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message:
Have a look at sqlnet.log file.
If not enough information activate trace using TRACE_FILE_SERVER and TRACE_LEVEL_SERVER parameters in sqlnet.ora file.

https://docs.oracle.com/en/database/oracle/oracle-database/19/netrf/parameters-for-the-sqlnet.ora.html#GUID-F830D89A-C41C-49F0-875B-C6CA849D1043
https://docs.oracle.com/en/database/oracle/oracle-database/19/netrf/parameters-for-the-sqlnet.ora.html#GUID-CE205A5B-BE6D-469F-93F8-9844567BD173

Regards
Michel

Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here
Subject: Re: opiodr aborting process unknown ospid (92) as a result of ORA-609
Author: Phuti Tsongayinwe, South Africa
Date: May 29, 2023, 22:46, 118 days ago
Message: Thanks, Michel

I will have a look.

Thanks
Phuti
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here
Subject: Re: opiodr aborting process unknown ospid (92) as a result of ORA-609
Author: Phuti Tsongayinwe, South Africa
Date: May 31, 2023, 10:03, 117 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: As an update, we had resource issues in the global zone that affected the local zone. The UNIX team managed to resolve the issue, which mitigated our problem.

Thanks for the reply and the recommendations.

Much appreciated!

Thanks
Phuti
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here
Subject: Re: opiodr aborting process unknown ospid (92) as a result of ORA-609
Author: Michel Cadot, France
Date: May 31, 2023, 11:15, 117 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message:
Thanks for the feedback, it is also appreciated.

Regards
Michel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here