2010年03月03日

Wed Mar 03 05:44:17 2010
Errors in file d:\oracle\product\10.1.0\admin\myoracle\bdump\myoracle_ckpt_596.trc:
ORA-00221: error on write to controlfile
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: 'D:\DISK9\CONTROL03.CTL'
ORA-27072: File I/O error
OSD-04008: WriteFile() 失败, 无法写入文件
O/S-Error: (OS 1453) 配额不足，无法完成请求的服务。
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: 'D:\DISK6\CONTROL02.CTL'
ORA-27072: File I/O error
OSD-04008: WriteFile() 失败, 无法写入文件
O/S-Error: (OS 1453) 配额不足，无法完成请求的服务。
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: 'D:\DISK3\CONTROL01.CTL'
ORA-27072: File I/O error
OSD-04008: WriteFile() 失败, 无法写入文件
O/S-Error: (OS 1453) 配额不足，无法完成请求的服务。

 

Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
KCCDEBUG_LEVEL = 0
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
Dynamic strands is set to TRUE
Running with 2 shared and 18 private strand(s). Zero-copy redo is FALSE
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is enabled
Starting up ORACLE RDBMS Version: 10.1.0.2.0.
System parameters with non-default values:
  processes                = 150
  __shared_pool_size       = 83886080
  shared_pool_size         = 83886080
  large_pool_size          = 8388608
  java_pool_size           = 50331648
  resource_manager_plan    = SYSTEM_PLAN
  control_files            = D:\DISK3\CONTROL01.CTL, D:\DISK6\CONTROL02.CTL, D:\DISK9\CONTROL03.CTL
  db_block_size            = 8192
  db_cache_size            = 25165824
  db_cache_advice          = ON
  compatible               = 10.1.0.2.0
  db_file_multiblock_read_count= 16
  db_recovery_file_dest    = d:\oracle\product\10.1.0\flash_recovery_area
  db_recovery_file_dest_size= 21474836480
  undo_management          = AUTO
  undo_tablespace          = JERRY_UNDO
  remote_login_passwordfile= EXCLUSIVE
  audit_sys_operations     = TRUE
  db_domain                =
  dispatchers              = (PROTOCOL=TCP) (SERVICE=myoracleXDB)
  shared_servers           = 3
  job_queue_processes      = 10
  background_dump_dest     = D:\ORACLE\PRODUCT\10.1.0\ADMIN\MYORACLE\BDUMP
  user_dump_dest           = D:\ORACLE\PRODUCT\10.1.0\ADMIN\MYORACLE\UDUMP
  core_dump_dest           = D:\ORACLE\PRODUCT\10.1.0\ADMIN\MYORACLE\CDUMP
  audit_trail              = DB
  sort_area_size           = 65536
  db_name                  = myoracle
  open_cursors             = 300
  pga_aggregate_target     = 25165824
Wed Mar 03 11:22:58 2010
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 3 shared server(s) ...
LGWR started with pid=5, OS id=588
SMON started with pid=7, OS id=596
RECO started with pid=8, OS id=600
PMON started with pid=2, OS id=548
DBW0 started with pid=4, OS id=556
CJQ0 started with pid=9, OS id=604
MMAN started with pid=3, OS id=552
CKPT started with pid=6, OS id=592
Wed Mar 03 11:23:03 2010
alter database mount exclusive

 

 

处理：

 

SQL> connect / as sysdba
已连接到空闲例程。
SQL> startup
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shutdown immediate
ORA-24324: 未初始化服务句柄
ORA-24323: 不允许此值
ORA-00020: 超出最大进程数 (%s)
SQL> shutdown abort
ORA-01031: insufficient privileges
SQL> shutdown abort
ORA-01031: insufficient privileges
SQL> startup force
ORA-01031: insufficient privilege
SQL> startup mount
ORA-01031: insufficient privileges
SQL> 已断开连接

  0

回答者：