OraFAQ Forum: Server Administration » ORA-609 and ORA-28 in oracle 11g

Home » RDBMS Server » Server Administration » ORA-609 and ORA-28 in oracle 11g (OS-RHEL4 , DB: Oracle 11.1.0.7)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-609 and ORA-28 in oracle 11g [message #446867]

Wed, 10 March 2010 14:30

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

Report message to a moderator

Re: ORA-609 and ORA-28 in oracle 11g [message #446922 is a reply to message #446867]

Thu, 11 March 2010 00:08

ramoradba
Messages: 2456
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

Report message to a moderator

Re: ORA-609 and ORA-28 in oracle 11g [message #446971 is a reply to message #446922]

Thu, 11 March 2010 03:18

tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden

Senior Member

Check Metalink for Bug Id 7659739

Report message to a moderator

Re: ORA-609 and ORA-28 in oracle 11g [message #446976 is a reply to message #446922]

Thu, 11 March 2010 03:43

ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

See this too

sriram Smile

Report message to a moderator

Re: ORA-609 and ORA-28 in oracle 11g [message #447027 is a reply to message #446976]

Thu, 11 March 2010 10:47

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

Report message to a moderator

Re: ORA-609 and ORA-28 in oracle 11g [message #447078 is a reply to message #447027]

Thu, 11 March 2010 19:39

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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.

Report message to a moderator

Previous Topic:	Increasing tablespace size
Next Topic:	ORA-00607: Internal error occurred while making a change to a data block

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 02:19:36 CDT 2024