Operating System - HP-UX
1748239 Members
3603 Online
108759 Solutions
New Discussion юеВ

Re: Oracle export error message lists System error message 25

 
SOLVED
Go to solution
Jack C. Mahaffey
Super Advisor

Oracle export error message lists System error message 25

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...
3 REPLIES 3
Pete Randall
Outstanding Contributor
Solution

Re: Oracle export error message lists System error message 25

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


Pete
Sandro Schaer_1
Advisor

Re: Oracle export error message lists System error message 25

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.
Indira Aramandla
Honored Contributor

Re: Oracle export error message lists System error message 25

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

Never give up, Keep Trying