Re: 8i (8.1.7.4.2) hangs on SHUTDOWN ABORT (WIN2000,SP3)

Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl> schreef in berichtnieuws r0edivg15ppfad5ph9mthq4cn3t3sb510p_at_4ax.com...
| On 29 Jul 2003 04:16:03 -0700, fatih.dokmeci_at_arcelik.com (fatih)
| wrote:
|
| >"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in
message news:<3f210f28$0$15041$ed9e5944_at_reading.news.pipex.net>...
| >> What does the alert.log say?
| >
| >just:

| >Thu Jul 24 00:04:56 2003
| >ORACLE V8.1.7.4.1 - Production vsnsta=0
| >vsnsql=f vsnxtr=3
| >Windows 2000 Version 5.0 Service Pack 3, CPU type 586
| >Starting up ORACLE RDBMS Version: 8.1.7.4.1.
| >System parameters with non-default values:
| > processes = 1000
| > timed_statistics = TRUE
| > shared_pool_size = 1153433600
| > nls_sort = TURKISH
| > nls_date_format = DD/MM/YYYY
| > control_files = F:\DTG\control1.con, F:\DTG\control2.con,
| >G:\DTG\control1A.con, G:\DTG\control2A.con, H:\DTG\control1B.con,
| >H:\DTG\control2B.con, I:\DTG\control1C.con, I:\DTG\control2C.con
| > db_block_buffers = 50000
| > db_block_size = 8192
| > compatible = 8.1.7
| > log_archive_start = TRUE
| > log_archive_dest_1 = location=D:\ARCH
| > log_archive_format = arch%s.arc
| > db_files = 100
| > dml_locks = 500
| > rollback_segments = r01, r02, r03, r04, r05, r06, r07, r08,
| >r09, r10, r11, r12, r13, r14, r15, r16, r17, r18, r19, r20, r21, r22,
| >r23, r24, r25, r26, r27, r28, r29, r30, r31, r32, r33, r34, r35, r36,
| >r37, r38, r39, r40, r50, r51, r52, r53, r54, r55, r56, r57, r58, r59,
| >r60, r61, r62, r63, r64, r65, r66, r67, r68, r69
| > remote_login_passwordfile= EXCLUSIVE
| > db_domain = WORLD
| > global_names = TRUE
| > open_links = 10
| > sort_area_size = 2097152
| > db_name = DTG
| > open_cursors = 2048
| > job_queue_processes = 10
| > job_queue_interval = 60
| > background_dump_dest = D:\DTG\log
| > user_dump_dest = D:\DTG\log
| > max_dump_file_size = 10240
| >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
| >SNP0 started with pid=8
| >SNP1 started with pid=9
| >SNP2 started with pid=10
| >SNP3 started with pid=11
| >SNP4 started with pid=12
| >SNP5 started with pid=13
| >SNP6 started with pid=14
| >SNP7 started with pid=15
| >SNP8 started with pid=16
| >SNP9 started with pid=17
| >Thu Jul 24 00:05:02 2003
| >ARCH: STARTING ARCH PROCESSES
| >ARC0 started with pid=18
| >Thu Jul 24 00:05:02 2003
| >ARC0: Archival started
| >Thu Jul 24 00:05:03 2003
| >ARCH: STARTING ARCH PROCESSES COMPLETE
| >Thu Jul 24 00:05:03 2003
| >alter database mount
| >Thu Jul 24 00:05:08 2003
| >Successful mount of redo thread 1, with mount id 3165929716.
| >Thu Jul 24 00:05:08 2003
| >Database mounted in Exclusive Mode.
| >Completed: alter database mount
| >Thu Jul 24 00:05:08 2003
| >alter database open
| >Beginning crash recovery of 1 threads
| >Thu Jul 24 00:05:08 2003
| >Thread recovery: start rolling forward thread 1
| >Recovery of Online Redo Log: Thread 1 Group 7 Seq 32583 Reading mem 0
| > Mem# 0 errs 0: F:\DTG\LOG7A.RDO
| >Thu Jul 24 00:05:11 2003
| >Thread recovery: finish rolling forward thread 1
| >Thread recovery: 1018 data blocks read, 940 data blocks written, 36914
| >redo blocks read
| >Crash recovery completed successfully
| >Thu Jul 24 00:05:12 2003
| >Thread 1 advanced to log sequence 32584
| >Thread 1 opened at log sequence 32584
| > Current log# 8 seq# 32584 mem# 0: F:\DTG\LOG8A.RDO
| >Successful open of redo thread 1.
| >Thu Jul 24 00:05:12 2003
| >SMON: enabling cache recovery
| >Thu Jul 24 00:05:12 2003
| >ARC0: Beginning to archive log# 7 seq# 32583
| >Thu Jul 24 00:05:13 2003
| >SMON: enabling tx recovery
| >Thu Jul 24 00:05:13 2003
| >ARC0: Completed archiving log# 7 seq# 32583
| >Thu Jul 24 00:05:19 2003
| >Completed: alter database open
| >Thu Jul 24 00:06:45 2003
| >Restarting dead background process EMN0
| >EMN0 started with pid=20
| >Thu Jul 24 00:06:45 2003
| >
| >Thanks for your attention..
|
| Is there any reason why you think Oracle should still function
| properly in such a mess? 60+ rollback segments, 2048 open cursors per
| sessions. And you are running such a configuration on Windoze!!!!
| It is quite clear your memory consumption for Oracle is so high the
| O/S will choke, ALL THE TIME
|
|
| Hire a consultant! NOW!
| Before your company goes bankrupt due to this incompetent database
| configuration.
|
|
| Sybrand Bakker, Senior Oracle DBA
|
| To reply remove -verwijderdit from my e-mail address

... and 8 control files and 1.1Gb shared pool and 1000 processes where high water mark was 125 and 10 job queue processes. Well, some can be needed but it seems overdone.... Received on Tue Jul 29 2003 - 14:25:55 CDT