ora-600 during compile - 1 node only

[gopi]

Hello,
We are running 2 node RAC 9.2.0.4 on HP-UX. When we compile (F8) any and all stored procedures on node 1 we get an ora-600 [17113]. The 17113 argument means some kind of memory problem with 3rd party vendor.

Node 2 compiles just fine the same procedures that were attempted on node1 - no problems what-so-ever.

Compiling using SQL*Plus on both nodes compiles without any issues as well.

Any experience with this ? Please advise.

Thank you,
Frank

 

[Marco Kalter]

If a compilation causes such an error and works correctly in SQL*Plus, then I suspect a problem with the "debug information" mode. To verify this, go to Tools > Preferences > Debugger tab page, disable the "Add debug information when compiling" option, and retry the compilation.