我查看日志文件,因为不太懂错误信息,还是不能解决问题,大家帮我看看啊。
谢谢了。
日志如下:
Dump file d:\oracle\admin\install\bdump\alert_install.log
Thu Jul 17 22:32:13 2008
ORACLE V10.2.0.3.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU : 1 - type 586, 1 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:673M/1263M, Ph+PgF:2580M/3007M, VA:1939M/2047M
Thu Jul 17 22:32:14 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.3.0.
System parameters with non-default values:
processes = 150
__shared_pool_size = 142606336
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 4194304
sga_target = 167772160
control_files = D:\ORACLE\ORADATA\INSTALL\CONTROL01.CTL, D:\ORACLE\ORADATA\INSTALL\CONTROL02.CTL, D:\ORACLE\ORADATA\INSTALL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 8388608
compatible = 10.2.0.3.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = D:\oracle\flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=installXDB)
job_queue_processes = 10
audit_file_dest = D:\ORACLE\ADMIN\INSTALL\ADUMP
background_dump_dest = D:\ORACLE\ADMIN\INSTALL\BDUMP
user_dump_dest = D:\ORACLE\ADMIN\INSTALL\UDUMP
core_dump_dest = D:\ORACLE\ADMIN\INSTALL\CDUMP
db_name = install
open_cursors = 300
pga_aggregate_target = 20971520
PSP0 started with pid=3, OS id=2700
PMON started with pid=2, OS id=1016
MMAN started with pid=4, OS id=2428
DBW0 started with pid=5, OS id=2504
LGWR started with pid=6, OS id=808
CKPT started with pid=7, OS id=2588
SMON started with pid=8, OS id=1860
RECO started with pid=9, OS id=2636
CJQ0 started with pid=10, OS id=2676
Thu Jul 17 22:32:19 2008
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=2564
Thu Jul 17 22:32:19 2008
starting up 1 shared server(s) ...
MMON started with pid=11, OS id=2656
Thu Jul 17 22:32:23 2008
alter database mount exclusive
Thu Jul 17 22:32:28 2008
Setting recovery target incarnation to 2
Thu Jul 17 22:32:28 2008
Successful mount of redo thread 1, with mount id 3918602743
Thu Jul 17 22:32:28 2008
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Thu Jul 17 22:32:29 2008
alter database open
Thu Jul 17 22:32:34 2008
Thread 1 opened at log sequence 7
Current log# 3 seq# 7 mem# 0: D:\ORACLE\ORADATA\INSTALL\REDO03.LOG
Successful open of redo thread 1
Thu Jul 17 22:32:34 2008
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Thu Jul 17 22:32:34 2008
SMON: enabling cache recovery
Thu Jul 17 22:32:40 2008
Successfully onlined Undo Tablespace 1.
Thu Jul 17 22:32:40 2008
SMON: enabling tx recovery
Thu Jul 17 22:32:41 2008
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=16, OS id=3044
Thu Jul 17 22:33:05 2008
Completed: alter database open
Thu Jul 17 22:33:09 2008
db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Thu Jul 17 22:33:22 2008
Starting background process EMN0
EMN0 started with pid=21, OS id=3796
Thu Jul 17 22:33:22 2008
Shutting down instance: further logons disabled
Thu Jul 17 22:33:24 2008
Stopping background process QMNC
Thu Jul 17 22:33:24 2008
Stopping background process CJQ0
Thu Jul 17 22:33:25 2008
Stopping background process MMNL
Thu Jul 17 22:33:26 2008
Stopping background process MMON
Thu Jul 17 22:33:33 2008
Shutting down instance (immediate)
License high water mark = 3
Thu Jul 17 22:33:33 2008
Stopping Job queue slave processes
Thu Jul 17 22:33:33 2008
Job queue slave processes stopped
All dispatchers and shared servers shutdown
Thu Jul 17 22:33:39 2008
alter database close normal
Thu Jul 17 22:33:39 2008
SMON: disabling tx recovery
SMON: disabling cache recovery
Thu Jul 17 22:33:41 2008
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 7
Successful close of redo thread 1
Thu Jul 17 22:33:43 2008
Completed: alter database close normal
Thu Jul 17 22:33:43 2008
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
D:\oracle\admin\install\udum\install_ora_*.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the OLAP and Data Mining options
Windows XP Version V5.1 Service Pack 3
CPU : 1 - type 586, 1 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:660M/1263M, Ph+PgF:2428M/3007M, VA:1779M/2047M
Instance name: install
Redo thread mounted by this instance: 0 <none>
Oracle process number: 0
Windows thread id: 2372, image: ORACLE.EXE (SHAD)
KCCDEBUG_LEVEL = 0
Dynamic strand is set to TRUE
Running with 1 shared and 18 private strand(s). Zero-copy redo is FALSE
Dump file d:\oracle\admin\install\udump\install_ora_1632.trc
Thu Jul 17 22:32:23 2008
ORACLE V10.2.0.3.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the OLAP and Data Mining options
Windows XP Version V5.1 Service Pack 3
CPU : 1 - type 586, 1 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:616M/1263M, Ph+PgF:2399M/3007M, VA:1744M/2047M
Instance name: install
Redo thread mounted by this instance: 0 <none>
Oracle process number: 15
Windows thread id: 1632, image: ORACLE.EXE (SHAD)
*** SERVICE NAME
) 2008-07-17 22:32:23.656*** SESSION ID
159.1) 2008-07-17 22:32:23.656kccsga_update_ckpt: num_1 = 8, num_2 = 0, num_3 = 0, lbn_2 = 0, lbn_3 = 0
Dump file d:\oracle\admin\install\udump\install_ora_844.trc
Thu Jul 17 22:33:43 2008
ORACLE V10.2.0.3.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the OLAP and Data Mining options
Windows XP Version V5.1 Service Pack 3
CPU : 1 - type 586, 1 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:590M/1263M, Ph+PgF:2401M/3007M, VA:1748M/2047M
Instance name: install
Redo thread mounted by this instance: 0 <none>
Oracle process number: 20
Windows thread id: 844, image: ORACLE.EXE (SHAD)
*** 2008-07-17 22:33:43.609
*** SERVICE NAME
) 2008-07-17 22:33:43.578*** SESSION ID
144.3) 2008-07-17 22:33:43.578*** 2008-07-17 22:33:43.578 61283 kcrr.c
ARCH: Archival disabled due to shutdown: 1089
*** 2008-07-17 22:33:44.640 61283 kcrr.c
ARCH: Archival disabled due to shutdown: 1089

