aix下的oracle oracle 10g rac報ora-04030錯誤
oracle使用者登入,檢視ulimit ,ulimit -a
將oracle下的記憶體限制調整為unlimited,編輯/etc/security/limits,
rss = -1
rss_hard = -1
重新啟動伺服器,發現問題依舊,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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- AIX 5.3 Install Oracle 10g RAC 錯誤集錦AIOracle 10g
- Oracle 11.2.0.3 Database for AIX bug導致ORA-04030的報錯OracleDatabaseAI
- oracle 10g rac安裝報錯Oracle 10g
- [排錯]安裝Oracle 10g RAC報Failure at final check of Oracle CRS stack 10錯誤Oracle 10gAI
- AIX上配置ORACLE 10g RAC EMAIOracle 10g
- oracle 10g rac +aix 6.1+hacmp 5.5 建庫出現ORA-600錯誤Oracle 10gAIACM
- oracle 10g r2 ASM RAC on aixOracle 10gASMAI
- win7 32位下裝oracle 10g報未知錯誤Win7Oracle 10g
- oracle 10G rac 執行dbca 報錯處理方法Oracle 10g
- Oracle11.1.0.7版本的ASSM與ORA-04030錯誤OracleSSM
- AIX 5.3/6.1環境下安裝Oracle 10gR2 RAC常見報錯AIOracle 10g
- oracle RAC RDS on AIXOracleAI
- aix6安裝oracle 10g rac問題AIOracle 10g
- AIX6.1下 Oracle 10g的安裝AIOracle 10g
- IBM aix下oracle 9.2.0.5 rac 升級到oracle 9.2.0.8IBMAIOracle
- 【RAC】AIX6.1下Oracle 10g RAC(10.2.0.1)下ORA-12518的解決步驟AIOracle 10g
- 轉載:[轉]AIX 平臺下Oracle 10g RAC 是否需要安裝 HACMP .AIOracle 10gACM
- Linux 下Oracle 10G RAC 管理LinuxOracle 10g
- oracle rac aix 安裝OracleAI
- aix 6.1+hacmp+ oracle 10g rac 安裝步驟AIACMOracle 10g
- oracle 10g rac 客戶端連線偶爾報ORA-12535錯誤Oracle 10g客戶端
- oracle 報大小寫錯誤Oracle
- aix 6 oracle power 64 impdp 11.2.0.2 ORA-04030AIOracle
- 【RAC安裝】 AIX下安裝Oracle 11gR2 RACAIOracle
- 在aix oracle rac 環境下,增加lv的步驟AIOracle
- 10g RAC on AIXAI
- AIX上安裝、升級Oracle 10g RAC的情況總結AIOracle 10g
- ora-01732錯誤 for ORACLE 10GOracle 10g
- oracle 10g 在AIX5.3 dbca建庫 報錯 ORA-12547Oracle 10gAI
- Oracle Enterprise Linux 5.6下安裝Oracle 10g RAC執行root.sh報錯問題解決LinuxOracle 10g
- Oracle 10g RAC NFSOracle 10gNFS
- Oracle 10g RAC TAFOracle 10g
- ORA-27300: ORA-04030: 等錯誤,這是要命的Oracle bugOracle
- AIX系統儲存故障後的Oracle 10g RAC恢復過程AIOracle 10g
- Oracle 10g RAC中的DRMOracle 10g
- Oracle RAC 錯誤記錄以及處理方法Oracle
- Oracle 10g RAC下Voting disk和OCR的管理Oracle 10g
- Oracle 10G RAC下OCR和Voting disk的管理Oracle 10g