Re: ORA-01033: Oracle initialization or shutdown in progress

From: Robert Wehofer <thalion77_at_graffiti.net>
Date: Fri, 04 Jul 2003 14:57:25 GMT
Message-ID: <pBgNa.106792$kC4.1749044@news.chello.at>

Ok!

I have again closed and started the database and following has been written to the alert log file:

Shutting down instance (immediate)
License high water mark = 2
Fri Jul 04 16:57:48 2003
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL... Fri Jul 04 16:57:48 2003
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
archiving is disabled
Starting up ORACLE RDBMS Version: 8.1.7.0.0. System parameters with non-default values:

  processes                = 150
  shared_pool_size         = 32765542
  large_pool_size          = 614400
  java_pool_size           = 32768
  control_files            = C:\Oracle\oradata\ORCL\control01.ctl,
C:\Oracle\oradata\ORCL\control02.ctl, C:\Oracle\oradata\ORCL\control03.ctl
  db_block_buffers         = 19200
  db_block_size            = 8192
  compatible               = 8.1.0
  log_buffer               = 32768
  log_checkpoint_interval  = 10000
  log_checkpoint_timeout   = 1800
  db_files                 = 1024
  db_file_multiblock_read_count= 8
  max_enabled_roles        = 30
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = GISquadrat
  global_names             = TRUE
  distributed_transactions = 10
  instance_name            = ORCL
  service_names            = ORCL.GISquadrat
  sort_area_size           = 262144
  sort_area_retained_size  = 65536
  db_name                  = ORCL
  open_cursors             = 300
  ifile                    = C:\Oracle\admin\ORCL\pfile\initORCL.ora
  os_authent_prefix        =
  parallel_max_servers     = 5
  background_dump_dest     = C:\Oracle\admin\ORCL\bdump
  user_dump_dest           = C:\Oracle\admin\ORCL\udump
  max_dump_file_size       = 10240

oracle_trace_collection_name=

PMON started with pid=2
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

Fri Jul 04 16:58:02 2003
alter database mount
Fri Jul 04 16:58:06 2003
Successful mount of redo thread 1, with mount id 1026252958. Fri Jul 04 16:58:06 2003
Database mounted in Exclusive Mode.
Completed: alter database mount
Fri Jul 04 16:58:06 2003
alter database open
Fri Jul 04 16:58:07 2003
Errors in file C:\Oracle\admin\ORCL\bdump\orclLGWR.TRC:

ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: 'C:\ORACLE\ORADATA\ORCL\REDO03.LOG'
ORA-27041: unable to open file
OSD-04002: Datei kann nicht geöffnet werden
O/S-Error: (OS 2) Das System kann die angegebene Datei nicht finden.

Fri Jul 04 16:58:07 2003
Errors in file C:\Oracle\admin\ORCL\bdump\orclLGWR.TRC:

ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: 'C:\ORACLE\ORADATA\ORCL\REDO03.LOG'
ORA-27041: unable to open file
OSD-04002: Datei kann nicht geöffnet werden
O/S-Error: (OS 2) Das System kann die angegebene Datei nicht finden.

ORA-313 signalled during: alter database open ... Received on Fri Jul 04 2003 - 09:57:25 CDT