Always have to do startup force to get db started

From: Winbatch <winbatch_at_techie.com>
Date: Thu, 8 Aug 2002 23:57:36 -0400
Message-ID: <aivejn$r7n$1_at_bob.news.rcn.net>


For some reason, my database won't startup when I type dbstart. I just get "warm started". My oratab indicates that the database should start. I have to go into svrmgrl and type startup force everytime. Any idea why? Here's what I did:

$ dbstart

Database "ora816" warm started.

$ svrmgrl

Oracle Server Manager Release 3.1.6.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production

With the Partitioning option

JServer Release 8.1.6.0.0 - Production

SVRMGR> connect internal

Connected.

SVRMGR> startup force

ORACLE instance started.

Total System Global Area 73178852 bytes

Fixed Size 69348 bytes

Variable Size 39383040 bytes

Database Buffers 33554432 bytes

Redo Buffers 172032 bytes

Database mounted.

Database opened.

SVRMGR> quit

Server Manager complete.

$ dbshut

Oracle Server Manager Release 3.1.6.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production

With the Partitioning option

JServer Release 8.1.6.0.0 - Production

SVRMGR> Connected.

SVRMGR> Database closed.

Database dismounted.

ORACLE instance shut down.

SVRMGR> Server Manager complete.

Database "ora816" shut down.

$ dbstart

Database "ora816" warm started. <- note, same problem

$ Received on Fri Aug 09 2002 - 05:57:36 CEST

Original text of this message