RE: Installing 12c OMS/EM

From: Peter Sharman <pete.sharman_at_oracle.com>
Date: Thu, 13 Nov 2014 12:11:05 -0800 (PST)
Message-ID: <74768047-2fdc-48ba-aa95-9c5aeacfcc00_at_default>



Yes you can use the 11.2.0.2 database, provided it's linked with the right options installed (for example, Partitioning). EM comes with a restricted use license for the options it requires. That means you can use the partitioning for free, BUT only for EM (i.e. not the other schemas already in the database).  

Pete

Pete Sharman
Database Architect, DBaaS
Enterprise Manager Product Suite
33 Benson Crescent CALWELL ACT 2905 AUSTRALIA

Phone: HYPERLINK "tel:+61262924095"+61262924095 | | Fax: HYPERLINK "fax:+61262925183"+61262925183 | | Mobile: +61414443449


"Controlling developers is like herding cats."

Kevin Loney, Oracle DBA Handbook  

"Oh no, it's not, it's much harder than that!"

Bruce Pihlamae, long term Oracle DBA


 

From: Sandra Becker [mailto:sbecker6925_at_gmail.com] Sent: Friday, November 14, 2014 6:41 AM
To: oracle-l
Subject: Re: Installing 12c OMS/EM  

It is an EE 11.2.0.2 database. Used for very little right now. A few scripts that gather information once a day. We are trying to better manage our resources and believe using this database for both would be a reasonable option for us. I believe the database has more than enough memory and disk to handle redo generation, datafiles, etc. based on what I've read for the requirements. There is no SYSMAN user in the database so we're ok on that point as well.  

Thank you for the information.  

Sandy  

On Thu, Nov 13, 2014 at 12:29 PM, Hans Forbrich <HYPERLINK "mailto:fuzzy.graybeard_at_gmail.com"fuzzy.graybeard_at_gmail.com> wrote:

You need to have an Enterprise Edition database in place as repository for the OEM.

The OEM console will be used to create users, and set up lots of roles and other security-related things in that database. There will be a number of specific initialization parameters set, if needed.

There will be tons of views, procedures and functions added to that database, mostly under user SYSMAN.

There will be a lot of redo generated as the data gets loaded almost continuously from the targets.

If you can handle that in an existing database, and you do not have an existing SYSMAN schema, then you should be able to use the existing database.

However, remember that the licensing basically allows you to create a separate database on any other machine specifically for OEM repository without needing to purchase an additional database license - unless you want Standby (where the standby database needs to be licensed) or RAC (where you need to license the RAC option and the instances on the nodes). This is described in Chapter 1 of the OEM licensing manual.

So personally, I would not recommend using an existing database that has other purposes. Especially since you don't need to pay extra to put the basic OEM/OMR on a different machine.

/Hans

On 13/11/2014 12:17 PM, Sandra Becker wrote:

I've never done the OMS/EM install before so I've been poring over the docs. Everything says to create a new database. We would prefer to use an existing 11.2.0.2 database. Is that an option? If yes, is there anything I need to do to ready it for the OMS install? Can anyone point me to a doc that tells me what I need. I'll keep looking, but haven't found one yet.

Thanks.

-- 
Sandy
GHX

 

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






-- 

Sandy
GHX


--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 13 2014 - 21:11:05 CET

Original text of this message