Re: Upgrading Repository database

Hi Mark,

I am upgrading the backend database which is of version 12.1.0.1.0

Thanks
Nilesh

On Wed, May 10, 2017 at 10:05 PM, Powell, Mark <mark.powell2_at_dxc.com> wrote:

> Nilesh, I am confused by your post. The OEM repository is upgraded when
> you upgrade OEM and has no direct relation to the database version. That
> is, OEM 12c repository can be hosted on as old a version of the RDBMS
> as 10.2.0.5. Are you upgrading OEM or the backend database that hosts the
> repository. If you want to rehost the repository into a different database
> .
>
>
> If you have support access take a look at the following two support notes
>
> EM 12c R2: How to Upgrade to EM 12c R2 - One System Method (Doc ID
> 1360076.1)
> EM 12c: How to Upgrade to EM 12.1.0.5 - Two System Method (Doc ID
> 1363162.1)
>
>
>
> Mark Powell
> DXC Technology
> Database Administration
> (313) 592-5148
>
>
> ------------------------------
> *From:* oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on
> behalf of nilesh kumar <nileshkum_at_gmail.com>
> *Sent:* Wednesday, May 10, 2017 12:01:11 PM
> *To:* ORACLE-L
> *Subject:* Upgrading Repository database
>
> Hello All,
>
> I have to upgrade the repository database i.e. OEM database.
> It is hosted on AIX and the version is 12.1.0.1.0 to 12.2.0.1.0
> Oms is hosted on windows box and its version is 12.1.0.4.0, there are
> around 500+ targets registered in OMS.
>
> Could you please advise how to upgrade the repository database.
>
> I thought of upgrading via expdp by creating a new DB in 12.2 and then
> importing from source DB 12.1 and then renaming the database on the same
> host.
> After that I thing I have to register the OMS to 12.2 newly created and
> imported DB, but not sure of this as I have not tried earlier. Is it a good
> approach.
>
> Any specific steps that need to be done on repository database as part of
> the upgrade.
>
> Please share and advise if there are any docs or note for this.
>
> --
> Thanks & Regards
> Nilesh
> Oracle DBA (sqlplus "/as sysdba" is my world)
>
> "As our circle of knowledge expands, so does the circumference of darkness
> surrounding it."--Einstein
> "All men die, few men ever truly live" -- Braveheart
> "You can get help from teachers, but you are going to have to learn a lot
> by yourself, sitting alone in a room." --Dr. Seuss
> "Know me for what I do and for not what I am. Judge me for what I can do
> and not for what I have done."-Unknown
> "Don't walk in front of me, I may not follow. Don't walk behind me, I may
> not lead. Just walk beside me and be my friend."- Albert Camus
> "Never argue with an idiot. They drag you down to their level and then
> beat you with experience." - Unknown
>

-- 
Thanks & Regards
Nilesh
Oracle DBA (sqlplus "/as sysdba" is my world)

"As our circle of knowledge expands, so does the circumference of darkness
surrounding it."--Einstein
"All men die, few men ever truly live" -- Braveheart
"You can get help from teachers, but you are going to have to learn a lot
by yourself, sitting alone in a room." --Dr. Seuss
"Know me for what I do and for not what I am. Judge me for what I can do
and not for what I have done."-Unknown
"Don't walk in front of me, I may not follow. Don't walk behind me, I may
not lead. Just walk beside me and be my friend."- Albert Camus
"Never argue with an idiot. They drag you down to their level and then beat
you with experience." - Unknown

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