oracle starup失败,oracle startup失败提示ORA-04031

服务器操作系统windows 2003,用户在数据库使用的情况下重新启动了。再进入系统的时候,启动ORACLE服务失败。发现是startup就失败了操作如下:

SQL> startup

ORACLE 例程已经启动。

Total System Global Area  218103808 bytes

Fixed Size                   788188 bytes

Variable Size             146012452 bytes

Database Buffers           67108864 bytes

Redo Buffers                4194304 bytes

数据库装载完毕。

ORA-01092: ORACLE 例程终止。强制断开连接

然后查找altersid.log文件,搞不清是什么问题,请教各位如何解决。altersid.log文件内容如下:

Starting ORACLE instance (force)

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 disabled

Starting up ORACLE RDBMS Version: 10.1.0.2.0.

System parameters with non-default values:

processes                = 150

shared_pool_size         = 83886080

large_pool_size          = 8388608

java_pool_size           = 50331648

control_files            = D:ORACLEPRODUCT10.1.0ORADATAEXPRESSCONTROL01.CTL, D:ORACLEPRODUCT10.1.0ORADATAEXPRESSCONTROL02.CTL, D:ORACLEPRODUCT10.1.0ORADATAEXPRESSCONTROL03.CTL

db_block_size            = 8192

db_cache_size            = 67108864

_db_handles_cached       = 0

compatible               = 10.1.0.2.0

db_file_multiblock_read_count= 16

db_recovery_file_dest    = D

5b24fae4cde99750994428c024162093.gifracleproduct10.1.0flash_recovery_area

db_recovery_file_dest_size= 2147483648

undo_management          = AUTO

undo_tablespace          = UNDOTBS1

remote_login_passwordfile= EXCLUSIVE

db_domain                =

dispatchers              = (PROTOCOL=TCP) (SERVICE=expressXDB)

job_queue_processes      = 10

background_dump_dest     = D:ORACLEPRODUCT10.1.0ADMINEXPRESSBDUMP

user_dump_dest           = D:ORACLEPRODUCT10.1.0ADMINEXPRESSUDUMP

core_dump_dest           = D:ORACLEPRODUCT10.1.0ADMINEXPRESSCDUMP

sort_area_size           = 65536

db_name                  = express

open_cursors             = 300

pga_aggregate_target     = 25165824

PMON started with pid=2, OS id=2760

MMAN started with pid=3, OS id=2764

DBW0 started with pid=4, OS id=2724

DBW1 started with pid=5, OS id=2728

LGWR started with pid=6, OS id=2732

CKPT started with pid=7, OS id=2736

SMON started with pid=8, OS id=1140

RECO started with pid=9, OS id=2784

CJQ0 started with pid=10, OS id=1504

Wed Jun 11 17:12:56 2008

starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...

starting up 1 shared server(s) ...

Wed Jun 11 17:12:56 2008

ALTER DATABASE   MOUNT

Wed Jun 11 17:12:56 2008

Controlfile identified with block size 16384

Wed Jun 11 17:13:00 2008

Setting recovery target incarnation to 2

Wed Jun 11 17:13:00 2008

Successful mount of redo thread 1, with mount id 2918455896

Wed Jun 11 17:13:00 2008

Database mounted in Exclusive Mode.

Completed: ALTER DATABASE   MOUNT

Wed Jun 11 17:13:00 2008

ALTER DATABASE OPEN

Wed Jun 11 17:13:00 2008

Beginning crash recovery of 1 threads

attempting to start a parallel recovery with 15 processes

parallel recovery started with 15 processes

Wed Jun 11 17:13:01 2008

Started first pass scan

Wed Jun 11 17:13:01 2008

Completed first pass scan

1 redo blocks read, 0 data blocks need recovery

Wed Jun 11 17:13:01 2008

Started redo application at

Thread 1: logseq 1325, block 2, scn 0.6145417

