OraFAQ Forum: Server Administration » ORA01403 bring a database down?

Home » RDBMS Server » Server Administration » ORA01403 bring a database down? (Oracle, 10.2.0.4, Solaris10)

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

ORA01403 bring a database down? [message #515201]

Fri, 08 July 2011 09:43

gbraden
Messages: 2
Registered: July 2011
Location: Hampton, VA

Junior Member

Interesting.

We came in this morning with one of the servers down. After bringing it back up and checking the alert log, the only indicators that something was wrong were the hundreds of ora_01403 and the resulting trace files that were created.

The trc files for the most part indicated 'knpssamsg encountered 1304; end of error statck dumped in slave;' date and time and service name being sys$users.

Not much information on Google.

Has anyone else had ora01403 bring down a database?

Thanks in advance

gbraden

Report message to a moderator

Re: ORA01403 bring a database down? [message #515202 is a reply to message #515201]

Fri, 08 July 2011 09:46

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Has anyone else had ora01403 bring down a database?
not me.

ORA-00600/ORA-07445/ORA-03113
did any of the above appear in alert_SID.log file

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: ORA01403 bring a database down? [message #515210 is a reply to message #515202]

Fri, 08 July 2011 10:03

gbraden
Messages: 2
Registered: July 2011
Location: Hampton, VA

Junior Member

Thanks for pointing out the forum posting guidelines.

Only other errors were two ORA-3136 (inbound connection timed out). We are looking at a possible hardware problem since there is nothing in the log indicating that the database came down, only the information that is populated by a startup.

I am not allowed to copy and paste anything from this system to post. Believe me, it would be my first choice to show what I am seeing in the alert log.

Thanks (again) in advance

gbraden

Report message to a moderator

Re: ORA01403 bring a database down? [message #515218 is a reply to message #515201]

Fri, 08 July 2011 12:43

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

gbraden wrote on Fri, 08 July 2011 10:43

ora_01403 and the resulting trace files that were created.

The trc files for the most part indicated 'knpssamsg encountered 1304; end of error statck dumped in slave;'

1304 or 1403?
Server down or database down?
With not being able to post anything more, will you allowed to put in a TAR with Oracle or they will not allow you to do that either?

Report message to a moderator

Re: ORA01403 bring a database down? [message #515219 is a reply to message #515218]

Fri, 08 July 2011 13:04

John Watson
Messages: 8966
Registered: January 2010
Location: Global Village

Senior Member

Or perhaps 1034? As BS implied, 1403 is more likely to be a symptom of a problem, not the cause.

Report message to a moderator

Previous Topic:	Is there any way to organize or group schemas inside an instance?(2 Merged)
Next Topic:	Drawback of DBMS_PIPE

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 27 09:25:00 CST 2025