环境
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
请教下这个问题该如何解决下。谢谢
墨值悬赏

评论
