aix下的oracle oracle 10g rac報ora-04030錯誤

fanhongjie發表於2010-09-20

oracle使用者登入,檢視ulimit ,ulimit -a
將oracle下的記憶體限制調整為unlimited,編輯/etc/security/limits,
rss = -1
rss_hard = -1

[@more@]

重新啟動伺服器,發現問題依舊,oracle使用者登入,$ ps -ef|grep LISTEN
oracle 495978 1 0 09:48:39 - 0:00 /oracle/product/10.2/bin/tnslsnr LISTENER_NOAP1 -inherit
oracle 532876 688514 0 09:48:56 pts/0 0:00 grep LISTEN
$ ps v 495978
PID TTY STAT TIME PGIN SIZE RSS LIM TSIZ TRS %CPU %MEM COMMAND
495978 - A 0:00 0 10384 13612 32768 14856 3228 0.0 0.0 /oracle/

LIM
32768
檢視監聽程式,發現lim沒起作用
於是我用lsnrctl 命令重啟rac的監聽,居然好了
$ ps -ef|grep LISTEN
oracle 303522 688514 0 10:08:09 pts/0 0:00 grep LISTEN
oracle 495984 1 0 10:07:51 pts/0 0:00 /oracle/product/10.2/bin/tnslsnr LISTENER_NOAP1 -inherit
$ ps v 495984
PID TTY STAT TIME PGIN SIZE RSS LIM TSIZ TRS %CPU %MEM COMMAND
495984 pts/0 A 0:00 0 10596 13824 xx 14856 3228 0.0 0.0 /oracle/

然後執行語句不報錯了,反覆試了,感覺是起作用了。

但現在的問題是,
我用crs_stop ,crs_start起監聽,就又變回去了,
LIM 又是32768 ,執行語句又報錯了
用srvctl命令也是

檢視metalink文章
SOME Client Connection FAIL WITH ORA-4030 ERROR when connecting using RAC [ID 758131.1]

在root下使用
crsctl stop crs
crsctl start crs
再用crs_stop,crs_start起來就沒問題了

$ crs_stop ora.noap1.LISTENER_NOAP1.lsnr
Attempting to stop `ora.noap1.LISTENER_NOAP1.lsnr` on member `noap1`
Stop of `ora.noap1.LISTENER_NOAP1.lsnr` on member `noap1` succeeded.
$ crs_start ora.noap1.LISTENER_NOAP1.lsnr
Attempting to start `ora.noap1.LISTENER_NOAP1.lsnr` on member `noap1`
Start of `ora.noap1.LISTENER_NOAP1.lsnr` on member `noap1` succeeded.
$ ps -ef|grep LISTEN
oracle 520372 688514 0 10:30:42 pts/0 0:00 grep LISTEN
oracle 680268 1 0 10:30:30 - 0:00 /oracle/product/10.2/bin/tnslsnr LISTENER_NOAP1 -inherit
$ ps v 680268
PID TTY STAT TIME PGIN SIZE RSS LIM TSIZ TRS %CPU %MEM COMMAND
680268 - A 0:00 0 10380 13608 xx 14856 3228 0.0 0.0 /oracle/

有一點小問題,就是我前面重啟過系統了,怎麼沒起作用,還得手動起一下crs.

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

相關文章