Re: When was database upgraded

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/

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

Other related posts: