ORA-27300 OS system dependent operation:if_not_found 問題處理
環境 oracle 9.2.0.7 rac + aix
安裝完oracle 9i rac 在aix平臺上後,用dbca建庫或者手工建庫都報以下錯誤:
*** 2016-08-03 04:37:05.900
ksedmp: internal or fatal error
ORA-00603: ORACLE server session terminated by fatal error
ORA-27504: IPC error creating OSD context
ORA-27300: OS system dependent operation:if_not_found failed with status: 0
ORA-27301: OS failure message: Error 0
ORA-27302: failure occurred at: skgxpvaddr9
Current SQL information unavailable - no session.
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedmp+0148 bl ksedst 10293C4B4 ?
ksfdmp+0018 bl 01FBA748
kgefec+00d4 bl _ptrgl
ksxpsigosderr+007c bl kgefec 6B7000006B70 ? 000006AA4 ?
1101F7800 ? 06F745F66 ?
ksxpnfy+01c8 bl ksxpsigosderr 000000002 ? 110194F30 ?
kscnfy+0054 bl _ptrgl
ksmcpg+002c bl kscnfy FFFFFFFFFFFA450 ? 000000000 ?
ksucrp+00f8 bl ksmcpg
opistr+04e8 bl 01FBAA08
opiodr+08c8 bl _ptrgl
ttcpip+0c5c bl _ptrgl
opitsk+0c58 bl ttcpip 11000CDA8 ? 000000000 ?
000000000 ? 000000000 ?
000000000 ? 000000000 ?
解決方法: 因為是rac cluster_interconnects 引數不能為空
設定如下:
alter system set cluster_interconnects=192.168.4.1 sid='節點1';
alter system set cluster_interconnects=192.168.4.2 sid='節點2';
後面dbca圖形建庫和手工建庫都可以了。
安裝完oracle 9i rac 在aix平臺上後,用dbca建庫或者手工建庫都報以下錯誤:
*** 2016-08-03 04:37:05.900
ksedmp: internal or fatal error
ORA-00603: ORACLE server session terminated by fatal error
ORA-27504: IPC error creating OSD context
ORA-27300: OS system dependent operation:if_not_found failed with status: 0
ORA-27301: OS failure message: Error 0
ORA-27302: failure occurred at: skgxpvaddr9
Current SQL information unavailable - no session.
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedmp+0148 bl ksedst 10293C4B4 ?
ksfdmp+0018 bl 01FBA748
kgefec+00d4 bl _ptrgl
ksxpsigosderr+007c bl kgefec 6B7000006B70 ? 000006AA4 ?
1101F7800 ? 06F745F66 ?
ksxpnfy+01c8 bl ksxpsigosderr 000000002 ? 110194F30 ?
kscnfy+0054 bl _ptrgl
ksmcpg+002c bl kscnfy FFFFFFFFFFFA450 ? 000000000 ?
ksucrp+00f8 bl ksmcpg
opistr+04e8 bl 01FBAA08
opiodr+08c8 bl _ptrgl
ttcpip+0c5c bl _ptrgl
opitsk+0c58 bl ttcpip 11000CDA8 ? 000000000 ?
000000000 ? 000000000 ?
000000000 ? 000000000 ?
解決方法: 因為是rac cluster_interconnects 引數不能為空
設定如下:
alter system set cluster_interconnects=192.168.4.1 sid='節點1';
alter system set cluster_interconnects=192.168.4.2 sid='節點2';
後面dbca圖形建庫和手工建庫都可以了。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7199859/viewspace-2123536/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-27300: OS system dependent operation:fork failed with statusAI
- ORA-27300: OS system dependent operation: CreateThread failedthreadAI
- ORA-27300: OS system dependent operation:fork failed with status: 12AI
- ORA-27300: OS system dependent operation:fork failed with status: 11AI
- ORA-27300: OS system dependent operation:semget failed with status: 28 - 2AI
- ORA-27300: OS system dependent operation:semget failed with status: 28 - 1AI
- -bash: ulimit: max user processes: cannot modify limit: Operation not permitted問題的處理MIT
- oracle 9i dbca Ora-00603, ORA-27300 問題處理Oracle
- ORA-27300 ORA-27301 ORA-27302問題處理
- ORA-27300 錯誤處理
- 【問題處理】Oracle process running out of OS kernel I/O resourcesOracle
- 解決STS或者Eclipse卡死在remote system explorer operation問題EclipseREM
- 3.4.3 Restoring the System to Normal OperationRESTORM
- POJ 2443Set Operation(好題! 每32位壓縮處理)
- 處理問題的方法
- perl中文處理問題
- 漢字處理問題?
- xml處理的問題XML
- 貨品問題處理
- [git] git問題處理Git
- Too many open files in system處理
- golang json處理問題GolangJSON
- 併發問題處理方式
- ASMCMD處理問題一則ASM
- mysql的處理能力問題MySql
- RMAN處理split block問題BloC
- mysql問題處理兩則MySql
- Oracle啟動問題處理Oracle
- mysql 問題處理二則MySql
- Oracle壞塊問題處理Oracle
- 資料處理--pandas問題
- python os.systemPython
- 如何處理 No DMARC Record Found 問題
- PHP 開發版本問題處理PHP
- MySQL:亂碼問題處理流程MySql
- JVM問題分析處理手冊JVM
- Linux 問題處理集錦Linux
- 處理SQLServer errorlog滿問題SQLServerError