topic Oracle export error message lists System error message 25 in Operating System - HP-UX

Oracle export error message lists System error message 25

Jack C. Mahaffey — Mon, 25 Aug 2003 12:39:17 GMT

Running oracle 7.3.4 on hp-ux.

Database crashed last night. Oracle export was in progress during the crash. Here's output from Oracle export:
EXP-00008: ORACLE error 472 encountered
ORA-00472: PMON process terminated with error
EXP-00222:
System error message 25
EXP-00000: Export terminated unsuccessfully

What is "System error message 25"? I suspect it has something to do with memory. Is there a table that I can used to decipher the system errors?

The databaes crashed with the following errors in the system log:

Aug 25 02:01:13 chl002h alert_cts1.log: Mon Aug 25 02:01:13 2003
Aug 25 02:01:13 chl002h alert_cts1.log: Errors in file /usr/oracle/admin/cts1/bdump/pmon_2730.trc:
Aug 25 02:01:13 chl002h alert_cts1.log: ORA-00600: internal error code, arguments: [4881], [], [], [], [], [], [], []
Aug 25 02:01:13 chl002h alert_cts1.log: ORA-00601: cleanup lock conflict
Aug 25 02:01:14 chl002h alert_cts1.log: Thread 1 advanced to log sequence 2825
Aug 25 02:01:14 chl002h alert_cts1.log: Current log# 2 seq# 2825 mem# 0: /u02/oradata/cts1/redo2a.log
Aug 25 02:01:13 chl002h alert_cts1.log: ORA-00601: cleanup lock conflict
Aug 25 02:01:14 chl002h alert_cts1.log: Current log# 2 seq# 2825 mem# 1: /u06/oradata/cts1/redo2b.log
Aug 25 02:01:14 chl002h alert_cts1.log: Mon Aug 25 02:01:13 2003

Any ideas?

I ended up removing the sga files in the dbs directory and detaching an unused memory segment using ipcrm. I also stopped and restarted some MQSeries processes.

Jack...

Re: Oracle export error message lists System error message 25

Pete Randall — Mon, 25 Aug 2003 12:47:56 GMT

Jack,

I think your 25 error is probably unrelated (assuming I'm reading this correctly):

$ grep 25 /usr/include/sys/errno.h
/usr/include/sys/errno.h:#define ENOTTY 25 /* Not a typewriter

That sounds like the usual "stty: not a typewriter" error you get when a process not connected to a terminal issues terminal I/O - in other words, unrelated to your real problem.

Pete

Re: Oracle export error message lists System error message 25

Sandro Schaer_1 — Tue, 26 Aug 2003 07:36:56 GMT

check /usr/oracle/admin/cts1/bdump/pmon_2730.trc

maybe you find some more hints on what has caused this crash. usually ora-00600 are a pain in the a** to backtrack.

Re: Oracle export error message lists System error message 25

Indira Aramandla — Tue, 26 Aug 2003 08:16:07 GMT

Hi,

ORA-00472: "PMON process terminated with error" is related to be caused by The process cleanup process died

You also receive a system error 25, which is an input/output error.

Run the exports individually, and see.

I am suspecting if you were runing a couple of export jobs then the problem may be the disk controller was getting saturated and timing out. By doing the exports individually they will have adequate resources and run without error.

I hope this helps