ORA-27300: OS system dependent operation:bind failed with status: 227

[skt_skt]

HP-UX 11.23
MCSG 11.18(RAC)
oracle 9.2.0.5

Tue Oct 28 13:17:39 2008
Errors in file /eb_rdo0_p/oraadmin/p599/udump/p599c_ora_17764.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-27504: IPC error creating OSD context
ORA-27300: OS system dependent operation:bind failed with status: 227
ORA-27301: OS failure message: Can't assign requested address
ORA-27302: failure occurred at: sskgxpcre3

any one familiar with this error?

[Wouter Jagers]

This page contains a metalink conversation with Oracle about this error: http://cyr1974.itpub.net/post/2066/15590

It mentions that increasing shmmax has helped in at least one occasion.

Cheers,
Wout

[Steven E. Protter]

Shalom,

it looks like your oracle server needs to do a name lookup and its failing.

Its definitely OS related and thats what the message indicates.

see that /etc/resolv.conf bind servers actually work and see if the problem goes away.

SEP

[skt_skt]

We have around 15000 UDP connections right now.
root [/var/adm] netstat -an|grep -i udp|wc -l
14756

We have a limit of 16383 connections

root [/var/adm] ndd -get /dev/udp udp_largest_anon_port
65535
root [/var/adm] ndd -get /dev/udp udp_smallest_anon_port
49152

udp_smallest_anon_port can be changed online to accomadate more sessions. It is very likely that we reached that limit at that point it time.


from lsof i can see that most of my UDP sessions are in Idle status

COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
oracle 100 oracle 9u IPv4 0x3e74f3580 0t0 UDP aded189p_clic1.x.y.com:50623 (Idle)
oracle 100 oracle 12u IPv4 0x3e22a4900 0t0 UDP aded189p_clic0.x.y.com:50624 (Idle)

Any one has any idea these sessions are lying in Idle status (Why these UDP sessions are getting not cleared after
the sessions dropped; we are not expecting to have 15000 real form sessions from Oracle)