How to Install Oracle Enterprise Manager Cloud Control 12c

October 7, 2011Gokhan Atil46 CommentsOraclecloud control, em12c, enterprise manager

Installing Oracle Enterprise Manager Cloud Control 12c is easy and it’s already explained in a video at OTN website and MOS [ID 1359176.1]. Still, I wanted to create a step by step guide, and highlight the important points.

Here are the steps:

1) Installation of Oracle Linux (How to Install Oracle Linux 5.6)
2) Installation of Oracle Database (Repository Database): You can install one of the certified databases: 11.2.0.3, 11.2.0.2, 11.2.0.1, 11.1.0.7 and 10.2.0.5.

Do not forget to apply the latest PSU to the database. It is recommended that you do not use “memory_target” parameter with Enterprise Manager. Run the following commands and bounce the database:

ALTER SYSTEM SET pga_aggregate_target=1G SCOPE=SPFILE;
ALTER SYSTEM SET shared_pool_size=600M SCOPE=SPFILE;
ALTER SYSTEM SET job_queue_processes=20 SCOPE=SPFILE;
ALTER SYSTEM SET log_buffer=10485760 SCOPE=SPFILE;
ALTER SYSTEM SET open_cursors=300 SCOPE=SPFILE;
ALTER SYSTEM SET processes=300 SCOPE=SPFILE;
ALTER SYSTEM SET session_cached_cursors=200 SCOPE=SPFILE;
ALTER SYSTEM SET sga_target=2G SCOPE=SPFILE;

EXEC dbms_auto_task_admin.disable('auto optimizer stats collection',null,null);

ALTER SYSTEM SET pga_aggregate_target=1G SCOPE=SPFILE;

ALTER SYSTEM SET shared_pool_size=600M SCOPE=SPFILE;

ALTER SYSTEM SET job_queue_processes=20 SCOPE=SPFILE;

ALTER SYSTEM SET log_buffer=10485760 SCOPE=SPFILE;

ALTER SYSTEM SET open_cursors=300 SCOPE=SPFILE;

ALTER SYSTEM SET processes=300 SCOPE=SPFILE;

ALTER SYSTEM SET session_cached_cursors=200 SCOPE=SPFILE;

ALTER SYSTEM SET sga_target=2G SCOPE=SPFILE;

EXEC dbms_auto_task_admin.disable('auto optimizer stats collection',null,null);

These are minimum values, you can set higher values according to your system resources. It’s also recommend to have at least 3 redo log groups sized 300M. Luckily, the installer will warn you about all these settings.

3) Installing Enterprise Manager Cloud Control software: First, create an oracle base directory (i.e. /oracle) and give permissions to oracle:

su - 
mkdir /oracle
chown oracle:oinstall /oracle 
exit

su -

mkdir /oracle

chown oracle:oinstall /oracle

exit

After you download the zip files, unzip them and run the installer:

unzip em12_linux64_disk1of2.zip -d cloudsetup
unzip em12_linux64_disk2of2.zip -d cloudsetup
cd cloudsetup
./runInstaller

unzip em12_linux64_disk1of2.zip -d cloudsetup

unzip em12_linux64_disk2of2.zip -d cloudsetup

cd cloudsetup

./runInstaller

Make sure that no Environmental variable related with Oracle (such as ORACLE_HOME) are set prior to installation. It’s also recommend to set umask to 022.

If you want to get emails about security updates, enter the credentials for MOS Support or leave them blank.

Enter the credentials for MOS Support (again) to download the updates. If you don’t have MOS support, no problem because there’s no update released yet 🙂

Oracle Universal Installer is getting smarter day by day. It will check the prerequisites if you’re installing it to Oracle Linux 5.5 or higher and installed “oracle-validated package), you’ll probably get no error at this step.

Enter the target directory (Middleware Home), select the “create new Enterprise Manager System” option and click next. I prefer simple installation. It will install Cloud Control with the default plugins (Oracle Database, Fusion Middleware, My Oracle Support, Exadata) to the default locations according to the base location.

