As you know, you need a database for 12c Cloud Control as management repository. Since 12c is out there for a while and we are not upgrading our 11gR2 databases to 12c yet, I think it's a good idea to use 12c for this purpose and get custom with it. As a reminder, Oracle says it's free to install a database if you use it for OEM purposes only. So, let's begin.

We'll install 12.1.0.2.4 database on Oracle Linux 6.6

First thing to do, as a requirement, is installing oracle-rdbms-server-12cR1-preinstall package. This package makes the whole process pretty easier. I can say this is first -and frankly the second- reason I choose to use Oracle Linux.

As root:
$ yum install oracle-rdbms-server-12cR1-preinstall

Then create necessary directory for installation and grant privileges:

$ mkdir /u01
$ chown -R oracle:oinstall /u01

Do not forget to set password for oracle user. Then log on as oracle and start installation. Unzip installation files an run the installer:

$ unzip linuxamd64_12102_database_1of2.zip
$ unzip linuxamd64_12102_database_2of2.zip
$ cd database
$ ./runInstaller


Choose to install software only. It'll be a single instance.








 Run root scripts as root




Now install the latest PSU. You can check the latest one from Doc ID 756671.1. Before applying PSU update OPatch first. Check patch number 6880880 for latest OPatch. PSU Installation may differ from version to version, so please refer to its documentation.

Now it's time to create a database. There're Enterprise Manager templates you can download. Follow the link and download db templates zip file. Before running DBCA to create a database unzip the file you downloaded to templates directory:

$ unzip 12.1.0.2.0_Database_Template_for_EM12_1_0_5_0_Linux_x64 -d /u01/app/oracle/product/12.1.0.2/dbhome_1/assistants/dbca/templates/

$ dbca


Choose advanced mode to continue:


Select Database Template fro EM according to your EM deployment size; small, medium or large.


Set your database name

De-select "Configure EM Database Express"




Set appropriate directories for database files


Select the following script file to run. It'll set a couple of parameters:

/u01/app/oracle/product/12.1.0.2/dbhome_1/assistants/dbca/templates/shpool_12.1.0.2.0_Database_SQL_for_EM12_1_0_5_0.sql


Set SGA and PGA according to your server size:








And your database for 12c Cloud Control is ready. On my next post, I'll be explaining 12 Cloud Control installation.