patch 7197489 results in invalid DMBS_PROFILER and AD_DBMS_METADATA packages
I'm applying patch 7197489 on 10.2.0.4 as a pre-installation task for R12 ugprade. While running adgrants.sql, it results in invalid DMBS_PROFILER and AD_DBMS_METADATA packages.
step 1: run adgncons.sql (successful)
step 2: run adcrtbsp.sql (successful)
step 3: run adgrants.sql (errors below)
SQL> @adgrants.sql
Connected.
---------------------------------------------------
--- adgrants.sql started at 2012-07-18 09:04:56 ---
Creating PL/SQL profiler objects.
---------------------------------------------------
--- profload.sql started at 2012-07-18 09:04:56 ---
Warning: Package created with compilation errors.
Grant succeeded.
Synonym created.
Library created.
Warning: Package Body created with compilation errors.
Testing for correct installation
PACKAGE sys.DBMS_PROFILER - missing or invalid