服务器操作系统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
racleproduct10.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
racleproduct10.1.0adminexpressudumpexpress_ora_2848.trc:
ORA-00704: 引导程序进程失败
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-04031: 无法分配 4096 字节的共享内存 ("shared pool","create table bootstrap$ ( li...","Typecheck heap","kgghteInit"
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
racleproduct10.1.0adminexpressdumpexpress_dbw0_2724.trc:
ORA-00704: bootstrap process failure
Wed Jun 11 17:13:02 2008
Errors in file d
racleproduct10.1.0adminexpressdumpexpress_lgwr_2732.trc:
ORA-00704: bootstrap process failure
Wed Jun 11 17:13:02 2008
Errors in file d
racleproduct10.1.0adminexpressdumpexpress_dbw1_2728.trc:
ORA-00704: bootstrap process failure
Wed Jun 11 17:13:02 2008
Errors in file d
racleproduct10.1.0adminexpressdumpexpress_ckpt_2736.trc:
ORA-00704: bootstrap process failure
Wed Jun 11 17:13:03 2008
Errors in file d
racleproduct10.1.0adminexpressdumpexpress_reco_2784.trc:
ORA-00704: bootstrap process failure
Wed Jun 11 17:13:03 2008
Errors in file d
racleproduct10.1.0adminexpressdumpexpress_pmon_2760.trc:
ORA-00704: bootstrap process failure
Wed Jun 11 17:13:03 2008
Errors in file d
racleproduct10.1.0adminexpressdumpexpress_smon_1140.trc:
ORA-00704: bootstrap process failure
Wed Jun 11 17:13:03 2008
Errors in file d
racleproduct10.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
2008-6-11 17:23 上传
点击文件名下载附件
104.2 KB, 下载次数: 18