Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Problems with Oracle Services

Re: Problems with Oracle Services

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 27 Apr 2002 00:06:33 +0200
Message-ID: <ucjjpnp6v1a077@corp.supernews.com>

"Dominik Zimmerer" <dominik.zimmerer_at_med.uni-jena.de> wrote in message news:aacc0j$9kgap$1_at_ID-140794.news.dfncis.de...
> > >Hello Mr. Bakker,
> > >
> > >okay, i checked System Log before i wrote, but the messages i got are
not
> > >worth to read it, but here they come (i hope my translations are okay,
> > >because
> > >i got german error messages):
> > >
> > >Event-ID:7022
> > >User: ---
> > >Source: Service Control Manager
> > >Kind of Error: Error
> > >Computer CopraL1
> > >Description: The OracleServiceOEMREP stopped while starting.
> > >(means he was starting and stopped to continue work because it hang)
> > >
> > >Event-ID:7001
> > >User: ---
> > >Source Service Control Manager
> > >Kind of Error: Error
> > >Computer: CopraL1
> > >Cathegory: ---
> > >Description: OracleOra90ManagementServer is depending on
> > >OracleServiceOEMREP
> > > which failed start. Error: The Service couldn't be
> > >started.
> > >
> > >Thats all i got. No more messages.
> > >
> > >I hope you can read more out of them than i could.
> > >
> > >
> > >
> > The reason of course is in alert_OEMREP.log, which I already asked you
> > to verify. If you have a default install (sounds like you have)
> > this file is in c:\oracle\admin\oemrep\bdump.
> >
> > Regards
> >
> >
> > Sybrand Bakker, Senior Oracle DBA
> >
> > To reply remove -verwijderdit from my e-mail address
>
> Hello Mr. Bakker,
>
> Oh, thx, i didn't thought about this one.
>
> But do you need the whole file? i just took the messages from the last
start
> today.
> I hope they will work - the file is pritty long.
>
> Here it comes:
>
> Fri Apr 26 11:27:38 2002
> ORACLE V9.0.1.1.1 - Production vsnsta=0
> vsnsql=10 vsnxtr=3
> Windows NT Version 4.0 Service Pack 5, CPU type 586
> Starting up ORACLE RDBMS Version: 9.0.1.1.1.
> System parameters with non-default values:
> processes = 150
> timed_statistics = TRUE
> shared_pool_size = 46137344
> large_pool_size = 1048576
> java_pool_size = 33554432
> control_files = D:\oracle\oradata\OEMREP\CONTROL01.CTL,
> D:\oracle\oradata\OEMREP\CONTROL02.CTL,
> D:\oracle\oradata\OEMREP\CONTROL03.CTL
> db_block_size = 4096
> db_cache_size = 33554432
> compatible = 9.0.0
> fast_start_mttr_target = 300
> undo_management = AUTO
> undo_tablespace = UNDOTBS
> remote_login_passwordfile= EXCLUSIVE
> db_domain =
> instance_name = OEMREP
> dispatchers = (PROTOCOL=TCP)(SER=MODOSE),
> (PROTOCOL=TCP)(PRE=oracle.aurora.server.GiopServer),
> (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
> background_dump_dest = D:\oracle\admin\OEMREP\bdump
> user_dump_dest = D:\oracle\admin\OEMREP\udump
> core_dump_dest = D:\oracle\admin\OEMREP\cdump
> sort_area_size = 524288
> db_name = OEMREP
> open_cursors = 300
> ifile = D:\oracle\admin\OEMREP\pfile\init.ora
> 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 Apr 26 11:27:40 2002
> starting up 1 shared server(s) ...
> starting up 1 dispatcher(s) for network address
> '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
> starting up 1 dispatcher(s) for network address
> '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
> starting up 1 dispatcher(s) for network address
> '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
> Fri Apr 26 11:30:00 2002
> alter database mount exclusive
> Fri Apr 26 11:30:06 2002
> Successful mount of redo thread 1, with mount id 3151587128.
> Fri Apr 26 11:30:06 2002
> Database mounted in Exclusive Mode.
> Completed: alter database mount exclusive
> Fri Apr 26 11:30:06 2002
> alter database open
> Fri Apr 26 11:30:07 2002
> Beginning crash recovery of 1 threads
> Fri Apr 26 11:30:08 2002
> Started first pass scan
> Fri Apr 26 11:30:13 2002
> Completed first pass scan
> Fri Apr 26 11:30:13 2002
> Started recovery at
> Thread 1: logseq 26, block 177354, scn 0.0
> Recovery of Online Redo Log: Thread 1 Group 1 Seq 26 Reading mem 0
> Mem# 0 errs 0: D:\ORACLE\ORADATA\OEMREP\REDO01.LOG
> Fri Apr 26 11:30:14 2002
> Ended recovery at
> Thread 1: logseq 26, block 177436, scn 0.1400519
> 28 data blocks read, 28 data blocks written, 82 redo blocks read
> Crash recovery completed successfully
> Fri Apr 26 11:30:17 2002
> Thread 1 advanced to log sequence 27
> Thread 1 opened at log sequence 27
> Current log# 2 seq# 27 mem# 0: D:\ORACLE\ORADATA\OEMREP\REDO02.LOG
> Successful open of redo thread 1.
> Fri Apr 26 11:30:18 2002
> SMON: enabling cache recovery
> Fri Apr 26 11:30:21 2002
> Undo Segment 1 Onlined
> Undo Segment 2 Onlined
> Undo Segment 3 Onlined
> Undo Segment 4 Onlined
> Undo Segment 5 Onlined
> Undo Segment 6 Onlined
> Undo Segment 7 Onlined
> Undo Segment 8 Onlined
> Undo Segment 9 Onlined
> Undo Segment 10 Onlined
> Successfully onlined Undo Tablespace 1.
> Fri Apr 26 11:30:21 2002
> SMON: enabling tx recovery
> Fri Apr 26 11:30:40 2002
> replication_dependency_tracking turned off (no async multimaster
replication
> found)
> Completed: alter database open
>
> Thats all from today.
>
> How you probably realized... my knowledge about Oracle Server is
> not so good, so please be a bit patient with me, thanks.
>
>
> PS:
>
> I found this in the udump directory... not sure what it means
>
> Dump file D:\oracle\admin\OEMREP\udump\oemrepEMN0.TRC
> Thu Mar 14 12:23:07 2002
> ORACLE V9.0.1.1.1 - Production vsnsta=0
> vsnsql=10 vsnxtr=3
> Windows NT Version 4.0 Service Pack 5, CPU type 586
> Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production
> With the Partitioning option
> JServer Release 9.0.1.1.1 - Production
> Windows NT Version 4.0 Service Pack 5, CPU type 586
> Instance name: oemrep
>
> Redo thread mounted by this instance: 0 <none>
>
> Oracle process number: 0
>
> 129
>
>
> *** SESSION ID:(8.44) 2002-03-14 12:23:07.000
> OPIRIP: Uncaught error 1089. Error stack:
> ORA-01089: immediate shutdown in progress - no operations are permitted
>
>
> Thanks again, i hope you can help me.
>
> Dominik Zimmerer
>
>

Too late here to respond in more detail, especially as this is a brain cracker: the alert doesn't provide much clues (except for some weird init.ora parameters) and the other file is way too old.

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address



>
>
>
Received on Fri Apr 26 2002 - 17:06:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US