Re: Find out from database which PSU applied to oracle_home

From: Yechiel Adar <adar666_at_inter.net.il>
Date: Fri, 12 Mar 2010 10:09:40 +0200
Message-id: <4B99F6C4.8070307_at_inter.net.il>

Yesterday I create new 11.1.0.7 database. I checked now and the table is empty.

One way I see, is running opatch lsinventory, after database creation, and load the output into a table.
Then merge the results from registry$history and your table to get the complete picture.

Another way is to create a directories that points to the install logs and opatch log
and read and analyze all logs created before 'select creation_date from v$database'.

Adar Yechiel
Rechovot, Israel

Jack van Zanen wrote:
> This section excludes the databases that were created from scratch
>

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Mar 12 2010 - 02:09:40 CST