     環境: oracle 9.2.0.7+aix 5.3

     好久沒有安裝oracle 9i for aix 版本了，今天安裝好軟體後，用dbca建庫，

    報以下錯誤:

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

透過查metalink id號為295832.1
主要原因udp_recvspace和udp_sendspace 引數太小

The size of udp_recvspace and udp_sendspace should be larger than db_block_size

解決方法:

The buffer size should be greater or equal than db_block_size * db_file_multiblock_read_count

udp_sendspace = <DB_BLOCK_SIZE> X <db__file_multiblock_read_count>
udp_recvspace = Generally suggested to be 4 times the sendspace

Refer to Note 181489.1 for UDP parameters for each platform

# no -p -o tcp_sendspace=262144
# no -p -o tcp_recvspace=262144
# no -p -o udp_sendspace=65536
# no -p -o udp_recvspace=262144

-p引數，主要是防止OS重啟後，引數恢復預設值

UDP related OS parameters can be queried with the following command:
no -a --獲取當前設定值
Set the udp_sendspace and udp_recvspace to the OS maximum with:
no -o --修改當前值

做了上面調整後，dbca建庫就正常執行了。

oracle 9i dbca Ora-00603, ORA-27300 問題處理

相關文章