Oracle-L: 9iRelease2 Upgrade Alert -- PLSQL objects referencing 8i database

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Wed, 12 Jun 2002 08:17:40 -0800
Message-ID: <F001.0047BFE1.20020612081740@fatcity.com>

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]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hemant K Chitale
  INET: hkchital_at_singnet.com.sg

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Wed Jun 12 2002 - 11:17:40 CDT