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


<f.cozzi@xxxxxxxxx> schreef in bericht
news:1189010372.554118.172470@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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


Take a look at MEtalink note 238073.1

shakespeare


.

Relevant Pages