免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 2080 | 回复: 1
打印 上一主题 下一主题

关于ORACLE 92 RAC ON AIX 上的ORA-01033 [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2005-05-15 14:20 |只看该作者 |倒序浏览
ORACLE 92 RAC ON AIX 一个服务器上启动正常;
但另一台服务启动后HACMP.out中正常,使用SQLPLUS登陆报ORA-01033错;
但是如果先shutdown;提示ORA-01507: database not mounted;在startup报错ORA-03113: ORA-03113: end-of-file on communication channel

错误现象如下:
# su - oracle
% sqlplus

SQL*Plus: Release 9.2.0.5.0 - Production on Sun May 15 08

Copyright (c) 1982, 2002, Oracle Corporation.  All rights

Enter user-name: test
Enter password:
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress

SQL>; conn /as sysdba
Connected.
SQL>; shutdown immediate
ORA-01507: database not mounted


ORACLE instance shut down.
SQL>; startup
ORACLE instance started.

Total System Global Area 2618790648 bytes
Fixed Size                   746232 bytes
Variable Size            1560281088 bytes
Database Buffers         1056964608 bytes
Redo Buffers                 798720 bytes
ORA-03113: end-of-file on communication channel


SQL>;

ALERT_XXXX.log如下:
Sun May 15 08:37:52 2005
cluster interconnect IPC version:Oracle UDP/IP
IPC Vendor 1 proto 2 Version 1.0
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 1
Sun May 15 08:37:52 2005
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Sun May 15 08:42:30 2005
Starting ORACLE instance (normal)
Sun May 15 08:42:30 2005
Global Enqueue Service Resources = 4086, pool = 4
Sun May 15 08:42:30 2005
Global Enqueue Service Enqueues = 5947
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
GES IPC: Receivers 3  Senders 3
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         = 1157627904
  large_pool_size          = 16777216
  java_pool_size           = 318767104
  spfile                   = /dev/rlvora9_spfile
  control_files            = /dev/rlvcontrol1_150, /dev/rlvcontrol2_150, /dev/rlvcontrol3_150
  db_block_size            = 8192
  db_cache_size            = 1056964608
  compatible               = 9.2.0.0.0
  log_archive_start        = TRUE
  log_archive_dest_1       = LOCATION=/ora91log
  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            = ora91
  hash_join_enabled        = TRUE
  background_dump_dest     = /opt/oracle/admin/ora9/bdump
  user_dump_dest           = /opt/oracle/admin/ora9/udump
  core_dump_dest           = /opt/oracle/admin/ora9/cdump
  sort_area_size           = 524288
  db_name                  = ora9
  open_cursors             = 300
  star_transformation_enabled= FALSE
  query_rewrite_enabled    = FALSE
  pga_aggregate_target     = 52428800
Sun May 15 08:42:31 2005
Errors in file /opt/oracle/admin/ora9/udump/ora91_ora_17384.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
Sun May 15 08:50:24 2005
cluster interconnect IPC version:Oracle UDP/IP
IPC Vendor 1 proto 2 Version 1.0

论坛徽章:
0
2 [报告]
发表于 2005-05-15 15:21 |只看该作者

关于ORACLE 92 RAC ON AIX 上的ORA-01033

如果把双机中的另一服务器停掉;
这台服务器smit clstart启动后使用SQLPLUS登陆仍报ORA-01033错;
但是如果先shutdown;提示ORA-01507: database not mounted;再startup启动正常
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP