rac 9204up9206问题

ecwwf

在两台AIX52ML06+9204的机器做UP9206
文件是升级上了,但是发现在升级数据库时做
startup migrate时报
SQL> startup migrate
ORA-00603: ORACLE server session terminated by fatal error
why?

rollingpig

看看alertlog

blue_stone

cluster_server参数应该设置为false楼主设置了么？

ecwwf

Starting up ORACLE RDBMS Version: 9.2.0.6.0.
System parameters with non-default values:
  processes                = 150
  timed_statistics         = TRUE
  shared_pool_size         = 536870912
  large_pool_size          = 16777216
  java_pool_size           = 117440512
  spfile                   = /dev/rSPFILE
  cluster_interconnects    = 168.33.115.246
  control_files            = /dev/rCONTROLFILE_01, /dev/rCONTROLFILE_02, /dev/rCONTROLFILE_03
  db_block_size            = 8192
  db_cache_size            = 1577058304
  compatible               = 9.2.0.0.0
  log_archive_start        = TRUE
  log_archive_dest_1       = LOCATION=/arch1
  log_archive_dest_2       = LOCATION=/arch2
  log_archive_format       = %t_%s.dbf
  db_file_multiblock_read_count= 16
  cluster_database         = TRUE
  cluster_database_instances= 2
  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            = pro1
  dispatchers              = (PROTOCOL=TCP) (SERVICE=proXDB)
  remote_listener          = LISTENERS_PRO
  hash_join_enabled        = TRUE
  background_dump_dest     = /oracle/admin/pro/bdump
  user_dump_dest           = /oracle/admin/pro/udump
  core_dump_dest           = /oracle/admin/pro/cdump
  sort_area_size           = 524288
  db_name                  = pro
  open_cursors             = 300
  star_transformation_enabled= FALSE
  query_rewrite_enabled    = FALSE
  pga_aggregate_target     = 25165824
Mon Nov 21 15:41:29 2005
Errors in file /oracle/admin/pro/udump/pro1_ora_59412.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-27504: IPC error creating OSD context
ORA-27300: OS system dependent operation:if_not_found failed with status: 0
ORA-27301: OS failure message: Error 0
ORA-27302: failure occurred at: skgxpvaddr9
Mon Nov 21 15:41:49 2005
Errors in file /oracle/admin/pro/udump/pro1_ora_99478.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-27504: IPC error creating OSD context
ORA-27300: OS system dependent operation:if_not_found failed with status: 0
ORA-27301: OS failure message: Error 0
ORA-27302: failure occurred at: skgxpvaddr9
Mon Nov 21 15:42:02 2005
Errors in file /oracle/admin/pro/udump/pro1_ora_99480.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-27504: IPC error creating OSD context
ORA-27300: OS system dependent operation:if_not_found failed with status: 0
ORA-27301: OS failure message: Error 0
ORA-27302: failure occurred at: skgxpvaddr9
Shutting down instance (abort)
License high water mark = 0
Instance terminated by USER, pid = 84338
Mon Nov 21 16:26:03 2005
Starting ORACLE instance (normal)
Mon Nov 21 16:26:03 2005
Global Enqueue Service Resources = 4086, pool = 4
Mon Nov 21 16:26:03 2005
Global Enqueue Service Enqueues = 5947
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
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.6.0.
System parameters with non-default values:
  processes                = 150
  timed_statistics         = TRUE
  shared_pool_size         = 536870912
  large_pool_size          = 16777216
  java_pool_size           = 117440512
  spfile                   = /dev/rSPFILE
  cluster_interconnects    = 168.33.115.246
  control_files            = /dev/rCONTROLFILE_01, /dev/rCONTROLFILE_02, /dev/rCONTROLFILE_03
  db_block_size            = 8192
  db_cache_size            = 1577058304
  compatible               = 9.2.0.0.0
  log_archive_start        = TRUE
  log_archive_dest_1       = LOCATION=/arch1
  log_archive_dest_2       = LOCATION=/arch2
  log_archive_format       = %t_%s.dbf
  db_file_multiblock_read_count= 16
  cluster_database         = TRUE
  cluster_database_instances= 2
  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            = pro1
  dispatchers              = (PROTOCOL=TCP) (SERVICE=proXDB)
  remote_listener          = LISTENERS_PRO
  hash_join_enabled        = TRUE
  background_dump_dest     = /oracle/admin/pro/bdump
  user_dump_dest           = /oracle/admin/pro/udump
  core_dump_dest           = /oracle/admin/pro/cdump
  sort_area_size           = 524288
  db_name                  = pro
  open_cursors             = 300
  star_transformation_enabled= FALSE
  query_rewrite_enabled    = FALSE
  pga_aggregate_target     = 25165824
Mon Nov 21 16:26:05 2005
Errors in file /oracle/admin/pro/udump/pro1_ora_99518.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-27504: IPC error creating OSD context
ORA-27300: OS system dependent operation:if_not_found failed with status: 0
ORA-27301: OS failure message: Error 0
ORA-27302: failure occurred at: skgxpvaddr9

ecwwf

原帖由 blue_stone 于 2005-11-21 18:38 发表
cluster_server参数应该设置为false楼主设置了么？

cluster_server 是不是ORACLE参数？我的实例没有启，能不能设。应怎么设。
不懂这个参数。请告知，ths。

blue_stone

使用spfile的情况 保证hacmp在2台机器上运行，确保当前数据库9204正常运行 关闭所有实例 启动某一实例到nomount状态 使用alter system set  cluster_database=false scope=spfile  关闭该实例 开始升级