Problem with starting Oracle instance: ORA-01034 in oradim.log

From: <f.cozzi_at_gmail.com>
Date: Wed, 05 Sep 2007 09:39:32 -0700
Message-ID: <1189010372.554118.172470@19g2000hsx.googlegroups.com>

Hello,
whenever I start up my Oracle instance (Orace 9.2.0.6 on Windows Server 2003) I get the following error in oradim.log:

Wed Sep 05 16:36:36 2007
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist

These should be the corresponding lines in alert.log:

Wed Sep 05 16:36:42 2007
ORACLE V9.2.0.6.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 586 Wed Sep 05 16:36:42 2007
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.6.0. System parameters with non-default values:

  processes                = 150
  timed_statistics         = TRUE
  shared_pool_size         = 50331648
  large_pool_size          = 8388608
  java_pool_size           = 33554432
  control_files            = E:\oradata\ARCHSOS\CONTROL01.CTL, C:

\oracle\oradata\ARCHSOS\CONTROL02.CTL, C:\oracle\oradata\ARCHSOS
\CONTROL03.CTL

  db_block_size            = 8192
  db_cache_size            = 25165824
  compatible               = 9.2.0.6.0

  db_file_multiblock_read_count= 16

  fast_start_mttr_target   = 300
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  undo_retention           = 10800
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = WORLD
  instance_name            = ARCHSOS
  dispatchers              = (PROTOCOL=TCP) (SERVICE=ARCHSOSXDB)
  job_queue_processes      = 10
  hash_join_enabled        = TRUE
  background_dump_dest     = C:\oracle\admin\ARCHSOS\bdump
  user_dump_dest           = C:\oracle\admin\ARCHSOS\udump
  core_dump_dest           = C:\oracle\admin\ARCHSOS\cdump
  sort_area_size           = 524288
  db_name                  = ARCHSOS
  open_cursors             = 300

  star_transformation_enabled= FALSE

  query_rewrite_enabled    = FALSE
  pga_aggregate_target     = 25165824
  aq_tm_processes          = 1
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

CJQ0 started with pid=8
QMN0 started with pid=9
Wed Sep 05 16:36:44 2007
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES) (PROTOCOL=TCP))'...
Wed Sep 05 16:36:45 2007
alter database mount exclusive
Wed Sep 05 16:36:49 2007
Successful mount of redo thread 1, with mount id 1036416349 Wed Sep 05 16:36:49 2007
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive Wed Sep 05 16:36:49 2007
alter database open
Wed Sep 05 16:36:49 2007
Thread 1 opened at log sequence 1362
  Current log# 2 seq# 1362 mem# 0: C:\ORACLE\ORADATA\ARCHSOS
\REDO02.LOG

Successful open of redo thread 1
Wed Sep 05 16:36:49 2007
SMON: enabling cache recovery
Wed Sep 05 16:36:50 2007
Successfully onlined Undo Tablespace 1.
Wed Sep 05 16:36:50 2007
SMON: enabling tx recovery
Wed Sep 05 16:36:50 2007
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open

However the instance is running and everything looks fine. Moreover, the lines in alert.log are a few seconds after the error in oradim.log.
What is the problem with oradim?

Thanks,
Federico Received on Wed Sep 05 2007 - 11:39:32 CDT