Enter the administrator password (you will need it to administrate the weblogic instance, and to register Agents!).

The installer will check the database, and warn you about errors. It will also try to fix the problem. For example, the installer can disable CBO statistics for you.

Review the settings and if you’re ready to install, click “install”.

Open a terminal and switch to root, and run the root script.

It’s ready. Enter the URL of Enterprise Manager Clod Control console to access the web interface.

After you accept “SSL warnings”, we see the login screen. You can login with SYSMAN password (the administrator password you entered).

Please share

Gokhan Atil

AWS Big Data Specialist. Oracle Certified Professional (OCP) for EBS R12, Oracle 10g and 11g. Co-author of "Expert Oracle Enterprise Manager 12c" book published by Apress. Awarded as Oracle ACE (in 2011) and Oracle ACE Director (in 2016) for the continuous contributions to the Oracle users community. Founding member, and vice president of Turkish Oracle User Group (TROUG). Presented at various international conferences including Oracle Open World.

46 Comments

Shaun

May 7, 2012 Reply

HI there

Quick question can you monitor oracle applications with oem 12c?
- Gokhan Atil
  
  May 9, 2012
  
  Yes you can. Please check: EM12c New Features
Vincent Ogbu

March 18, 2013 Reply

Hi Gokhan:

Can I use the same Host (server) for the Repository database, the OEM Cloud 12c and Java/weblogic server (middleware) during my installation.

Best regards.

Vincent
- Gokhan Atil
  
  March 18, 2013
  
  Hi Vincent, yes you can install both repository database and weblogic (+ Oracle Management Service) on the same server.
- Vincent Ogbu
  
  March 18, 2013
  
  Thanks, very much Gokhan …
  Keep up the good work ..
  
  Best regards.
  
  Vincent
Vincent Ogbu

March 19, 2013 Reply

Good morning Gokhan:

Since, I am installing both repository database and weblogic (+ Oracle Management Service) on the same server, do see any licencing issue in this case?

Best regards.

Vincent.
- Gokhan Atil
  
  March 19, 2013
  
  Vincent,
  
  As I know, you don’t need to buy licenses for weblogic and repository database as long as they are only used for Enterprise Manager. It doesn’t matter if you install them separate servers or on the same server.
  
  On the other hand, you should always contact Oracle to ask questions about licensing.
- Vincent Ogbu
  
  March 19, 2013
  
  Thanks, Gokhan for your input.
  
  Best regards.
  
  Vincent
boualema abid

May 23, 2013 Reply

Hi,

i am installing OMS Cloud 12c r2, and i am not able to connect using sysman/pass. authentication failed.

Regrads.
BOUALEM
- Gokhan Atil
  
  May 25, 2013
  
  Hi Boualem, you need to enter password of SYS user. Installer will connect as SYS and create SYSMAN user.
sasidhar

July 18, 2013 Reply

Hi Gokhan,

Thanks for sharing such a good info.

Can you please share how to install 12 agent.

Thanks,

Sasidhar
- Gokhan Atil
  
  July 18, 2013
  
  Sasidhar, you may check my other posts. For example:
  
  How to Deploy Oracle Management Agent 12c
abhishek

March 17, 2014 Reply

Hi Gokhan,

I recently installed OEM 12c and everything was working fine. I didn’t login to EM for a week. After a week when I tried to login as sysman/pswd on the console I got “authentication failed. if problem persists contact your system administrator” error. Fortunately I found something on metalinks and could resolve it executing two queries. I didn’t login over the weekend and again on Monday I faced the same problem. The solution I found was

BUG 16205038 : [EMCC] DBMS JOBS ARE NOT EXECUTED REGULARLY CAUSING AUTHENTICATION FAILURE

I logged in as sysman and ran these two queries and bounced the OMS.

SQL> update mgmt_audit_master set prepopulate_days=5 where prepopulate_days is null;
SQL> exec mgmt_audit_admin.add_audit_partition;

Thanks.
erkan ülgey

July 17, 2014 Reply