Recovery of Online Redo Log: Thread 1 Group 1 Seq 1325 Reading mem 0

Mem# 0 errs 0: D:ORACLEPRODUCT10.1.0ORADATAEXPRESSREDO01.LOG

Wed Jun 11 17:13:01 2008

Completed redo application

Wed Jun 11 17:13:01 2008

Completed crash recovery at

Thread 1: logseq 1325, block 3, scn 0.6165419

0 data blocks read, 0 data blocks written, 1 redo blocks read

Wed Jun 11 17:13:01 2008

Thread 1 advanced to log sequence 1326

Maximum redo generation record size = 120832 bytes

Maximum redo generation change vector size = 116476 bytes

Private_strands 4 at log switch

Thread 1 opened at log sequence 1326

Current log# 2 seq# 1326 mem# 0: D:ORACLEPRODUCT10.1.0ORADATAEXPRESSREDO02.LOG

Successful open of redo thread 1

Wed Jun 11 17:13:01 2008

MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set

Wed Jun 11 17:13:01 2008

SMON: enabling cache recovery

Wed Jun 11 17:13:01 2008

Errors in file d

5b24fae4cde99750994428c024162093.gifracleproduct10.1.0adminexpressudumpexpress_ora_2848.trc:

ORA-00704: 引导程序进程失败

ORA-00604: 递归 SQL 级别 1 出现错误

ORA-04031: 无法分配 4096 字节的共享内存 ("shared pool","create table bootstrap$ ( li...","Typecheck heap","kgghteInit&quot

9f7588d3b12cd5d674b5f81c0b8fc6cb.gif

Wed Jun 11 17:13:01 2008

Error 704 happened during db open, shutting down database

USER: terminating instance due to error 704

Wed Jun 11 17:13:02 2008

Errors in file d

5b24fae4cde99750994428c024162093.gifracleproduct10.1.0adminexpressdumpexpress_dbw0_2724.trc:

ORA-00704: bootstrap process failure

Wed Jun 11 17:13:02 2008

Errors in file d

5b24fae4cde99750994428c024162093.gifracleproduct10.1.0adminexpressdumpexpress_lgwr_2732.trc:

ORA-00704: bootstrap process failure

Wed Jun 11 17:13:02 2008

Errors in file d

5b24fae4cde99750994428c024162093.gifracleproduct10.1.0adminexpressdumpexpress_dbw1_2728.trc:

ORA-00704: bootstrap process failure

Wed Jun 11 17:13:02 2008

Errors in file d

5b24fae4cde99750994428c024162093.gifracleproduct10.1.0adminexpressdumpexpress_ckpt_2736.trc:

ORA-00704: bootstrap process failure

Wed Jun 11 17:13:03 2008

Errors in file d

5b24fae4cde99750994428c024162093.gifracleproduct10.1.0adminexpressdumpexpress_reco_2784.trc:

ORA-00704: bootstrap process failure

Wed Jun 11 17:13:03 2008

Errors in file d

5b24fae4cde99750994428c024162093.gifracleproduct10.1.0adminexpressdumpexpress_pmon_2760.trc:

ORA-00704: bootstrap process failure

Wed Jun 11 17:13:03 2008

Errors in file d

5b24fae4cde99750994428c024162093.gifracleproduct10.1.0adminexpressdumpexpress_smon_1140.trc:

ORA-00704: bootstrap process failure

Wed Jun 11 17:13:03 2008

Errors in file d

5b24fae4cde99750994428c024162093.gifracleproduct10.1.0adminexpressdumpexpress_mman_2764.trc:

ORA-00704: bootstrap process failure

Instance terminated by USER, pid = 2848

ORA-1092 signalled during: ALTER DATABASE OPEN...

文件express_ora_2848.trc见附件express_ora_2848.txt

267abf8789d6bad6eaf3c8c87b18d9ed.gif

2008-6-11 17:23 上传

点击文件名下载附件

104.2 KB, 下载次数: 18