Re: When was database upgraded
- From: Tanel Põder <tanel.poder.003@xxxxxxx>
- To: "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 22 Feb 2006 14:29:11 -0700
If you've got your alert log you could grep it for the version string and see
when the first startup using new software version was done.
Otherwise, this might help to detect last change to dba_registry:
select comp_id, version,status, modified from dba_registry;
Tanel.
----- Original Message -----
From: LiShan Cheng
To: Oracle-L@xxxxxxxxxxxxx
Sent: Wednesday, February 22, 2006 7:15 AM
Subject: Re: When was database upgraded
go to log directory and do
grep -l "Database SQL Scripts Patch 9.2.0.6.0" *
hth
On 2/22/06, Fred Smith < fred_fred_1@xxxxxxxxxxx> wrote:
I checked Metalink & Google but found no results, perhaps someone here
knows:
Is there a way to see when a database was upgraded? The database was 9.2.0.3
and is now 9.2.0.6, and we are trying to determine on what date it was
upgraded to 9.2.0.6. Does anyone know a way to tell?
Thanks!
-FS
_________________________________________________________________
FREE pop-up blocking with the new MSN Toolbar – get it now!
http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/
--
//www.freelists.org/webpage/oracle-l
Other related posts:
