ORA-00603 ORA-27504 ORA-27300 ORA-27504 in the Alert Log [ID 364353.1]

最新推荐文章于 2025-02-10 15:14:01 发布

原创最新推荐文章于 2025-02-10 15:14:01 发布 · 339 阅读

CC 4.0 BY-SA版权

本文描述了Oracle数据库在HP-UX Itanium系统上出现ORA-00603, ORA-27504等错误导致实例崩溃的问题。这些错误通常与远程节点通信时发生套接字失败有关。解决方案包括提高MAX_ASYNC_PORTS参数值和停用操作系统的异步I/O。

In this Document
Symptoms
Cause
Solution

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.4 and later [Release: 10.1 and later ]
HP-UX Itanium

Symptoms

The following messages in the alert log file and thereafter the instance crashed.

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: 11
ORA-27301: OS failure message: Resource temporarily unavailable
ORA-27302: failure occurred at: sskgxpcre1

Cause

This error means that there was an socket failure happened at the OS level while we try to communicate with
the remote node.

This issue can be caused if the MAX_ASYNC_PORTS has low value as it required to create a socket for a
useof the private interconnect when required.

MAX_ASYNC_PORTS specifies the system-wide maximum number of ports to the asynchronous disk I/O driver
that processes can have open at any given time. The default value for this parameter is 50.

http://docs.hp.com/en/939/KCParms/KCparam.MaxAsyncPorts.html