Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

Oracle patch version

edited Aug 20, 2021 10:11AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 3 commentsAnswered

Hi,

Could you please tell me how to find latest patch installed on Oracle 9i and lower versions? I am able to find this information for 10g and higher version using below SQL query, but I want to find same information for Oracle 9i and lower versions?

SELECT TO_CHAR(action_time, 'DD-MON-YYYY HH24:MI:SS') AS action_time,
       action,
       namespace,
       version,
       id,
       comments,
       bundle_series
FROM   sys.registry$history
ORDER by action_time;

Regards,

Bala

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center