Re: Grid Control upgrade

Amit,

Look at the sysman schema in the repository. It contains all the info about the jobs, events, blackouts, etc for every monitored target (db, listener, app server, etc). The data in the target db (AWR) is the performance metrics for that particular db.

If you install R2 with a new db you'll lose everything in your current sysman schema and you'll have to recreate it all. This may actually be easier than converting all the data from R1 depending on how much data there is and how reliable the upgrade (R1 to R2) process is. We will be upgrading to R2 when it is released for windows and may take this approach since we don't have many targets currently.

Joe

Amit Verma wrote:
> Okay, another question:
>
>
>
> Since EM 10gR2 (Grid Control) stores all the information inside the
> target database (AWR), is it worth upgrading and copying the old
> repository database to the new hardware and database? Or can I just
> install GC with new database option? What does it contain? Does anyone know?
>
>
>
> Amit Verma
> Senior Oracle DBA
> University of Michigan ITCS
> Ph: 734-647-5790
>
> ------------------------------------------------------------------------
>
> *From:* Amit Verma [mailto:averma_at_umich.edu]
> *Sent:* Thursday, April 13, 2006 11:05 AM
> *To:* 'oracle-l_at_freelists.org'
> *Subject:* Grid Control upgrade
>
>
>
> I have OMS Grid control 10.1.0.3.0, with a repository database on Oracle
> Version 9.0.1.5.0 running on RHEL 3. I want to upgrade the OMS to
> 10.2.0.1 and move the OMS to a new hardware running the same OS platform
> and version RHEL3.
>
> I am thinking the following upgrade plan should work;
>
>
>
> 1. Install 10.2.0.1 GC on new hardware.
>
> 2. Keep auto discovery off.
>
> 3. Export/import data from old database to new database.
>
> 4. Turn auto discovery on.
>
> 5. Shutdown OMS on old machine and start on the new one.
>
>
>
> Does this sound reasonable? Has anyone any experience of this sort? Can
> anyone suggest any documents available that I can refer?
>
> -Amit.
>
>
>
> Amit Verma
> Senior Oracle DBA
> University of Michigan ITCS
> Ph: 734-647-5790
>
>
>

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