oracle shutdown immediate无响应,Oracle Shutdown immediate无响应

oracle database SHUTDOWN: waiting for active calls to complete。

oracle 数据库在 一次shutdown immediate 时hang住。

alter日志内容如下(日志具体路径在/ebspool/ceshi22/db/tech_st/11.1.0/admin/CESHI22_prod/diag/rdbms/ceshi22/CESHI22/trace)：

Mon Oct 18 13:06:09 2010

Active call for process 15846 user 'ebsora' program'oracle@prod'

Active call for process 14575 user 'ebsora' program'oracle@prod'

SHUTDOWN: waiting for active calls to complete.

Mon Oct 18 13:19:32 2010

Incremental checkpoint up to RBA [0x3.191e6d.0], current log tail at RBA [0x3.191e75.0]

Mon Oct 18 13:39:41 2010

Incremental checkpoint up to RBA [0x3.191e89.0], current log tail at RBA [0x3.191e91.0]

Mon Oct 18 13:59:51 2010

Incremental checkpoint up to RBA [0x3.191ea3.0], current log tail at RBA [0x3.191ea8.0]

Mon Oct 18 14:01:42 2010

SHUTDOWN: Active sessions prevent database close operation

Instance shutdown aborted

Mon Oct 18 14:01:42 2010

Starting background process SMCO

Mon Oct 18 14:01:42 2010

SMCO started with pid=40, OS id=16861

Mon Oct 18 14:02:11 2010

Beginning global checkpoint up to RBA [0x3.191eb3.10], SCN: 276461174

Completed checkpoint up to RBA [0x3.191eb3.10], SCN: 276461174

Mon Oct 18 14:02:16 2010

Stopping background process SMCO

Shutting down instance: further logons disabled

Shutting down instance (immediate)

License high water mark = 61

Mon Oct 18 14:07:19 2010

Active call for process 15846 user 'ebsora' program'oracle@prod'

Active call for process 14575 user 'ebsora' program'oracle@prod'

SHUTDOWN: waiting for active calls to complete.

metalink上相关的解决方法：

Locate and kill any client connections to the database at the Unix level, as

follows:

1. Locate any client connections to the database using ps, and grep for any

processes belonging to this .

Example: ps -ef | grep V733

2. Look for processes that include a 'Local=No' designation.

Example: osupport 6235 1 0 Nov 24 0:01 oracleV733 (LOCAL=NO)

3. Kill the Unix process(es) with the 'Local=No' designation.

Example: Kill -9 6235

将'Local=No' 的进程kill掉 数据库就马上正常关闭了

操作如下：

bash-3.00$ ps -ef|grep 15846

ebsora 17006 16923   0 14:24:54 pts/2       0:00 grep 15846

ebsora 15846     1   0 11:39:40 ?           6:29 oracleCESHI22 (LOCAL=NO)

bash-3.00$ ps -ef|grep 14575

ebsora 17008 16923   0 14:25:07 pts/2       0:00 grep 14575

ebsora 14575     1   0 09:57:07 ?           6:51 oracleCESHI22 (LOCAL=NO)

bash-3.00$ kill -9 15846

bash-3.00$ kill -9 14575

alter日志如下：

Mon Oct 18 14:20:00 2010

Incremental checkpoint up to RBA [0x3.191ec0.0], current log tail at RBA [0x3.191ec9.0]

Mon Oct 18 14:28:34 2010

ALTER DATABASE CLOSE NORMAL

Mon Oct 18 14:28:34 2010

SMON: disabling tx recovery

SMON: disabling cache recovery

Mon Oct 18 14:28:35 2010

Shutting down archive processes

Archiving is disabled

Archive process shutdown avoided: 0 active

Thread 1 closed at log sequence 3

Successful close of redo thread 1

Completed: ALTER DATABASE CLOSE NORMAL

ALTER DATABASE DISMOUNT

Completed: ALTER DATABASE DISMOUNT

ARCH: Archival disabled due to shutdown: 1089

Shutting down archive processes

Archiving is disabled

Archive process shutdown avoided: 0 active

ARCH: Archival disabled due to shutdown: 1089

Shutting down archive processes

Archiving is disabled

Archive process shutdown avoided: 0 active

Mon Oct 18 14:28:37 2010

Stopping background process VKTM:

Mon Oct 18 14:28:41 2010

Instance shutdown complete

Mon Oct 18 14:29:25 2010

Starting ORACLE instance (normal)

Mon Oct 18 14:29:40 2010

Errors in file /ebspool/ceshi22/db/tech_st/11.1.0/admin/CESHI22_prod/diag/rdbms/ceshi22/CESHI22/trace/CESHI22_ora_17039.trc:

ORA-27167: Attempt to determine if Oracle binary image is stored on remote server failed

ORA-27300: OS system dependent operation:parse_df failed with status: 2

