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

On Sep 5, 11:39 am, "f.co..._at_gmail.com" <f.co..._at_gmail.com> wrote:
> 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

Is the associated service started? How, exactly, are you running oradim?

David Fitzjarrell Received on Wed Sep 05 2007 - 11:46:45 CDT