Re: Problems with Oracle Services

From: Dominik Zimmerer <dominik.zimmerer_at_med.uni-jena.de>
Date: Fri, 26 Apr 2002 22:06:42 +0200
Message-ID: <aacc0j$9kgap$1@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 Received on Fri Apr 26 2002 - 15:06:42 CDT