ORA-27301: OS failure message: No such file or directory

ORA-27302: failure occurred at: parse failed

ORA-27303: additional information: Filesystem            kbytes    used   avail capacity  Mounted on

ebspool              573898752 286899296 286974917    50%    /ebspool

Image consistency checking encountered an error, checking disabled

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Picked latch-free SCN scheme 3

Using LOG_ARCHIVE_DEST_1 parameter default value as /ebspool/ceshi22/db/tech_st/11.1.0/dbs/arch

Autotune of undo retention is turned on.

IMODE=BR

ILAT =44

LICENSE_MAX_USERS = 0

SYS auditing is disabled

Starting up ORACLE RDBMS Version: 11.1.0.7.0.

Using parameter settings in server-side pfile /ebspool/ceshi22/db/tech_st/11.1.0/dbs/initCESHI22.ora

System parameters with non-default values:

processes                = 200

sessions                 = 400

timed_statistics         = TRUE

shared_pool_size         = 400M

shared_pool_reserved_size= 40M

nls_language             = "american"

nls_territory            = "america"

nls_sort                 = "binary"

nls_date_format          = "DD-MON-RR"

nls_numeric_characters   = ".,"

nls_comp                 = "binary"

nls_length_semantics     = "BYTE"

sga_target               = 1G

control_files            = "/ebspool/ceshi22/db/apps_st/data/cntrl01.dbf"

control_files            = "/ebspool/ceshi22/db/apps_st/data/cntrl02.dbf"

control_files            = "/ebspool/ceshi22/db/apps_st/data/cntrl03.dbf"

db_block_checksum        = "TRUE"

db_block_size            = 8192

compatible               = "11.1.0"

log_buffer               = 10485760

log_checkpoint_interval  = 100000

log_checkpoint_timeout   = 1200

db_files                 = 512

log_checkpoints_to_alert = TRUE

dml_locks                = 10000

undo_management          = "AUTO"

undo_tablespace          = "APPS_UNDOTS1"

db_block_checking        = "FALSE"

sec_case_sensitive_logon = FALSE

session_cached_cursors   = 500

utl_file_dir             = "/usr/tmp"

utl_file_dir             = "/usr/tmp"

utl_file_dir             = "/ebspool/ceshi22/db/tech_st/11.1.0/appsutil/outbound/CESHI22_prod"

utl_file_dir             = "/usr/tmp"

plsql_native_library_dir = "/ebspool/ceshi22/db/tech_st/11.1.0/plsql/nativelib"

plsql_native_library_subdir_count= 149

plsql_code_type          = "INTERPRETED"

plsql_optimize_level     = 2

job_queue_processes      = 2

_system_trig_enabled     = TRUE

cursor_sharing           = "EXACT"

parallel_min_servers     = 0

parallel_max_servers     = 8

db_name                  = "CESHI22"

open_cursors             = 600

ifile                    = "/ebspool/ceshi22/db/tech_st/11.1.0/dbs/CESHI22_prod_ifile.ora"

_sort_elimination_cost_ratio= 5

_b_tree_bitmap_plans     = FALSE

_fast_full_scan_enabled  = FALSE

query_rewrite_enabled    = "true"

_index_join_enabled      = FALSE

_sqlexec_progression_cost= 2147483647

_like_with_bind_as_equality= TRUE

pga_aggregate_target     = 1G

workarea_size_policy     = "AUTO"

_optimizer_autostats_job = FALSE

optimizer_secure_view_merging= FALSE

aq_tm_processes          = 1

olap_page_pool_size      = 4M

diagnostic_dest          = "/ebspool/ceshi22/db/tech_st/11.1.0/admin/CESHI22_prod"

_trace_files_public      = TRUE

max_dump_file_size       = "20480"

Mon Oct 18 14:29:41 2010

PMON started with pid=2, OS id=17047

Mon Oct 18 14:29:41 2010

VKTM started with pid=4, OS id=17049

VKTM running at (100ms) precision

Mon Oct 18 14:29:42 2010

DIAG started with pid=6, OS id=17053

Mon Oct 18 14:29:42 2010

DBRM started with pid=8, OS id=17055

Mon Oct 18 14:29:42 2010

PSP0 started with pid=10, OS id=17057

Mon Oct 18 14:29:42 2010

DIA0 started with pid=12, OS id=17059

Mon Oct 18 14:29:42 2010

MMAN started with pid=14, OS id=17061

Mon Oct 18 14:29:42 2010

DBW0 started with pid=16, OS id=17063

Mon Oct 18 14:29:42 2010

DBW1 started with pid=3, OS id=17065

Mon Oct 18 14:29:42 2010

DBW2 started with pid=18, OS id=17067

Mon Oct 18 14:29:42 2010

DBW3 started with pid=5, OS id=17069

