ORA-27300 OS system dependent operation:if_not_found 問題處理

paulyibinyi發表於2016-08-16
環境 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圖形建庫和手工建庫都可以了。




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

相關文章