加载中…
个人资料
  • 博客等级:
  • 博客积分:
  • 博客访问:
  • 关注人气:
  • 获赠金笔:0支
  • 赠出金笔:0支
  • 荣誉徽章:
正文 字体大小:

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                  = pkica
open_cursors             = 300
pga_aggregate_target     = 1073741824
aq_tm_processes          = 1
Sun Oct 10 20:46:25 2010
error 46 encountered when initializing ldm.
Sun Oct 10 20:46:25 2010
error 46 encountered when initializing ldm.
PMON started with pid=2, OS id=32180
Sun Oct 10 20:46:25 2010
ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=pkioradb)(PORT=1521))'
Sun Oct 10 20:46:25 2010
error 46 encountered when initializing ldm.
MMAN started with pid=3, OS id=32182
Sun Oct 10 20:46:25 2010
error 46 encountered when initializing ldm.
DBW0 started with pid=4, OS id=32184
Sun Oct 10 20:46:25 2010
error 46 encountered when initializing ldm.
LGWR started with pid=5, OS id=32186
Sun Oct 10 20:46:25 2010
error 46 encountered when initializing ldm.
CKPT started with pid=6, OS id=32188
Sun Oct 10 20:46:25 2010
error 46 encountered when initializing ldm.
SMON started with pid=7, OS id=32190
Sun Oct 10 20:46:25 2010
error 46 encountered when initializing ldm.
RECO started with pid=8, OS id=32192
Sun Oct 10 20:46:25 2010
error 46 encountered when initializing ldm.
Sun Oct 10 20:46:25 2010
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
CJQ0 started with pid=9, OS id=32194
Sun Oct 10 20:46:25 2010
error 46 encountered when initializing ldm.
Sun Oct 10 20:46:25 2010
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Sun Oct 10 20:46:25 2010
error 46 encountered when initializing ldm.
Sun Oct 10 20:46:25 2010
starting up 1 shared server(s) ...
Sun Oct 10 20:46:25 2010
error 46 encountered when initializing ldm.
Sun Oct 10 20:46:25 2010
error 46 encountered when initializing ldm.
Sun Oct 10 20:46:25 2010
ALTER DATABASE   MOUNT
Sun Oct 10 20:46:28 2010
Controlfile identified with block size 16384
Sun Oct 10 20:46:32 2010
Setting recovery target incarnation to 2
Sun Oct 10 20:46:32 2010
Successful mount of redo thread 1, with mount id 2292384612
Sun Oct 10 20:46:32 2010
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE   MOUNT
error 46 encountered when initializing ldm.
Sun Oct 10 20:46:32 2010
ALTER DATABASE OPEN
Sun Oct 10 20:46:32 2010
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 53
Current log# 1 seq# 53 mem# 0: /oradata/pkica/redo01.log
Successful open of redo thread 1
Sun Oct 10 20:46:32 2010
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sun Oct 10 20:46:32 2010
SMON: enabling cache recovery
Sun Oct 10 20:46:33 2010
Successfully onlined Undo Tablespace 1.
Sun Oct 10 20:46:33 2010
SMON: enabling tx recovery
Sun Oct 10 20:46:33 2010
Database Characterset is AL32UTF8
Sun Oct 10 20:46:33 2010
Starting background process QMNC
Sun Oct 10 20:46:33 2010
error 46 encountered when initializing ldm.
QMNC started with pid=14, OS id=32208
Sun Oct 10 20:46:33 2010
replication_dependency_tracking turned off (no async multimaster replication found)
Sun Oct 10 20:46:33 2010
Starting background process MMON
Sun Oct 10 20:46:33 2010
error 46 encountered when initializing ldm.
Sun Oct 10 20:46:33 2010
Starting background process MMNL
MMON started with pid=15, OS id=32217
Sun Oct 10 20:46:33 2010
error 46 encountered when initializing ldm.
MMNL started with pid=16, OS id=32219
Sun Oct 10 20:46:33 2010
Completed: ALTER DATABASE OPEN
Sun Oct 10 20:46:33 2010
error 46 encountered when initializing ldm.
Sun Oct 10 20:46:33 2010
error 46 encountered when initializing ldm.
Sun Oct 10 20:46:33 2010
error 46 encountered when initializing ldm.
Sun Oct 10 20:46:33 2010
error 46 encountered when initializing ldm.
Sun Oct 10 20:46:33 2010
error 46 encountered when initializing ldm.
Sun Oct 10 20:46:36 2010
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.
Sun Oct 10 20:46:43 2010
error 46 encountered when initializing ldm.
Sun Oct 10 20:46:48 2010
error 46 encountered when initializing ldm.
Sun Oct 10 20:47:38 2010
error 46 encountered when initializing ldm.

