Re: Find out from database which PSU applied to oracle_home
- From: lyallbarbour@xxxxxxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 11 Mar 2010 09:45:07 -0500
Which "instructions" are you referring to? in the README for 9119284 (PSU#3
patch for ORacle 10.2.0.4) after you run the opatch apply, the next thing is
Post Installation INstructions 2.3.3 In that you load modified .sql files into
the database. @catbundle.sql psu apply.
That's the process that puts the info into registry$history, right? Even in
the 2.3.4 of that readme, it says you must execute 2.3.3.1 steps... you have it
in your original email.
Lyall
-----Original Message-----
From: Jack van Zanen <jack@xxxxxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Sent: Thu, Mar 11, 2010 12:20 am
Subject: Find out from database which PSU applied to oracle_home
Hi All,
According to the instructions there is no need to run the sql in the
atabase if it is created from scratch after the PSU has been applied
o an oracle_home.
This also means the registry$history does not get any entries to see
hich PSU has been applied.
Short of comparing db creation date and PSU patch date is there a
uery I can execute in the database that will give me the PSU level
pplied to the home from which the database was created?
<<<<<<<<<<<<<<<<<<<<<<<<
2.3.4 Post Installation Instructions for Databases Created or Upgraded
fter Installation of PSU 10.2.0.4.3 in the Oracle Home
These instructions are for both non-RAC environments and RAC
nvironments when a database is created or upgraded after the
nstallation of PSU 10.2.0.4.3.
You must execute the steps in Section 2.3.3.1, "Loading Modified .sql
iles into the Database"" and Section 2.3.3.2, "Recompiling Views in
he Database" for any new database only if it was created by any of
he following methods:
Using DBCA (Database Configuration Assistant) to select a sample
atabase (General, Data Warehouse, Transaction Processing)
Using a script that was created by DBCA that creates a database from a
ample database
Cloning a database that was created by either of the two preceding
ethods, and if Section 2.3.3.1, "Loading Modified .sql Files into the
atabase" and Section 2.3.3.2, "Recompiling Views in the Database"
ere not executed after PSU 10.2.0.4.3 was applied
Upgraded databases require that you perform the steps in Section
.3.3.2, "Recompiling Views in the Database" if these steps have not
reviously been performed; otherwise, no post-installation steps need
o be performed.
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
Jack van Zanen
-------------------------
his e-mail and any attachments may contain confidential material for
he sole use of the intended recipient. If you are not the intended
ecipient, please be aware that any disclosure, copying, distribution
r use of this e-mail or any attachment is prohibited. If you have
eceived this e-mail in error, please contact the sender and delete
ll copies.
hank you for your cooperation
-
ttp://www.freelists.org/webpage/oracle-l
Other related posts:
