ORA-07445错误解决一例
(2010-11-21 10:21:19)
标签:
杂谈 |
分类: oracle错误 |
检查最近安装好的一个oracle 10g AS metadata
Repository的警告日志文件,发现存在大量数据库错误信息,并有不少的ora-07445出现。
先模拟一下问题出现的情景。
关闭数据库,再启动,观察警告文件:
Sun Oct 10 20:46:24 2010
Starting ORACLE instance (normal)
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 44 private strand(s). Zero-copy redo is FALSE
IMODE=BR
ILAT =44
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 10.1.0.4.2.
System parameters with non-default values:
processes
= 150
sessions
= 400
sga_max_size
= 2147483648
__shared_pool_size
= 150994944
shared_pool_size
= 150994944
__large_pool_size
= 16777216
large_pool_size
= 16777216
__java_pool_size
= 67108864
java_pool_size
= 67108864
sga_target
= 2147483648
control_files
= /oradata/pkica/control01.ctl, /oradata/pkica/control02.ctl,
/oradata/pkica/control03.ctl
db_block_size
= 8192
__db_cache_size
= 1895825408
db_cache_size
= 50331648
max_commit_propagation_delay= 0
compatible
= 10.1.0.2.0
db_file_multiblock_read_count= 16
db_recovery_file_dest
= /oracle/flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management
= AUTO
undo_tablespace
= UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain
= pkioradb
dispatchers
= (PROTOCOL=TCP)(PRE=oracle.aurora.server.GiopServer),
(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
job_queue_processes
= 5
background_dump_dest
= /oracle/admin/pkica/bdump
user_dump_dest
= /oracle/admin/pkica/udump
core_dump_dest
= /oracle/admin/pkica/cdump
db_name
先模拟一下问题出现的情景。
关闭数据库,再启动,观察警告文件:
Sun Oct 10 20:46:24 2010
Starting ORACLE instance (normal)
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 44 private strand(s). Zero-copy redo is FALSE
IMODE=BR
ILAT =44
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 10.1.0.4.2.
System parameters with non-default values:
processes
sessions
sga_max_size
__shared_pool_size
shared_pool_size
__large_pool_size
large_pool_size
__java_pool_size
java_pool_size
sga_target
control_files
db_block_size
__db_cache_size
db_cache_size
max_commit_propagation_delay= 0
compatible
db_file_multiblock_read_count= 16
db_recovery_file_dest
db_recovery_file_dest_size= 2147483648
undo_management
undo_tablespace
remote_login_passwordfile= EXCLUSIVE
db_domain
dispatchers
job_queue_processes
background_dump_dest
user_dump_dest
core_dump_dest
db_name

加载中…