Teşekkürler Gökhan Bey.
Masoud

September 10, 2014 Reply

Thanks Gokhan
Someone that you don’t know even exists, thinks about you
Ron Nixon

October 3, 2014 Reply

how do you find OMS_HOME.
- Gokhan Atil
  
  October 3, 2014
  
  Hi Ron, login to your OMS server and check the content of /etc/oragchomelist file:
  
  cat /etc/oragchomelist
  
  1
  
  cat /etc/oragchomelist
Thien

December 10, 2014 Reply

Dear Gokhan

Thanks very much for great information

Now I already 12cR2, actually now the latest verison is 12cR4

So do you have document for upgrading from 12cR2 to 12cr4?

Thanks
- Gokhan Atil
  
  December 10, 2014
  
  Hi Thien,
  
  I do not have a document for upgrading from R2 to R4, but I wrote one for upgrading from R3 to R4. It may help you:
  
  Upgrading Enterprise Manager Cloud Control 12.1.0.3 to 12.1.0.4
  
  I can say that latest EM12c provides a smooth upgrade process as long as you check the official documents.
RT

January 3, 2015 Reply

Dear Gokhan

Thanks very much for great information shared by you!!

I am helpful with your information.

Thanks.
Hartley

February 20, 2015 Reply

So WebLogic server does not to be installed before installing Cloud Control?
- Gokhan Atil
  
  February 25, 2015
  
  Hartley, no you don’t need to install Weblogic before installing Cloud Control. The EM12c installer will install and configure Weblogic.
farouk

April 26, 2015 Reply

Hi, I’m fairly to oracle 12c so pardon me for asking any silly questions. I just did a fresh install of oracle 12 but I cant find
find enterprise manager anywhere. do i need to install it separately? if yes, how ? I’m working on a windows 7 machine. Thanks for your help.
- Gokhan Atil
  
  April 28, 2015
  
  Farouk, Oracle 12c Enterprise Manager Cloud Control is a separete product, so you need to download and install it separately. If you’re looking for Oracle Enterprise Manager Express, it comes with Oracle 12c database.
  
  You can find more information about EM Express in Oracle documents.
Sridhar

June 1, 2015 Reply

Hi Gokhan,

I am installing OEM. It is showing error for nls_lenth_semantics=BYTE. But my DB requires CHAR. I can’t change it to BYTE. Plz tell me how to proceed with installation by keeping CHAR.

This is very imp for me.

Thanks in advance.

Regards,

Sridhar
- Gokhan Atil
  
  June 1, 2015
  
  Hi Sridhar,
  
  You don’t need to buy license for repository database as long as you use it only for EM12c. So why don’t you install and create a new database for OEM12c instead of using your current database?
Sunil

August 11, 2015 Reply

Hi Gokhan,

Just one doubt. do we need to install oracle enterprise manager cloud control where my existing database server is installed or i can create new vm and install only OEM cloud control.

regards

Sunil
- Gokhan Atil
  
  August 19, 2015
  
  Sunil, you can install it to another server. They do not need to be on same server. OEM will require an Oracle Database as repository database. You can create a new database for it on existing servers or install Oracle RDBMS software on the OEM server.
Rudy Torres

September 16, 2015 Reply

Hello,

I found your blog on the net and have a question. I have recently joined an Oracle RAC DBA Team where the DBA’s are gone and did not leave the sysman password. They created a user for me which allows me to connect to the production database. I am trying to access Oracle Enterprise Manager 12C Cloud Control to have a view of all the cluster environments and DB’s but it appears I do not have authentication, as I get an ‘Authentication Failed’ error. The only way I can connect with DBA rights is using the sqlplus “sys as sysdba” connection. Is there a way I can provide authentication to my user account using sysdba connection?

Thanks in Advance

-Rudy
sara

November 10, 2015 Reply

Hi Gokhan,

I have windows Server 2012 64bit and install Oracle database 12c.

I need to help me to install Oracle Cloud Control 12

Problem was in installation process after 5% of Installion :

“installation of Oracle WebLogic Server has failed, check log files for more details.”

