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
- 10g RAC on AIXAI
- AIX 5.3/6.1環境下安裝Oracle 10gR2 RAC常見報錯AIOracle 10g
- Oracle 10g RAC故障處理Oracle 10g
- oracle 報大小寫錯誤Oracle
- oracle aix平臺19c rac互信不通案例OracleAI
- ORACLE 錯誤Oracle
- Oracle 10g RAC 資料儲存更換Oracle 10g
- windows下oracle的ora-27100錯誤WindowsOracle
- Oracle 10g 下載地址Oracle 10g
- oracle 19c rac打補丁常見錯誤Oracle
- oracle RAC dbca的時候報錯提示cluster nodes are not accessibleOracle
- 【ASK_ORACLE】Oracle RAC報錯“ipc send timeout”的原因以及解決辦法Oracle
- Oracle告警日誌ora-04030Oracle
- oracle rac dg庫報錯ORA-01031: insufficient privilegesOracle
- oracle資料庫跨平臺(AIX)從RAC恢復至(linux)下的單例項Oracle資料庫AILinux單例
- 【ASK_ORACLE】安裝Oracle RAC 12.2的GI軟體時報錯CLSRSC-614Oracle
- 【ASM】Oracle RAC css啟動報錯"Duplicate voting file found"ASMOracleCSS
- oracle RACOracle
- Oracle RAC Cache Fusion 系列十七:Oracle RAC DRMOracle
- Oracle RAC 環境下的連線管理Oracle
- Oracle RAC CacheFusion 系列十五:Oracle RAC CRServer Part TwoOracleServer
- Oracle nvarchar2錯誤Oracle
- 【ASK_ORACLE】Oracle 19c RAC使用opatchauto安裝補丁報錯OPATCHAUTO-72083Oracle
- oracle xtts遷移 AIX to LinuxOracleTTSAILinux
- ORACLE RAC clusterwareOracle
- oracle dg報錯Oracle
- Oracle RAC Cache Fusion系列十八:Oracle RAC Statisticsand Wait EventsOracleAI
- Solaris下Oracle RAC 11.2.0.4 安裝方法Oracle
- ORACLE匯入遇到ORACLE錯誤959解決方法Oracle
- Oracle 11.2 DataGuard RAC To RAC搭建Oracle
- oracle 10g flashback databaseOracle 10gDatabase
- ORACLE RAC中連線ScanIP報錯ORA-12545的問題解決Oracle
- Oracle RAC Cache Fusion 系列十四:Oracle RAC CR Server Part OneOracleServer
- Oracle RAC Cache Fusion 系列十:Oracle RAC Enqueues And Lock Part 1OracleENQ
- Oracle異常錯誤處理Oracle
- ORACLE 異常錯誤處理Oracle
- aix安裝oracle客戶端AIOracle客戶端
- Oracle RAC Wait EventsOracleAI