免费视频淫片aa毛片_日韩高清在线亚洲专区vr_日韩大片免费观看视频播放_亚洲欧美国产精品完整版

oracle database SHUTDOWN: waiting for active calls to complete。

oracle 數(shù)據(jù)庫(kù)在 一次shutdown immediate 時(shí)hang住。

alter日志內(nèi)容如下（日志具體路徑在/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上相關(guān)的解決方法：

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' 的進(jìn)程kill掉 數(shù)據(jù)庫(kù)就馬上正常關(guān)閉了

操作如下：

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

一切正常

注意：為了盡量避免關(guān)閉數(shù)據(jù)庫(kù)時(shí)出現(xiàn)假死現(xiàn)象，最好在關(guān)閉應(yīng)用后查看一下應(yīng)用進(jìn)程是不是全部已經(jīng)關(guān)閉，可以使用ps -ef |grep app_user在系統(tǒng)中進(jìn)行檢查。

原先從網(wǎng)上找到資料，并且在環(huán)境中出現(xiàn)shutdown immediate假死時(shí)，是使用alter system checkpoint解決的，這次碰到還是沒(méi)法解決，直接找到alert文件查到相關(guān)的進(jìn)程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: 用戶(hù)請(qǐng)求取消當(dāng)前的操作
SQL> alter system checkpoint;

系統(tǒng)已更改。

SQL> shutdown immediate