Mon Oct 18 14:29:42 2010

DBW4 started with pid=20, OS id=17071

Mon Oct 18 14:29:43 2010

DBW5 started with pid=7, OS id=17073

Mon Oct 18 14:29:43 2010

DBW6 started with pid=22, OS id=17075

Mon Oct 18 14:29:43 2010

DBW7 started with pid=9, OS id=17077

Mon Oct 18 14:29:43 2010

DBW8 started with pid=24, OS id=17079

Mon Oct 18 14:29:43 2010

DBW9 started with pid=11, OS id=17081

Mon Oct 18 14:29:43 2010

DBWa started with pid=26, OS id=17083

Mon Oct 18 14:29:43 2010

DBWb started with pid=13, OS id=17085

Mon Oct 18 14:29:43 2010

DBWc started with pid=28, OS id=17087

Mon Oct 18 14:29:43 2010

DBWd started with pid=15, OS id=17089

Mon Oct 18 14:29:43 2010

DBWe started with pid=30, OS id=17091

Mon Oct 18 14:29:43 2010

DBWf started with pid=17, OS id=17093

Mon Oct 18 14:29:44 2010

LGWR started with pid=19, OS id=17095

Mon Oct 18 14:29:44 2010

CKPT started with pid=32, OS id=17097

Mon Oct 18 14:29:44 2010

SMON started with pid=34, OS id=17099

Mon Oct 18 14:29:44 2010

RECO started with pid=36, OS id=17101

Mon Oct 18 14:29:44 2010

MMON started with pid=38, OS id=17103

Mon Oct 18 14:29:44 2010

MMNL started with pid=40, OS id=17105

ORACLE_BASE not set in environment. It is recommended

that ORACLE_BASE be set in the environment

Mon Oct 18 14:29:44 2010

ALTER DATABASE   MOUNT

Setting recovery target incarnation to 2

Successful mount of redo thread 1, with mount id 816215384

Database mounted in Exclusive Mode

Lost write protection disabled

Completed: ALTER DATABASE   MOUNT

Mon Oct 18 14:29:49 2010

ALTER DATABASE OPEN

Thread 1 opened at log sequence 3

Current log# 1 seq# 3 mem# 0: /ebspool/ceshi22/db/apps_st/data/log01a.dbf

Current log# 1 seq# 3 mem# 1: /ebspool/ceshi22/db/apps_st/data/log01b.dbf

Successful open of redo thread 1

MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set

SMON: enabling cache recovery

Incremental checkpoint up to RBA [0x3.191f2c.0], current log tail at RBA [0x3.191f2c.0]

Successfully onlined Undo Tablespace 1.

Verifying file header compatibility for 11g tablespace encryption..

Verifying 11g file header compatibility for tablespace encryption completed

SMON: enabling tx recovery

Database Characterset is UTF8

Opening with internal Resource Manager plan : on 2 X 64 NUMA system

Starting background process FBDA

Mon Oct 18 14:29:52 2010

FBDA started with pid=23, OS id=17113

replication_dependency_tracking turned off (no async multimaster replication found)

Starting background process QMNC

Mon Oct 18 14:29:54 2010

QMNC started with pid=42, OS id=17117

Completed: ALTER DATABASE OPEN

Mon Oct 18 14:29:59 2010

Starting background process CJQ0

Mon Oct 18 14:29:59 2010

CJQ0 started with pid=48, OS id=17133

Setting Resource Manager plan SCHEDULER[0x56D95]:DEFAULT_MAINTENANCE_PLAN via scheduler window

Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter

Mon Oct 18 14:34:51 2010

Beginning log switch checkpoint up to RBA [0x4.2.10], SCN: 276505552

Thread 1 advanced to log sequence 4 (LGWR switch)

Current log# 2 seq# 4 mem# 0: /ebspool/ceshi22/db/apps_st/data/log02a.dbf

Current log# 2 seq# 4 mem# 1: /ebspool/ceshi22/db/apps_st/data/log02b.dbf

Mon Oct 18 14:35:14 2010

Completed checkpoint up to RBA [0x4.2.10], SCN: 276505552

Mon Oct 18 14:38:55 2010

Starting background process SMCO

Mon Oct 18 14:38:55 2010

SMCO started with pid=82, OS id=17861

一切正常

注意：为了尽量避免关闭数据库时出现假死现象，最好在关闭应用后查看一下应用进程是不是全部已经关闭，可以使用ps -ef |grep app_user在系统中进行检查。

原先从网上找到资料，并且在环境中出现shutdown immediate假死时，是使用alter system checkpoint解决的，这次碰到还是没法解决，直接找到alert文件查到相关的进程kill

连接到:

Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> shutdown immediate;

ORA-01013: 用户请求取消当前的操作

SQL> alter system checkpoint;

系统已更改。

SQL> shutdown immediate