regards
- Gokhan Atil
  
  November 11, 2015
  
  Sara, I can’t diagnose the problem without any data. You better check the installation logs. While examining the logs, you can also open a ticket to Oracle Support.
Ragip

July 26, 2016 Reply

Hi Gokhan ,

Can I install on Windows Server 2012 , because I’am not good on Linux.

Regards
- Gokhan Atil
  
  July 26, 2016
  
  Hi Ragip,
  
  Yes you can install it on Windows Server 2012 (x64bit).
Ragip

July 26, 2016 Reply

Thank you ,
Are the steps same like in Linux (like you explain)?
Regards,
- Gokhan Atil
  
  July 26, 2016
  
  Yes they are almost identical.
Vilas

August 23, 2016 Reply

Hi There,

Is it possible to install/configure 12c cloud control on the same host which is currently running 11g grid control? Do you see any issues?

Thanks

VG.
Pingback: OEM 12c – Learner
Sham G

July 25, 2017 Reply

Hi G.A

I have seen this post.

I hope its easy to configure OEM in Laptop. To configure OEM on OEL 6.8, what is the min configuration required?

I am using virtual machines using vmware work station.

Thanks
- Gokhan Atil
  
  July 26, 2017
  
  Instead of installing OEM to your laptop, you can use Oracle VM templates for OEM. I recommend you to install it on a VM with at least 50GB hard disk space and 8 GB RAM. More RAM is better. SSD is also recommended.
satya

August 11, 2017 Reply

Hi Gokhan,

I want to configure EM to monitor 12c CDB.

Pls explain me the diff b/w EM and EM Cloud Control.

How EM Cloud control is diff from EM.

What is Enterprise Manager Express..

I am confused and need your help.

Thanks in Advance.
ALi

August 28, 2017 Reply

Hi Gokhan

I am INSTALLING oem 12.2.0.1 12C ON WINDOWS SERVER.
ORA-01017: invalid username/password; logon denied
WHAT IS DEFAULT PASSWORD FOR WEB LOGIC, SYSMAN, NODE MANAGER.
do we have to create in Database.

Regards
Ali
Amir

February 1, 2018 Reply

Hi Gokhan,

Thanks for sharing your insights. Same goes for me. Invalid username/password logon denied. I suppose this is for the SYS login. I am installing EM on a clean Linux box separate from the Oracle RDBMS server, so I have no SQLPLUS, tnsnames.ora, oracle user, oracle variables or any client tools on my EM-to-be server. I entered the fully qualified oracle RDBMS server name and proper listener port. What should I do? Thanks in advance.
- Gokhan Atil
  
  February 2, 2018
  
  Amir, you need to enter the password of SYS user. Make sure that REMOTE_LOGIN_PASSWORDFILE parameter is set to EXCLUSIVE, and your have an uptodate orapwSID file.
SAB

July 21, 2018 Reply

Hello m getting this error message during installation ‘ installation of Oracle weblogic server has failed, check log files for more details’
Daniel

January 9, 2020 Reply

Hi I need your advice on the below :

We have the Following :

Oracle Enterprise Manager Cloud Control 13c Release 2
Agent Version : 13.2.0.0.0
Operating System : Linux version 3.10.0-862.11.6.el7.x86_64 (amd64)
Database : PostgreSQL

Can you provide the steps to Configure the above??
Irina

January 14, 2020 Reply

I need to install Oracle Enterprise Manager Cloud Control 12c In Amazon EC2 with no prior experience.
Hi Atil,
Current Linux version on EC2 is amzn2.x86_64 with Oracle client installed.
Please advise if the steps I am planning are correct?
• Create new EC2 instance with Linux Redhat 7.6 using available IAM
• Create OEM repository database using software build-in with Linux IAM. Question here if this software pre-packages with Linux or I need to download it separately?
• Download and Install Enterprise Manager Cloud Control 12c software in a separate Oracle home from the database.
• Enable OEM_AGENT option for my existing RDS database.
Kindly appreciated,
Irina