ITPub博客

首页 > Linux操作系统 > Linux操作系统 > AIX系统中,启动数据库报错ORA-27504

AIX系统中,启动数据库报错ORA-27504

原创 Linux操作系统 作者:jasperjohn 时间:2011-08-19 13:40:46 0 删除 编辑

AIX系统中,启动数据库报错ORA-27504


告警日志中信息为:
Thu Aug 18 12:24:33 2011
Starting ORACLE instance (normal)
sskgpgetexecname failed to get name
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Interface type 1 en1 11.11.11.0 configured from OCR for use as a cluster interconnect
Interface type 1 en0 10.10.10.0 configured from OCR for use as  a public interface
Shared memory segment for instance monitoring created
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as /opt/oracle/product/10.2/db/dbs/arch
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
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.4.0.
System parameters with non-default values:
  processes                = 150
  sga_target               = 1191182336
  control_files            = /dev/rdb_control01, /dev/rdb_control02, /dev/rdb_control03
  db_block_size            = 8192
  compatible               = 10.2.0.3.0
  db_file_multiblock_read_count= 16
  cluster_database_instances= 1
  instance_number          = 1
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  remote_login_passwordfile= EXCLUSIVE
  db_domain                =
  dispatchers              = (PROTOCOL=TCP) (SERVICE=studyXDB)
  remote_listener          = LISTENERS_STUDY
  job_queue_processes      = 10
  background_dump_dest     = /opt/oracle/product/admin/study/bdump
  user_dump_dest           = /opt/oracle/product/admin/study/udump
  core_dump_dest           = /opt/oracle/product/admin/study/cdump
  audit_file_dest          = /opt/oracle/product/admin/study/adump
  db_name                  = study
  open_cursors             = 300
  pga_aggregate_target     = 392167424
USER: terminating instance due to error 27504
这个错误的描述为:
ORA-27504: IPC error creating OSD context
Cause: This is an operating system/cluster interconnect error.
Action: Check the value of errno and contact Oracle Support Services.
解决办法
从字面上看,似乎错误和CLUSTER有关,但是实际上是AIX上没有打开用户网络参数的限制。
执行下面的设置后,重新尝试启动数据库,问题消失:
/usr/sbin/no -o udp_sendspace=65536
/usr/sbin/no -o udp_recvspace=655360
/usr/sbin/no -o tcp_sendspace=65536
/usr/sbin/no -o tcp_recvspace=65536
/usr/sbin/no -o rfc1323=1
/usr/sbin/no -o sb_max=1310720
/usr/sbin/no -r -o ipqmaxlen=512
将这些修改添加到系统启动脚本中(#vi /etc/inittab),避免重启后出现同样的错误。

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/14661773/viewspace-705349/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2011-04-18

  • 博文量
    45
  • 访问量
    162371