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@xxxxxxx> 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@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on
behalf of nilesh kumar <nileshkum@xxxxxxxxx>
*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
