9iRelease 2 Upgrade Alert -- PLSQL Objects referencing 8iDatabase over DBLink

From: Hemant K Chitale <hkchital_nospam_at_singnet_nospam.com.sg>
Date: Wed, 12 Jun 2002 23:13:40 +0800
Message-ID: <ae7ogl$d0r$1@coco.singnet.com.sg>

Bookmark Fixed font Go to End

            Doc ID:  Note:189914.1
            Subject:  Recompilation of PLSQL may fail after Upgrading to
Oracle9i (ORA-3113 in UTLRP)
            Type:  UPGRADE NOTE
            Status:  PUBLISHED
     Content Type:  TEXT/PLAIN
            Creation Date:  16-MAY-2002
            Last Revision Date:  16-MAY-2002

UTLRP may dump if PLSQL references an Oracle8i Database [BUG:1978040]

Versions Affected

This problem affects Oracle versions 9.0.1.0 to 9.0.1.2 inclusive. The issue is fixed in 9.0.1.3 and Oracle9i Release 2 (9.2.0.1)

Platforms Affected

GENERIC - all platforms are affected

Description

Recompilation of PLSQL which references objects in remote Oracle8i (or earlier) databases via a DBLINK may result in the session crashing with ORA-7445 [kglobld] or ORA-3113 errors.

This can affects recompilation of PLSQL during upgrades to Oracle9i.

Likelihood of Occurrence

You can hit this problem if PLSQL contains SQL or constructs which use a database link to an Oracle8i (or earlier) database.

Possible Symptoms

This problem shows up as compilation of the PLSQL aborting with an ORA-3113 error reported to the client, and typically an ORA-7445 [kglobld] error in the trace file with the current SQL statement showing a reference to a remote database.

Workaround

One workaround is to upgrade the remote database to Oracle9i. If this is not possible then upgrade to 9.0.1.3 or higher where this issue is fixed.

Patches

This issue is fixed in the 9.0.1.3 (and higher) patch set.

References

  Base bug for this problem                     [BUG:1978040]

Received on Wed Jun 12 2002 - 10:13:40 CDT