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/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/14661773/viewspace-705349/