SYS-Owned Stored Procedures From Application Server / OID 10g 10.1.2.3 PatchSet Cannot be Compiled
(Doc ID 579835.1)
Last updated on MARCH 06, 2023
Applies to:
Oracle Internet Directory - Version 10.1.2.3 and later Information in this document applies to any platform.
Symptoms
Applying 10.1.2.3 Application Server patchset (<Bug 5983622>)
After patch install, there are some stored procedures that can't be compiled. These stored procedures are installed twice, owned by SYS and ODS.
It is the SYS version that cannot compile, because it can't see ODS tables/objects without synonyms and grants
The upgrade runs oidiptch.sql, which calls oidi10121.sql, oidi10122.sql, and oidi10123.sql, per $ORACLE_HOME/infra/ldap/admin/LOGS/ldappatch.log. But oidi10121.sql does not set the current user to ODS, so lots of statements fail, and objects are then incorrectly created under SYS schema
<Bug 5890157>, which is supposed to be fixed in 10.1.2.3 (see <Document 557102.1>), does not appear to be fixed. Code (oidmetricinfo) fixed under "SYS" user, operational code in ODS still has timestamp of YYYYMMDDHHMMSS (month in minutes field). SYS version of oidmetricinfo has correct timestamp of YYYYMMDDHHMISS, but is not being called, nor will it compile as its owned by SYS
Cause
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!