AIX系統中，啟動資料庫報錯ORA-27504

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/，如需轉載，請註明出處，否則將追究法律責任。