Find out from database which PSU applied to oracle_home
- From: Jack van Zanen <jack@xxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 11 Mar 2010 16:20:06 +1100
Hi All,
According to the instructions there is no need to run the sql in the
database if it is created from scratch after the PSU has been applied
to an oracle_home.
This also means the registry$history does not get any entries to see
which PSU has been applied.
Short of comparing db creation date and PSU patch date is there a
query I can execute in the database that will give me the PSU level
applied to the home from which the database was created?
<<<<<<<<<<<<<<<<<<<<<<<<
2.3.4 Post Installation Instructions for Databases Created or Upgraded
after Installation of PSU 10.2.0.4.3 in the Oracle Home
These instructions are for both non-RAC environments and RAC
environments when a database is created or upgraded after the
installation of PSU 10.2.0.4.3.
You must execute the steps in Section 2.3.3.1, "Loading Modified .sql
Files into the Database"" and Section 2.3.3.2, "Recompiling Views in
the Database" for any new database only if it was created by any of
the following methods:
Using DBCA (Database Configuration Assistant) to select a sample
database (General, Data Warehouse, Transaction Processing)
Using a script that was created by DBCA that creates a database from a
sample database
Cloning a database that was created by either of the two preceding
methods, and if Section 2.3.3.1, "Loading Modified .sql Files into the
Database" and Section 2.3.3.2, "Recompiling Views in the Database"
were not executed after PSU 10.2.0.4.3 was applied
Upgraded databases require that you perform the steps in Section
2.3.3.2, "Recompiling Views in the Database" if these steps have not
previously been performed; otherwise, no post-installation steps need
to be performed.
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
Jack van Zanen
-------------------------
This e-mail and any attachments may contain confidential material for
the sole use of the intended recipient. If you are not the intended
recipient, please be aware that any disclosure, copying, distribution
or use of this e-mail or any attachment is prohibited. If you have
received this e-mail in error, please contact the sender and delete
all copies.
Thank you for your cooperation
--
//www.freelists.org/webpage/oracle-l
Other related posts:
