Chinaunix

标题: oracle rac 建库时 ora-00603错误 [打印本页]

作者: sunxi52215 时间: 2007-04-14 15:52
标题: oracle rac 建库时 ora-00603错误
oracle rac 建库时 ora-00603错误

ORA-00603:ORACLE server session terminated by fatal error

环境
aix 5300-05-06
hacmp 5.4.0.1
oracle 9.2.0.1 升级到 9.2.0.4

新装系统，ha启动无误，共享磁盘启动成concurrent模式
listener配置成功并且启动，
ip 地址

10.37.148.2 node1
10.40.1.1 node1_boot1 node1
10.41.1.1 node1_boot2

10.37.148.3 node1
10.40.1.2 node2_boot1 node2
10.41.1.2 node2_boot2

建库时报ora-00603错误
服务器的网络参数没有设置过，都是aix原始参数，现在不在机房没办法拿到参数给大家贴上来
oracle用户参数都设置过了，不知道这个问题大家有没有遇见过，如何解决

还有一篇文档说oracle 9.2.0.7 补丁解决了这个问题，不知道是不是，没有metalink的号，无法查

alter.log

Mon Apr 16 04:47:55 2007
Starting ORACLE instance (normal)
Mon Apr 16 04:47:55 2007
Global Enqueue Service Resources = 64, pool = 8
Mon Apr 16 04:47:55 2007
Global Enqueue Service Enqueues = 128
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
GES IPC: Receivers 1  Senders 1
GES IPC: Buffers  Receive 1000  Send 530  Reserve 300
GES IPC: Msg Size  Regular 440  Batch 2048
SCN scheme 3
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.5.0.
System parameters with non-default values:
  processes             = 150
  timed_statistics       = TRUE
  shared_pool_size       = 117440512
  large_pool_size       = 16777216
  java_pool_size          = 0
  control_files          = /dev/rga_cntrl1, /dev/rga_cntrl2, /dev/rga_cntrl3
  db_block_size          = 8192
  db_cache_size          = 33554432
  compatible             = 9.2.0.0.0
  db_file_multiblock_read_count= 16
  cluster_database_instances= 1
  thread                = 1
  fast_start_mttr_target = 300
  instance_number       = 1
  undo_management       = AUTO
  undo_tablespace       = UNDOTBS1
  undo_retention          = 10800
  remote_login_passwordfile= EXCLUSIVE
  db_domain             =
  instance_name          = ga1
  local_listener          = LISTENER_GA1
  remote_listener       = LISTENERS_GA
  hash_join_enabled       = TRUE
  background_dump_dest    = /u01/admin/ga/bdump
  user_dump_dest          = /u01/admin/ga/udump
  core_dump_dest          = /u01/admin/ga/cdump
  sort_area_size          = 33554432
  db_name                = ga
  open_cursors          = 300
  star_transformation_enabled= FALSE
  query_rewrite_enabled = FALSE
  pga_aggregate_target    = 25165824
Mon Apr 16 04:47:57 2007
Errors in file /u01/admin/ga/udump/ga1_ora_233562.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-27504: IPC error creating OSD context
ORA-27300: OS system dependent operation:socket failed with status: 68
ORA-27301: OS failure message: Can't assign requested address
ORA-27302: failure occurred at: sskgxpcre1

[ 本帖最后由 sunxi52215 于 2007-4-16 14:47 编辑 ]

作者: sunxi52215 时间: 2007-04-14 20:03
有没有人有metalink的号啊，帮忙查一查啊

作者: zhen917 时间: 2007-04-14 21:20
就只有这一个错误信息吗? 你能不能把建库LOG发上来看看

作者: sunxi52215 时间: 2007-04-15 08:20
oracle/admin/下只有个实例的名称，实例名下面没有其他文件，log应该在这里吧

作者: sunxi52215 时间: 2007-04-16 14:43
alter.log

Mon Apr 16 04:47:55 2007
Starting ORACLE instance (normal)
Mon Apr 16 04:47:55 2007
Global Enqueue Service Resources = 64, pool = 8
Mon Apr 16 04:47:55 2007
Global Enqueue Service Enqueues = 128
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
GES IPC: Receivers 1  Senders 1
GES IPC: Buffers  Receive 1000  Send 530  Reserve 300
GES IPC: Msg Size  Regular 440  Batch 2048
SCN scheme 3
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.5.0.
System parameters with non-default values:
  processes             = 150
  timed_statistics       = TRUE
  shared_pool_size       = 117440512
  large_pool_size       = 16777216
  java_pool_size          = 0
  control_files          = /dev/rga_cntrl1, /dev/rga_cntrl2, /dev/rga_cntrl3
  db_block_size          = 8192
  db_cache_size          = 33554432
  compatible             = 9.2.0.0.0
  db_file_multiblock_read_count= 16
  cluster_database_instances= 1
  thread                = 1
  fast_start_mttr_target = 300
  instance_number       = 1
  undo_management       = AUTO
  undo_tablespace       = UNDOTBS1
  undo_retention          = 10800
  remote_login_passwordfile= EXCLUSIVE
  db_domain             =
  instance_name          = ga1
  local_listener          = LISTENER_GA1
  remote_listener       = LISTENERS_GA
  hash_join_enabled       = TRUE
  background_dump_dest    = /u01/admin/ga/bdump
  user_dump_dest          = /u01/admin/ga/udump
  core_dump_dest          = /u01/admin/ga/cdump
  sort_area_size          = 33554432
  db_name                = ga
  open_cursors          = 300
  star_transformation_enabled= FALSE
  query_rewrite_enabled = FALSE
  pga_aggregate_target    = 25165824
Mon Apr 16 04:47:57 2007
Errors in file /u01/admin/ga/udump/ga1_ora_233562.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-27504: IPC error creating OSD context
ORA-27300: OS system dependent operation:socket failed with status: 68
ORA-27301: OS failure message: Can't assign requested address
ORA-27302: failure occurred at: sskgxpcre1

[ 本帖最后由 sunxi52215 于 2007-4-16 14:46 编辑 ]

作者: sunxi52215 时间: 2007-04-17 14:45
我查了很多文档说添加了cluster_interconnects参数就可以解决了，
在dbca中填写参数的地方如图，无法填写两个
ga1.cluster_interconnects="10.40.1.1:10.41.1.1"
ga2.cluster_interconnects="10.40.1.2:10.41.1.2"
参数
在dbca向导中填写的生成的pfile是如下显示
cluster_interconnects="ga1.cluster_interconnects = '10.40.1.1'", "ga1.cluster_interconnects = '10.40.1.2'"

请问在dbca中怎么正确填写cluster_interconnects参数啊，请各位大哥看看啊

cluster_interconnects.JPG (183.16 KB, 下载次数: 42)

cluster_interconnects

作者: 天涯明月刀 时间: 2007-04-17 15:30
ORA-00603:ORACLE server session terminated by fatal error

检查一下修改的网络参数有没有生效。
操作系统的

作者: sunxi52215 时间: 2007-04-17 20:11
检查过都生效了

作者: blue_stone 时间: 2007-04-17 23:57
能否启动到nomount状态
试下手工建立数据库看看

作者: sunxi52215 时间: 2007-04-23 13:17
这个问题好像已经解决了，又遇到其他问题导致在2号机上库不能启动，等解决了那个问题才知道这个问题的解决方案是否正确

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)