Re: When was database upgraded

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Wed, 22 Feb 2006 14:29:11 -0700
Message-ID: <04e301c637f7$065ebe40$0400a8c0@porgand>

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_at_freelists.org 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_at_hotmail.com> 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

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

Received on Wed Feb 22 2006 - 15:29:11 CST