In an earlier post, I mentioned that Oracle has finally, offcially supported the Oracle Management Repository (OMR) on Database 12c (12.1.0.2). As I’ve been working on a DBaaS project, I built a new Oracle Enterprise Manager (OEM) enivornment to test out a few things. Since I was rebuilding, I decided to try out the PDB as an OMR (afterall I’ve been asking about this approach). In the past, installation would fail around 63%. This time around, OEM installed in a PDB with no issue at all!
To verify that the OMR was actually in an PDB, I had to dig around a bit. Durning the installation, I had to provide connection information. This configuration can be verified by going to Management Services and Repository page within OEM. Once on this page, the Repository Details section (see image) will show you the database name and the connection string used. The connection string identified the PDB being used in the Service Name part of the connection.
In the image, you can see that I’m using a database named MGMT, yet the connection string is going to service name OEM1.acme.com. OEM1 is the PDB that is running under the MGMT consoldiated database (see image).
What makes this work this time around? There are a few patches that have to be applied to the Oracle Database (12.1.0.2) before the PDB can be used for the OMR. These patches are 19769480, 19877336, and 20243268. These patches are required (more details here). These patches require using OPatch 12.1.0.4.0 or higher which can be downloaded from MOS Note: 274526.1 (Patch 6880880).
Overall, Oracle did a good job in resolving this issue and giving the ability to host OEM in a PDB. There are a few questions that come to mind now. Here are just a few that I have:
1. What use cases will come out of this?
2. How will performance of OEM look in using a PDB?
3. How will licensing change with OEM and PDBs?
Anyways, give it a try!
Enjoy!!
about.me: http://about.me/dbasolved
Please follow and like:
Bobby Curtis
I’m Bobby Curtis and I’m just your normal average guy who has been working in the technology field for awhile (started when I was 18 with the US Army). The goal of this blog has changed a bit over the years. Initially, it was a general blog where I wrote thoughts down. Then it changed to focus on the Oracle Database, Oracle Enterprise Manager, and eventually Oracle GoldenGate.
If you want to follow me on a more timely manner, I can be followed on twitter at @dbasolved or on LinkedIn under “Bobby Curtis MBA”.
Follow if you like:
Why visitors still make use of to read news papers when in this technological world the whole thing is available on web?
Also visit my blog nordvpn coupons inspiresensation
Superb post but I was wondering if you could write a litte
more on this subject? I’d be very grateful if you could elaborate a little
bit more. Many thanks!
Feel free to visit my homepage; nordvpn coupons inspiresensation
Hi! I’ve been reading your website for a long time now and finally got
the courage to go ahead and give you a shout out from Dallas Tx!
Just wanted to mention keep up the good work!
Feel free to visit my web site nordvpn coupons inspiresensation (easyurl.cc)
nordvpn code 350fairfax
Does your site have a contact page? I’m having trouble locating it but, I’d like
to send you an e-mail. I’ve got some suggestions for your blog you might be
interested in hearing. Either way, great website
and I look forward to seeing it improve over time.