暂无图片
分享
圣雪良缘
2019-03-28
oracle10g rac 无法启动

环境

2节点rac  目前仅一个节点可用。
主机 aix5.3
hacmp

o crs 10.2.0.1

oralce 10.2.0.2 


数据库节点集群启动正常。

数据库实例无法启动。

日志如下:

 

 

Wed Mar 27 17:10:23 2019

Starting ORACLE instance (normal)

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Interface type 1 en0 192.168.0.0 configured from OCR for use as a cluster interconnect

Interface type 1 en2 10.10.11.0 configured from OCR for use as  a public interface

Interface type 1 en3 10.10.12.0 configured from OCR for use as  a public interface

Picked latch-free SCN scheme 3

Autotune of undo retention is turned on.

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.2.0.

System parameters with non-default values:

  processes                = 1500

  sessions                 = 1655

  __shared_pool_size       = 520093696

  __large_pool_size        = 16777216

  __java_pool_size         = 16777216

  __streams_pool_size      = 33554432

  spfile                   = /dev/rxxdb_spfile

  sga_target               = 5351931904

  control_files            = /dev/rxxdb_ctl1, /dev/rxxdb_ctl2, /dev/rxxdb_ctl3

  db_block_size            = 8192

  __db_cache_size          = 4747952128

  compatible               = 10.2.0.2.0

  log_archive_dest_1       = location=/arch_sjxxdb2

  log_archive_dest_2       = 

  log_archive_dest_state_2 = DEFER

  log_archive_format       = arch_%d_%t_%s_%r.arc

  db_files                 = 450

  db_file_multiblock_read_count= 16

  cluster_database         = TRUE

  cluster_database_instances= 2

  thread                   = 2

  instance_number          = 2

  undo_management          = AUTO

  undo_tablespace          = UNDOTBS2

  remote_login_passwordfile= EXCLUSIVE

  db_domain                =

  dispatchers              = (PROTOCOL=TCP) (SERVICE=sjxxdbXDB)

  local_listener           = LISTENERS_LOCAL

  remote_listener          = LISTENERS_SJXXDB

  job_queue_processes      = 1000

  background_dump_dest     = /u01/app/oracle/admin/sjxxdb/bdump

  user_dump_dest           = /u01/app/oracle/admin/sjxxdb/udump

  core_dump_dest           = /u01/app/oracle/admin/sjxxdb/cdump

  audit_file_dest          = /u01/app/oracle/admin/sjxxdb/adump

  db_name                  = xxdb

  open_cursors             = 300

  optimizer_mode           = CHOOSE

  pga_aggregate_target     = 1780482048

Cluster communication is configured to use the following interface(s) for this instance

  192.168.0.2

Wed Mar 27 17:10:23 2019

cluster interconnect IPC version:Oracle UDP/IP (generic)

IPC Vendor 1 proto 2

PMON started with pid=2, OS id=266518

DIAG started with pid=3, OS id=242020

PSP0 started with pid=4, OS id=258374

LMON started with pid=5, OS id=299260

LMD0 started with pid=6, OS id=246014

LMS0 started with pid=7, OS id=201210

LMS1 started with pid=8, OS id=344144

MMAN started with pid=9, OS id=237958

DBW0 started with pid=10, OS id=209278

LGWR started with pid=11, OS id=290996

CKPT started with pid=12, OS id=360522

SMON started with pid=13, OS id=86428

RECO started with pid=14, OS id=250248

CJQ0 started with pid=15, OS id=217410

MMON started with pid=16, OS id=184724

Wed Mar 27 17:10:24 2019

starting up 1 dispatcher(s) for netwoxx address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...

MMNL started with pid=17, OS id=270638

Wed Mar 27 17:10:24 2019

starting up 1 shared server(s) ...

Wed Mar 27 17:10:24 2019

Errors in file /u01/app/oracle/admin/sjxxdb/bdump/sjxxdb2_ckpt_360522.trc:

ORA-00600: internal error code, arguments: [545], [0x700000149132660], [18700], [16], [], [], [], []

Wed Mar 27 17:10:24 2019

lmon registered with NM - instance id 2 (internal mem no 1)

Wed Mar 27 17:10:25 2019

Errors in file /u01/app/oracle/admin/sjxxdb/bdump/sjxxdb2_ckpt_360522.trc:

ORA-00600: internal error code, arguments: [545], [0x700000149132660], [18700], [16], [], [], [], []

Wed Mar 27 17:10:25 2019

CKPT: terminating instance due to error 469

Wed Mar 27 17:10:25 2019

Trace dumping is performing id=[cdmp_20190327171025]

Wed Mar 27 17:10:27 2019

Shutting down instance (abort)

License high water maxx = 0

Wed Mar 27 17:10:30 2019

Instance terminated by CKPT, pid = 360522


之前数据其启动报错为ORA00439,通过重新relink  rac及crs后就报如上错误。
做过的操作是make -f ins_rdbms.mk rac_on ioracle

请教下这个问题该如何解决下。谢谢

收藏
分享
7条回答
默认
最新
圣雪良缘
上传附件:sjrkdb2_ckpt_360522.trc
暂无图片 评论
暂无图片 有用 0
Moone

为什么relink?之前做过什么变更吗?什么时候开始无法启动,之前可以启动吗?

请上传正常运行时及其后的alertlog文件

暂无图片 评论
暂无图片 有用 0
圣雪良缘

relink 是因为数据库启动的时候报ORA00439


之前可以启动。


重新链接后无果。



暂无图片 评论
暂无图片 有用 0
圣雪良缘
上传附件:alert.txt
暂无图片 评论
暂无图片 有用 0
圣雪良缘

日志太大,截取了部分。在日志之前的日期系统正常。

暂无图片 评论
暂无图片 有用 0
Moone

你的日志没有看到再次启动的记录:

Tue Mar 26 17:03:15 2019

starting up 1 shared server(s) ...

USER: terminating instance due to error 29702

Instance terminated by USER, pid = 225564


relink前是否做了备份,建议恢复再试。

暂无图片 评论
暂无图片 有用 0
章芋文
问题已关闭: 问题已经过期
暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
附件列表
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