Есть проблема с Oracle (версия 8.1.7, Linux R.H 6.2, kernel 2.2.14). После некорректного завершения стараюсь открыть с помощью svrlmgr: SVRMGR> startup open ORACLE instance started. Total System Global Area 25780384 bytes Fixed Size 73888 bytes Variable Size 7282688 bytes Database Buffers 16777216 bytes Redo Buffers 1646592 bytes Database mounted. ORA-00704: bootstrap process failure ORA-00604: error occurred at recursive SQL level 1 ORA-27102: out of memory Additional information: 1359827956 Additional information: 720091086 Additional information: 747014960
При этом создается alert file, в конце следующее: PMON started with pid=2 Load Indicator not supported by OS ! DBW0 started with pid=3 LGWR started with pid=4 CKPT started with pid=5 SMON started with pid=6 RECO started with pid=7 Tue Sep 3 22:31:28 2002 alter database mount Tue Sep 3 22:31:32 2002 Successful mount of redo thread 1, with mount id 2024504388. Tue Sep 3 22:31:32 2002 Database mounted in Exclusive Mode. Completed: alter database mount Tue Sep 3 22:31:32 2002 alter database open Beginning crash recovery of 1 threads Tue Sep 3 22:31:32 2002 Thread recovery: start rolling forward thread 1 Recovery of Online Redo Log: Thread 1 Group 2 Seq 12491 Reading mem 0 Mem# 0 errs 0: /home/oracle/oradata/realeast/redo02.log Tue Sep 3 22:31:32 2002 Thread recovery: finish rolling forward thread 1 Thread recovery: 0 data blocks read, 0 data blocks written, 1 redo blocks read Crash recovery completed successfully Tue Sep 3 22:31:32 2002 Thread 1 advanced to log sequence 12492 Thread 1 opened at log sequence 12492 Current log# 3 seq# 12492 mem# 0: /home/oracle/oradata/realeast/redo03.log Successful open of redo thread 1. Tue Sep 3 22:31:32 2002 SMON: enabling cache recovery SMON: disabling cache recovery Tue Sep 3 22:31:32 2002 ORA-704 signalled during: alter database open ...
Пробовал менять размеры shm_pool_size, db_buffers, других - изменения реакции не заметил. Тем более с этими установками все было нормально до некорректного завершения.
Подскажите, кто сталкивался - как решать данную проблему ? Спасибо за грамотный совет.