Home » RDBMS Server » Server Administration » database open hangs
database open hangs [message #60754] Tue, 02 March 2004 21:11 Go to next message
Shravana Kumar
Messages: 4
Registered: December 2002
Junior Member
We are using oracle 9.2.0 for SUN solaris 2.8

The database open seems to hang when i startup the database.

Alert log file says "ALTER DATABASE OPEN". it hangs after that. i don't see any error there.

SQL>connect / as sysdba
connected
SQL>startup
ORACLE instance started.

Total System Global Area 555189776 bytes
Fixed Size 730640 bytes
Variable Size 335544320 bytes
Database Buffers 218103808 bytes
Redo Buffers 811008 Bytes
Database mounted.

Thanks

Report message to a moderator

Re: database open hangs [message #60759 is a reply to message #60754] Tue, 02 March 2004 22:22 Go to previous messageGo to next message
Sam
Messages: 255
Registered: April 2000
Senior Member
if ur database in archive log mode check the archive log destination, if it got filled up

Report message to a moderator

Re: database open hangs [message #60764 is a reply to message #60754] Wed, 03 March 2004 05:44 Go to previous message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
Hi,
Is there a SMON trace file ? If yes,what does it say ?

-Thiru

Report message to a moderator

Previous Topic: MOVE table with LONG datatype column - Oracle 8i Release 8.1.7.2.0
Next Topic: some doubt about the CKPT background process
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 12:31:07 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.