Re: Grid Control upgrade

Joe,

I spoke with Oracle Support this evening and they suggested the following plan:

1. Install 10gR2 EM on new hardware.
2. Install 10gR2 agent.
3. Install and create a 9206 db(My choice over a 10.1.0.4 buggy db).
4. Change the agent configuration on target nodes to point to the new OMS.

You may be correct that sysman store information about jobs, events, blackouts etc, but since I am not using any of these(I mean user-defined, my current installation is out-of-the-box OMS), I am going to go ahead with this plan and not worry about moving the repo db. Also, the support guys told me was the repo db has information about the hostname the oms is running on, so the exp/imp wouldn't work.

I hope this works. I am gonna try this tmrw and will let you know if this works.

Thanks

-Amit.

Quoting Joe Armstrong-Champ <joseph.armstrong-champ_at_tufts.edu>:

> 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
>
>
>
>
>

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