Re: URGENT: ORA-01554 upon startup

this db has been successfully running for the past few months. no /etc/system or init.ora parameters have been made

ALTER DATABASE OPEN
Beginning crash recovery of 1 threads

Mon Mar 17 17:15:16 2003

Thread recovery: start rolling forward thread 1 Recovery of Online Redo Log: Thread 1 Group 6 Seq 37566 Reading mem 0   Mem# 0 errs 0: /u31/oradata/BASE/redoBASE06.log Mon Mar 17 17:15:17 2003
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
Mon Mar 17 17:15:18 2003
Thread 1 advanced to log sequence 37567
Thread 1 opened at log sequence 37567
  Current log# 7 seq# 37567 mem# 0: /u31/oradata/BASE/redoBASE07.log Successful open of redo thread 1.
Mon Mar 17 17:15:19 2003
SMON: enabling cache recovery
Mon Mar 17 17:15:28 2003
Errors in file /u31/app/oracle/admin/BASE/udump/base_ora_15807.trc: ORA-00604: error occurred at recursive SQL level 1 ORA-01554: out of transaction slots in transaction tables Mon Mar 17 17:15:28 2003
Error 604 happened during db open, shutting down database USER: terminating instance due to error 604 Instance terminated by USER, pid = 15807 ORA-1092 signalled during: ALTER DATABASE OPEN...

On Mon, 17 Mar 2003 15:13:42 -0800, "Gabriel Gonzalez" <no-spam_at_no-spam.com> wrote:

>What's the alert log say?
>
>

.......
We use Oracle 8.1.7.4 on Solaris 2.7 boxes remove NSPAM to email Received on Mon Mar 17 2003 - 17:38:53 CST