具体的alert_orcl_log日志信息如下,菜鸟求大侠帮助
Instance terminated by PMON, pid = 2064
Tue Apr 23 09:16:29 2013
Adjusting the default value of parameter parallel_max_servers
from 160 to 135 due to the value of parameter processes (150)
Tue Apr 23 09:16:29 2013
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.1.0.
System parameters with non-default values:
processes = 150
__shared_pool_size = 125829120
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = D:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\SPFILEORCL.ORA
sga_target = 612368384
control_files = D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 469762048
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = D:\oracle\product\10.2.0/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=orclXDB)
job_queue_processes = 10
audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = orcl
open_cursors = 300
pga_aggregate_target = 203423744
PMON started with pid=2, OS id=1804
PSP0 started with pid=3, OS id=3864
MMAN started with pid=4, OS id=1808
DBW0 started with pid=5, OS id=1252
LGWR started with pid=6, OS id=2928
CKPT started with pid=7, OS id=500
SMON started with pid=8, OS id=2880
RECO started with pid=9, OS id=3004
CJQ0 started with pid=10, OS id=1864
MMON started with pid=11, OS id=2956
MMNL started with pid=12, OS id=912
Tue Apr 23 09:16:29 2013
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Tue Apr 23 09:16:29 2013
ALTER DATABASE MOUNT
Tue Apr 23 09:16:34 2013
Setting recovery target incarnation to 2
Tue Apr 23 09:16:34 2013
Successful mount of redo thread 1, with mount id 1341250670
Tue Apr 23 09:16:34 2013
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Tue Apr 23 09:16:34 2013
ALTER DATABASE OPEN
Tue Apr 23 09:16:34 2013
Beginning crash recovery of 1 threads
parallel recovery started with 7 processes
Tue Apr 23 09:16:35 2013
Started redo scan
Tue Apr 23 09:16:35 2013
Completed redo scan
1003 redo blocks read, 355 data blocks need recovery
Tue Apr 23 09:16:35 2013
Started redo application at
Thread 1: logseq 13556617, block 3
Tue Apr 23 09:16:35 2013
Recovery of Online Redo Log: Thread 1 Group 3 Seq 13556617 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Tue Apr 23 09:16:35 2013
Completed redo application
Tue Apr 23 09:16:35 2013
Completed crash recovery at
Thread 1: logseq 13556617, block 1006, scn 5650173901948
355 data blocks read, 355 data blocks written, 1003 redo blocks read
Tue Apr 23 09:16:35 2013
Thread 1 advanced to log sequence 13556618
Thread 1 opened at log sequence 13556618
Current log# 1 seq# 13556618 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Successful open of redo thread 1
Tue Apr 23 09:16:35 2013
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Tue Apr 23 09:16:35 2013
SMON: enabling cache recovery
Tue Apr 23 09:16:35 2013
Successfully onlined Undo Tablespace 1.
Tue Apr 23 09:16:35 2013
SMON: enabling tx recovery
Tue Apr 23 09:16:35 2013
Database Characterset is ZHS16GBK
Tue Apr 23 09:16:36 2013
SMON: Restarting fast_start parallel rollback
Tue Apr 23 09:16:36 2013
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_p002_3376.trc:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []Tue Apr 23 09:16:36 2013
replication_dependency_tracking turned off (no async multimaster replication found)
Tue Apr 23 09:16:36 2013
SMON: Parallel transaction recovery slave got internal error
SMON: Downgrading transaction recovery to serial
Tue Apr 23 09:16:36 2013
Starting background process QMNC
QMNC started with pid=32, OS id=4004
Tue Apr 23 09:16:36 2013
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_2880.trc:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []Tue Apr 23 09:16:37 2013
ORACLE Instance orcl (pid = 8) - Error 600 encountered while recovering transaction (6, 34) on object 274917.
Tue Apr 23 09:16:37 2013
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_2880.trc:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []Tue Apr 23 09:16:37 2013
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_2880.trc:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []ORACLE Instance orcl (pid = 8) - Error 600 encountered while recovering transaction (6, 34) on object 274917.
Tue Apr 23 09:16:37 2013
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_2880.trc:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []Tue Apr 23 09:16:38 2013
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_2880.trc:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []Tue Apr 23 09:16:38 2013
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.
Tue Apr 23 09:16:38 2013
ORACLE Instance orcl (pid = 8) - Error 600 encountered while recovering transaction (6, 34) on object 274917.
Tue Apr 23 09:16:38 2013
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_2880.trc:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []Tue Apr 23 09:16:38 2013
Completed: ALTER DATABASE OPEN
Tue Apr 23 09:16:39 2013
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_2880.trc:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []Tue Apr 23 09:16:39 2013
ORACLE Instance orcl (pid = 8) - Error 600 encountered while recovering transaction (6, 34) on object 274917.
Tue Apr 23 09:16:39 2013
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_2880.trc:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []Tue Apr 23 09:16:40 2013
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_2880.trc:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []Tue Apr 23 09:16:40 2013
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_pmon_1804.trc:
ORA-00474: SMON process terminated with errorTue Apr 23 09:16:40 2013
PMON: terminating instance due to error 474
Tue Apr 23 09:16:40 2013
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_m000_3916.trc:
ORA-00474: SMON process terminated with errorTue Apr 23 09:16:40 2013
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_j007_2280.trc:
ORA-00474: SMON process terminated with errorTue Apr 23 09:16:41 2013
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_j006_420.trc:
ORA-00474: SMON process terminated with errorTue Apr 23 09:16:41 2013
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_j005_568.trc:
ORA-00474: SMON process terminated with errorTue Apr 23 09:16:41 2013
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_mman_1808.trc:
ORA-00474: SMON process terminated with errorTue Apr 23 09:16:41 2013
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_lgwr_2928.trc:
ORA-00474: SMON process terminated with errorTue Apr 23 09:16:41 2013
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_psp0_3864.trc:
ORA-00474: SMON process terminated with errorTue Apr 23 09:16:41 2013
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_dbw0_1252.trc:
ORA-00474: SMON process terminated with errorTue Apr 23 09:16:41 2013
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_ckpt_500.trc:
ORA-00474: SMON process terminated with errorTue Apr 23 09:16:41 2013
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_j002_2628.trc:
ORA-00474: SMON process terminated with error
ora-00600[6006
Instance terminated by PMON, pid = 2064
Tue Apr 23 09:16:29 2013
Adjusting the default value of parameter parallel_max_servers
from 160 to 135 due to the value of parameter processes (150)
Tue Apr 23 09:16:29 2013
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.1.0.
System parameters with non-default values:
processes = 150
__shared_pool_size = 125829120
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = D:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\SPFILEORCL.ORA
sga_target = 612368384
control_files = D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 469762048
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = D:\oracle\product\10.2.0/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=orclXDB)
job_queue_processes = 10
audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = orcl
open_cursors = 300
pga_aggregate_target = 203423744
PMON started with pid=2, OS id=1804
PSP0 started with pid=3, OS id=3864
MMAN started with pid=4, OS id=1808
DBW0 started with pid=5, OS id=1252
LGWR started with pid=6, OS id=2928
CKPT started with pid=7, OS id=500
SMON started with pid=8, OS id=2880
RECO started with pid=9, OS id=3004
CJQ0 started with pid=10, OS id=1864
MMON started with pid=11, OS id=2956
MMNL started with pid=12, OS id=912
Tue Apr 23 09:16:29 2013
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Tue Apr 23 09:16:29 2013
ALTER DATABASE MOUNT
Tue Apr 23 09:16:34 2013
Setting recovery target incarnation to 2
Tue Apr 23 09:16:34 2013
Successful mount of redo thread 1, with mount id 1341250670
Tue Apr 23 09:16:34 2013
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Tue Apr 23 09:16:34 2013
ALTER DATABASE OPEN
Tue Apr 23 09:16:34 2013
Beginning crash recovery of 1 threads
parallel recovery started with 7 processes
Tue Apr 23 09:16:35 2013
Started redo scan
Tue Apr 23 09:16:35 2013
Completed redo scan
1003 redo blocks read, 355 data blocks need recovery
Tue Apr 23 09:16:35 2013
Started redo application at
Thread 1: logseq 13556617, block 3
Tue Apr 23 09:16:35 2013
Recovery of Online Redo Log: Thread 1 Group 3 Seq 13556617 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Tue Apr 23 09:16:35 2013
Completed redo application
Tue Apr 23 09:16:35 2013
Completed crash recovery at
Thread 1: logseq 13556617, block 1006, scn 5650173901948
355 data blocks read, 355 data blocks written, 1003 redo blocks read
Tue Apr 23 09:16:35 2013
Thread 1 advanced to log sequence 13556618
Thread 1 opened at log sequence 13556618
Current log# 1 seq# 13556618 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Successful open of redo thread 1
Tue Apr 23 09:16:35 2013
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Tue Apr 23 09:16:35 2013
SMON: enabling cache recovery
Tue Apr 23 09:16:35 2013
Successfully onlined Undo Tablespace 1.
Tue Apr 23 09:16:35 2013
SMON: enabling tx recovery
Tue Apr 23 09:16:35 2013
Database Characterset is ZHS16GBK
Tue Apr 23 09:16:36 2013
SMON: Restarting fast_start parallel rollback
Tue Apr 23 09:16:36 2013
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_p002_3376.trc:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []Tue Apr 23 09:16:36 2013
replication_dependency_tracking turned off (no async multimaster replication found)
Tue Apr 23 09:16:36 2013
SMON: Parallel transaction recovery slave got internal error
SMON: Downgrading transaction recovery to serial
Tue Apr 23 09:16:36 2013
Starting background process QMNC
QMNC started with pid=32, OS id=4004
Tue Apr 23 09:16:36 2013
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_2880.trc:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []Tue Apr 23 09:16:37 2013
ORACLE Instance orcl (pid = 8) - Error 600 encountered while recovering transaction (6, 34) on object 274917.
Tue Apr 23 09:16:37 2013
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_2880.trc:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []Tue Apr 23 09:16:37 2013
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_2880.trc:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []ORACLE Instance orcl (pid = 8) - Error 600 encountered while recovering transaction (6, 34) on object 274917.
Tue Apr 23 09:16:37 2013
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_2880.trc:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []Tue Apr 23 09:16:38 2013
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_2880.trc:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []Tue Apr 23 09:16:38 2013
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.
Tue Apr 23 09:16:38 2013
ORACLE Instance orcl (pid = 8) - Error 600 encountered while recovering transaction (6, 34) on object 274917.
Tue Apr 23 09:16:38 2013
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_2880.trc:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []Tue Apr 23 09:16:38 2013
Completed: ALTER DATABASE OPEN
Tue Apr 23 09:16:39 2013
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_2880.trc:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []Tue Apr 23 09:16:39 2013
ORACLE Instance orcl (pid = 8) - Error 600 encountered while recovering transaction (6, 34) on object 274917.
Tue Apr 23 09:16:39 2013
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_2880.trc:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []Tue Apr 23 09:16:40 2013
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_2880.trc:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []Tue Apr 23 09:16:40 2013
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_pmon_1804.trc:
ORA-00474: SMON process terminated with errorTue Apr 23 09:16:40 2013
PMON: terminating instance due to error 474
Tue Apr 23 09:16:40 2013
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_m000_3916.trc:
ORA-00474: SMON process terminated with errorTue Apr 23 09:16:40 2013
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_j007_2280.trc:
ORA-00474: SMON process terminated with errorTue Apr 23 09:16:41 2013
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_j006_420.trc:
ORA-00474: SMON process terminated with errorTue Apr 23 09:16:41 2013
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_j005_568.trc:
ORA-00474: SMON process terminated with errorTue Apr 23 09:16:41 2013
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_mman_1808.trc:
ORA-00474: SMON process terminated with errorTue Apr 23 09:16:41 2013
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_lgwr_2928.trc:
ORA-00474: SMON process terminated with errorTue Apr 23 09:16:41 2013
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_psp0_3864.trc:
ORA-00474: SMON process terminated with errorTue Apr 23 09:16:41 2013
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_dbw0_1252.trc:
ORA-00474: SMON process terminated with errorTue Apr 23 09:16:41 2013
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_ckpt_500.trc:
ORA-00474: SMON process terminated with errorTue Apr 23 09:16:41 2013
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_j002_2628.trc:
ORA-00474: SMON process terminated with error
ora-00600[6006
conn /as sysdba 后 startup命令提示数据库装载完毕已打开,但是使用其他用户连接就会提示
ERROR:
ORA-01092: ORACLE 实例终止。强制断开连接
ERROR:
ORA-12154: TNS: 无法解析指定的连接标识符
警告: 您不再连接到 ORACLE。
qq号:107644445【惜分飞 www.xifenfei.com】