You may need to open a tar with Oracle support, in the meantime what does
/u31/app/oracle/admin/BASE/udump/base_ora_15807.trc contain?
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"NetComrade" <andreyNSPAM_at_bookexchange.net> wrote in message
news:3e765c4b.1838775960_at_nyc.news.speakeasy.net...
> 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 Tue Mar 18 2003 - 03:57:45 CST
