Applies to:
Oracle Server - Enterprise Edition - Version: 9.2.0.6.0
AIX5L Based Systems (64-bit)
Symptoms
You had installed 9206 on both server(PROD & DEV)
But while startingup instance on PROD server, you are getting following error messages in alert-log file
ORA-00603: ORACLE server session terminated by fatal error
ORA-27504: IPC error creating OSD context
ORA-27300: OS system dependent operation:sendmsg failed with status: 59
ORA-27301: OS failure message: Message too long
ORA-27302: failure occurred at: sskgxpsnd1
However in DEV box, after aplying 9206 patch , the databased started without any error
The only difference between these 2 servers is :-
PROD is in HA (Operating System - Not Oracle) with another server and DEV is stand alone box.
Command : /usr/sbin/no -a returns
PROD BOX
tcp_sendspace = 656536
tcp_recvspace = 656536
udp_sendspace = 18432
udp_recvspace = 184320
rfc1323 = 1
DEV BOXtcp_sendspace = 656536
tcp_recvspace = 656536
udp_sendspace = 18432
udp_recvspace = 184320
rfc1323 = 1
As per unpublished Bug 3400991 , tcp_recvspace & and tcp_sendspace should more than 64K. You have the tcp_recvspace & and tcp_sendspace set as per recommendation.
Recommended output for Command: no -a/usr/sbin/no -o tcp_sendspace=65536
/usr/sbin/no -o tcp_recvspace=65536
/usr/sbin/no -o udp_sendspace=65536
/usr/sbin/no -o udp_recvspace=655360
/usr/sbin/no -o rfc1323=1
Cause
It appears that oracle has been relinked with rac_on option because the installer may have detected
HA installed/configured in OS level in PROD SERVER (even though you did not choose to install RAC).
The cause of this problem has been identified in Bug 4169530
Solution
To implement the solution, please execute the following steps:
1. Check whether RAC is enabled for your installation.
If Oracle9i linked with RAC,
ar -X32_64 -vt $ORACLE_HOME/rdbms/lib/libknlopt.a | grep kcsm
If Oracle9i linked without RAC :
ar -X32_64 -vt $ORACLE_HOME/rdbms/lib/libknlopt.a | grep ksnkcs
2. The result of the above command if RAC enabled is
$ ar -X32_64 -vt $ORACLE_HOME/rdbms/lib/libknlopt.a | grep kcsm
rw-rw-r-- 201/203 2280 Oct 26 13:54 2004 kcsm.o
3. If you get the same result as in above step then relink Oracle without RAC
$ make -f ins_rdbms.mk rac_off
$ make -f ins_rdbms.mk ioracle