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!
Printable View
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!
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
For patchsets, check:
select * from v$version;
For one time patches, it is not that simple.
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?
Oracle has a tool called patchset_tool that looks at the version of all the modules you have installed.