|
| 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]
|
