Chinaunix

标题: rac 9204up9206问题 [打印本页]

作者: ecwwf 时间: 2005-11-21 16:39
标题: rac 9204up9206问题
在两台AIX52ML06+9204的机器做UP9206
文件是升级上了,但是发现在升级数据库时做
startup migrate时报
SQL> startup migrate
ORA-00603: ORACLE server session terminated by fatal error
why?

作者: rollingpig 时间: 2005-11-21 17:06
看看alertlog

作者: blue_stone 时间: 2005-11-21 18:38
cluster_server参数应该设置为false楼主设置了么？

作者: ecwwf 时间: 2005-11-21 19:16
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 时间: 2005-11-21 19:19

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

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

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

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