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: 126.96.36.199, 188.8.131.52, 184.108.40.206, 220.127.116.11 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);
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:
chown oracle:oinstall /oracle
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
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).