环境 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/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7199859/viewspace-2123536/