最新回复
yzsind (2008-7-18 08:36:52)
glietms (2008-7-18 08:52:57)
SQL> show sga;
Total System Global Area 167772160 bytes
Fixed Size 1289508 bytes
Variable Size 146801372 bytes
Database Buffers 16777216 bytes
Redo Buffers 2904064 bytes
SQL> show sga;
ORA-01089: 正在执行立即关闭 - 不允许进行任何操作
SQL> show sga;
ERROR:
ORA-03114: 未连接到 ORALCE
SQL>
glietms (2008-7-18 09:00:15)
事件类型: 信息
事件来源: Service Control Manager
事件种类: 无
事件 ID: 7035
日期: 2008-07-18
事件: 08:41:29
用户: Administrator
描述:
OracleServiceINSTALL 服务成功发送一个 开始 控件。
事件类型: 信息
事件来源: Service Control Manager
事件种类: 无
事件 ID: 7036
日期: 2008-07-18
事件: 08:42:00
用户: N/A
描述:
OracleServiceINSTALL 服务处于 正在运行 状态。
事件类型: 信息
事件来源: Service Control Manager
事件种类: 无
事件 ID: 7035
日期: 2008-07-18
事件: 08:42:47
用户: Administrator
描述:
OracleServiceINSTALL 服务成功发送一个 停止 控件。
事件类型: 信息
事件来源: Service Control Manager
事件种类: 无
事件 ID: 7036
日期: 2008-07-18
事件: 08:43:06
用户: N/A
描述:
OracleServiceINSTALL 服务处于 停止 状态。
08:42:00刚刚启动成功,08:42:47就自动停止了,正常运行了47秒。晕~~
glietms (2008-7-18 09:04:40)
事件类型: 信息
事件来源: Oracle.install
事件种类: 无
事件 ID: 34
日期: 2008-07-18
事件: 08:41:53
用户: N/A
描述:
Audit trail: ACTION : 'CONNECT' DATABASE USER: '/' PRIVILEGE : SYSDBA CLIENT USER: server\Administrator CLIENT TERMINAL: server STATUS: 0 .
事件类型: 信息
事件来源: Oracle.install
事件种类: 无
事件 ID: 34
日期: 2008-07-18
事件: 08:42:14
用户: N/A
计算机: server
描述:
Audit trail: ACTION : 'CONNECT' DATABASE USER: '/' PRIVILEGE : SYSDBA CLIENT USER: server\Administrator CLIENT TERMINAL: server STATUS: 0 .
事件类型: 信息
事件来源: Oracle.install
事件种类: 无
事件 ID: 34
日期: 2008-07-18
事件: 08:42:48
用户: N/A
计算机: server
描述:
Audit trail: ACTION : 'CONNECT' DATABASE USER: '/' PRIVILEGE : SYSDBA CLIENT USER: NT AUTHORITY\SYSTEM CLIENT TERMINAL: server STATUS: 0 .
hxlbj (2008-7-18 10:05:37)
startup
看报什么错
glietms (2008-7-18 17:20:08)
没有错误.
就是过了一会 就出现
SQL> show sga;
ORA-01089: 正在执行立即关闭 - 不允许进行任何操作
SQL> show sga;
ERROR:
ORA-03114: 未连接到 ORALCE
SQL>
一个死去的神仙 (2008-7-18 17:26:37)
glietms (2008-7-18 17:43:36)
glietms (2008-7-18 17:44:13)
hxlbj (2008-7-18 18:31:26)
glietms (2008-7-20 13:48:15)
Thu Jul 17 22:33:43 2008
ORACLE V10.2.0.3.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the OLAP and Data Mining options
Windows XP Version V5.1 Service Pack 3
CPU : 1 - type 586, 1 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:590M/1263M, Ph+PgF:2401M/3007M, VA:1748M/2047M
Instance name: install
Redo thread mounted by this instance: 0 <none>
Oracle process number: 20
Windows thread id: 844, image: ORACLE.EXE (SHAD)
*** 2008-07-17 22:33:43.609
*** SERVICE NAME) 2008-07-17 22:33:43.578
*** SESSION ID
*** 2008-07-17 22:33:43.578 61283 kcrr.c
ARCH: Archival disabled due to shutdown: 1089
*** 2008-07-17 22:33:44.640 61283 kcrr.c
ARCH: Archival disabled due to shutdown: 1089
luocb1980 (2008-7-22 14:51:34)
2. alter database open
看是否报错?
glietms (2008-7-24 21:22:09)
QUOTE:
没有错误,不过一会就出现SQL> show sga;
ORA-01089: 正在执行立即关闭 - 不允许进行任何操作
SQL> show sga;
ERROR:
ORA-03114: 未连接到 ORALCE
hxlbj (2008-7-25 10:20:49)
看看上面解决方法
glietms (2008-7-26 21:01:40)
应该是这个问题。
我后来重装数据库,用手动管理内存方式就可以了。谢谢~~~