Joe,
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.
Thanks
-Amit.
Quoting Joe Armstrong-Champ <joseph.armstrong-champ@xxxxxxxxx>:
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@xxxxxxxxx] *Sent:* Thursday, April 13, 2006 11:05 AM *To:* 'oracle-l@xxxxxxxxxxxxx' *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
-- //www.freelists.org/webpage/oracle-l
-- //www.freelists.org/webpage/oracle-l