Database Administration (MOSC)

MOSC Banner

disconnect when compile Stored procedure

edited Sep 13, 2013 6:30AM in Database Administration (MOSC) 3 commentsAnswered
Facts: ORacle 10.2.0.4 on Linux OL 5u9.after impdp, compile of any Stored procedure which contains refference to MSSql DB against Oracle Transparent gateway and DB link, disconnect current SQLPLUS (or TOAD) session and failed with error:
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 0
Session ID: 743 Serial number: 213

This is piece from EVENT 10053 trace file:
...
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x0, PC: [0x218b4a1, hokx_coerce()+93]
    519 *** 2013-09-13 14:55:41.839
    520 ksedmp: internal or fatal error
    521 ORA-07445: exception encountered: core dump [hokx_coerce()+93] [SIGSEGV] [Address not mapped to object] [0x000000000] [] []
...

On OEL 5U2 that was not happened.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center