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

paulyibinyi發表於2016-08-03
Oracle
     環境:  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建庫就正常執行了。

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/7199859/viewspace-2122938/，如需轉載，請註明出處，否則將追究法律責任。

相關文章