My Oracle Support Banner

Is it required to re-install the UTL_* packages after an upgrade to 11.2 ? (Doc ID 1313429.1)

Last updated on APRIL 03, 2020

Applies to:

Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version to [Release 11.2]
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.


The Oracle Database Upgrade Guide suggests that the following packages need to be reloaded:

Oracle® Database Upgrade Guide
11g Release 2 (11.2)
Part Number E17222-06

Chapter 3 Upgrading to the New Release


System Considerations and Requirements

Upgrading Packages That Are Not Installed by Default
Packages that were previously installed on the database for which you are preparing to upgrade to the current release may not be upgraded automatically. You may need to separately check if the package is available in the current release and reinstall that package to ensure you have the latest version.


Access Control Lists (ACLs) and Network Utility Packages


If Oracle XML DB is installed on the database to be upgraded, and therefore one or all of the UTL_TCP, UTL_SMTP, UTL_MAIL, UTL_HTTP, and UTL_INADDR packages are installed, then you may need to re-install these packages after performing the upgrade to ensure that you have the latest version of these packages for the new release.



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.