Home » RDBMS Server » Server Administration » ORA-609 and ORA-28 in oracle 11g (OS-RHEL4 , DB: Oracle 11.1.0.7)
ORA-609 and ORA-28 in oracle 11g [message #446867] Wed, 10 March 2010 14:30 Go to next message
ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore
Senior Member
Hi All

I just found a numbers of ORA-609 and ORA-28 errors on my alertlog.

Below are the entries in alertlog:


Quote:
Tue Mar 09 18:10:24 2010
ORA-28 : opiodr aborting process unknown ospid (12001_47047336410272)
Tue Mar 09 18:10:31 2010
Incremental checkpoint up to RBA [0x41.198f30.0], current log tail at RBA [0x41.1a1b9c.0]
Tue Mar 09 18:12:57 2010
ORA-28 : opiodr aborting process unknown ospid (14226_47197045968032)
Tue Mar 09 18:30:32 2010



Quote:

opidcl aborting process unknown ospid (25530_47806448188576) due to error ORA-28



Quote:
Fatal NI connect error 12537, connecting to:
(LOCAL=NO)

VERSION INFORMATION:
TNS for Linux: Version 11.1.0.7.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.1.0.7.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.1.0.7.0 - Production
Time: 10-MAR-2010 18:26:15
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 (32758_47257363184800)
Wed Mar 10 18:34:46 2010



Can any one tell what might be the problem ? Why these errors are coming? Up to my knowledge nobody is killing any sessions.

Are the users getting aborted automatically? or is this a bug ?

Thanks
RIdhi Sundar
Re: ORA-609 and ORA-28 in oracle 11g [message #446922 is a reply to message #446867] Thu, 11 March 2010 00:08 Go to previous messageGo to next message
ramoradba
Messages: 2451
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
We dont know anything about your database...

see the below
http://forums.oracle.com/forums/message.jspa?messageID=3591043#3591043

Contact Oracle support

sriram Smile
Re: ORA-609 and ORA-28 in oracle 11g [message #446971 is a reply to message #446922] Thu, 11 March 2010 03:18 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Check Metalink for Bug Id 7659739
Re: ORA-609 and ORA-28 in oracle 11g [message #446976 is a reply to message #446922] Thu, 11 March 2010 03:43 Go to previous messageGo to next message
ramoradba
Messages: 2451
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
See this too

sriram Smile
Re: ORA-609 and ORA-28 in oracle 11g [message #447027 is a reply to message #446976] Thu, 11 March 2010 10:47 Go to previous messageGo to next message
ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore
Senior Member
Sriram

What you want to know about my DAtabase? I have given the version of my DB.

oem agent and grid control or dbconsole are not running.

I guess the users are getting disconected due to network congestion. I could see in alertlogs mostly these error following the TNS timeout error.

Quote:

TNS-12535: TNS:operation timed out
WARNING: inbound connection timed out (ORA-3136)


Always this is from the ip:192.168.167.23


Can you please put your views. How this error can be resolved.

Thanks
Ridhi Sundar

Re: ORA-609 and ORA-28 in oracle 11g [message #447078 is a reply to message #447027] Thu, 11 March 2010 19:39 Go to previous message
BlackSwan
Messages: 21937
Registered: January 2009
Senior Member
03136, 00000, "inbound connection timed out"
// *Cause:  Inbound connection was timed out by the server because 
//          user authentication was not completed within the given time 
//          specified by SQLNET.INBOUND_CONNECT_TIMEOUT or its default value
// *Action: 1) Check SQL*NET and RDBMS log for trace of suspicious connections.
//          2) Configure SQL*NET with a proper inbound connect timeout value
//             if necessary.
bcm@bcm-laptop:~$ oerr tns 12535
12535, 00000, "TNS:operation timed out"
// *Cause: The requested operation could not be completed within the time out
// period.
// *Action: Look at the documentation on the secondary errors for possible
// remedy. See SQLNET.LOG to find secondary error if not provided explicitly.
// Turn on tracing to gather more information.
Previous Topic: Increasing tablespace size
Next Topic: ORA-00607: Internal error occurred while making a change to a data block
Goto Forum:
  


Current Time: Wed Apr 16 09:06:03 CDT 2014

Total time taken to generate the page: 0.09303 seconds