How can I find the last Oracle CPU installed?
I thought I had installed a newer CPU in my test Oracle home that what was in my production home, but I really couldn't remember. I needed to find what CPUs were installed in each so I could get them back in synch.
There are two ways to accomplish this. You can query dba_registry_history which would yield the following output:
select action_time, id, comments from dba_registry_history;
This was unreliable in my case though, because I had cloned over my test instance from my production bringing the CPU data from that instance.
The second and more reliable method is to grep Opatch for the patch number of the CPU.
If you get a hit, that's the latest CPU installed.
There are two ways to accomplish this. You can query dba_registry_history which would yield the following output:
select action_time, id, comments from dba_registry_history;
ACTION_TIME ID COMMENTS
25-JUL-08 08.15.19.596514000 PM 6646853 CPUJan2008
This was unreliable in my case though, because I had cloned over my test instance from my production bringing the CPU data from that instance.
The second and more reliable method is to grep Opatch for the patch number of the CPU.
opatch lsinventory | grep 6646853
If you get a hit, that's the latest CPU installed.
Comments