checking patches

[dbasan]

Can we check which patches have been applied to the database successfully?

1) at the db level
2) at the o/s level

Have a good day!

[shirazmustafa]

Dear,

If ur operating system is one of the unix flavours then u can go for he below command to find out the patches applied to the opertaing system:

> /usr/sbin/swlist -l patch

[julian]

For patchsets, check:

select * from v$version;

For one time patches, it is not that simple.

[dbasan]

At the os level should i need to install the swlist as it is not listed in my /usr/sbin dir (solaris 5.6).

At the db level apart from the v$version is there any FND_ tables to check?

[marist89]

Oracle has a tool called patchset_tool that looks at the version of all the modules you have installed.