启动完毕。
日志中出现initializing ldm初始化错误。同时还有ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=pkioradb)(PORT=1521))'。
运行ping pkioradb命令,居然提示unknown host。
检查/etc/hosts文件,发现如下信息:

127.0.0.1               pkiocadb localhost.localdomain localhost
10.129.*.*    sndaca2

hosts文件内容被人修改。

继续在sqlplus上运行:
SQL> select count(*) from lyqiu.tab;
select count(*) from lyqiu.tab
                           *
ERROR at line 1:
ORA-00942: table or view does not exist

此时,警告文件中出现ora-07445:

Sun Oct 10 20:48:36 2010
Errors in file /oracle/admin/pkica/bdump/pkica_mmon_32217.trc:
ORA-07445: exception encountered: core dump [keltinso()+3532] [SIGSEGV] [Address not mapped to object] [0x0] [] []
error 46 encountered when initializing ldm.
Sun Oct 10 20:49:24 2010
error 46 encountered when initializing ldm.
Sun Oct 10 20:49:48 2010
error 46 encountered when initializing ldm.

怀疑数据库报错的原因就是hosts文件内容不正确所致。
修改hosts文件为:
[root@pkioradb etc]# cat hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1               localhost.localdomain localhost
10.129.*.*    sndaca2
10.*.*.41     pkioradb
10.*.*.42     pkiorastd


重新启动数据库,查看警告日志:
Sun Oct 10 20:54:07 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                  = pkica
open_cursors             = 300
pga_aggregate_target     = 1073741824
aq_tm_processes          = 1
PMON started with pid=2, OS id=32403
MMAN started with pid=3, OS id=32405
DBW0 started with pid=4, OS id=32407
LGWR started with pid=5, OS id=32409
CKPT started with pid=6, OS id=32411
SMON started with pid=7, OS id=32413
RECO started with pid=8, OS id=32415
Sun Oct 10 20:54:07 2010
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
CJQ0 started with pid=9, OS id=32417
Sun Oct 10 20:54:07 2010
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Sun Oct 10 20:54:07 2010
ALTER DATABASE   MOUNT
Sun Oct 10 20:54:10 2010
Controlfile identified with block size 16384
Sun Oct 10 20:54:14 2010
Setting recovery target incarnation to 2
Sun Oct 10 20:54:15 2010
Successful mount of redo thread 1, with mount id 2292334898
Sun Oct 10 20:54:15 2010
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE   MOUNT
Sun Oct 10 20:54:15 2010
ALTER DATABASE OPEN
Sun Oct 10 20:54:15 2010
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 53
Current log# 1 seq# 53 mem# 0: /oradata/pkica/redo01.log
Successful open of redo thread 1
Sun Oct 10 20:54:15 2010
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sun Oct 10 20:54:15 2010
SMON: enabling cache recovery
Sun Oct 10 20:54:15 2010
Successfully onlined Undo Tablespace 1.
Sun Oct 10 20:54:15 2010
SMON: enabling tx recovery
Sun Oct 10 20:54:15 2010
Database Characterset is AL32UTF8
Sun Oct 10 20:54:15 2010
Starting background process QMNC
QMNC started with pid=14, OS id=32429
Sun Oct 10 20:54:16 2010
replication_dependency_tracking turned off (no async multimaster replication found)
Sun Oct 10 20:54:16 2010
Starting background process MMON
Starting background process MMNL
MMON started with pid=15, OS id=32431
MMNL started with pid=16, OS id=32433
Sun Oct 10 20:54:16 2010
Completed: ALTER DATABASE OPEN
Sun Oct 10 20:54:19 2010
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.

显示正常了。
再继续运行:
SQL> select count(*) from lyqiu.tab;
select count(*) from lyqiu.tab
                           *
ERROR at line 1:
ORA-00942: table or view does not exist

此时没有错误日志出现。

0

阅读 收藏 喜欢 打印举报/Report
后一篇:TNS-12514
  

新浪BLOG意见反馈留言板 欢迎批评指正

新浪简介 | About Sina | 广告服务 | 联系我们 | 招聘信息 | 网站律师 | SINA English | 产品答疑

新浪公司 版权所有