Oracle10g 启动失败

大家好,我刚在windows xp 下面安装了一个数据实例install,用impdp导入数据后,数据库就启不来了。
我查看日志文件,因为不太懂错误信息,还是不能解决问题,大家帮我看看啊。
  谢谢了。
  日志如下:
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 ID159.1) 2008-07-17 22:32:23.656
kccsga_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 ID144.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)

    执行startup
    没有错误.
    就是过了一会 就出现

    SQL> show sga;
    ORA-01089: 正在执行立即关闭 - 不允许进行任何操作


    SQL> show sga;
    ERROR:
    ORA-03114: 未连接到 ORALCE


    SQL>
  • 一个死去的神仙 (2008-7-18 17:26:37)

    startup force
  • glietms (2008-7-18 17:43:36)

    08:42:00刚刚启动成功,08:42:47就自动停止了,正常运行了47秒。晕~~
  • glietms (2008-7-18 17:44:13)

    就是找不到自动停止的原因
  • hxlbj (2008-7-18 18:31:26)

    发d:\oracle\admin\install\udump\install_ora_844.trc内容
  • glietms (2008-7-20 13:48:15)

    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 ID144.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
  • luocb1980 (2008-7-22 14:51:34)

    1.startup mount
    2. alter database open
    看是否报错?
  • glietms (2008-7-24 21:22:09)

    QUOTE:

    原帖由 luocb1980 于 2008-7-22 14:51 发表
    1.startup mount
    2. alter database open
    看是否报错?
    没有错误,不过一会就出现
    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)

    非常感谢楼上。
    应该是这个问题。
    我后来重装数据库,用手动管理内存方式就可以了。谢谢~~~