Using DB Template for EM

Recently we performed a fresh installation of Oracle Enterprise Manager (EM) using Oracle Database Enterprise Edition as the management repository database.  We also installed Oracle Grid Infrastructure so that we could take advantage of ASM for the database datafiles.

Oracle provides a great pre-configured database template to help for this particular setup when using EM and DB that can save a little bit of installation time and eliminate having to manually configure various database parameters, tablespaces, etc.  The first thing to do is to determine if you fall into the small, medium or large deployment of Enterprise Manager.  See the Deployment Size portion of the document to determine which deployment size your environment is best suited for.  Details about the preconfigured DB template is available right in the EM 12c documentation.

I’m not going to go through every detailed step of what we did but at a high level the following was performed:

  1. Install the Grid Infrastructure home ( so we can use ASM for our database datafiles.
  2. Install the Database home (
  3. Download the EM template, DB Template for EM on Linux x86-64, from the Oracle Technology Network then start DBCA to configure a new database with it.

Once the template is downloaded you’ll want to extract it to $ORACLE_HOME/assistants/dbca/templates so that it appears in the DBCA templates window.

$ cp /stage/EM12_DB_template/ $ORACLE_HOME/assistants/dbca/templates

$ unzip
inflating: set_repo_param_12.
inflating: set_repo_param_12.
inflating: set_repo_param_12.
inflating: shpool_12.

Next you’ll want to execute the database configuration assistant (DBCA) and when you get to the database template screen use the EM template (for our example we used the small deployment).

DB Templates

It’s important when you get to the Database Options screen that you include the script that will be executed after the database is created called shpool_12.

Script from Template Extraction

Here we can see that the template has set the memory parameters accordingly and the number of connections based on the EM deployment size you chose earlier.

Memory Settings


Once the database creation is completed we can see that it created the required EM tablespaces for us.

select name from v$tablespace;


All that’s left is to install Enterprise Manager and point to this newly created database. With the EM database template you can see that the configuration of the EM management repository database is made a little easier providing us with the recommended settings based on the deployment size of your EM environment.

Leave a Comment

Your email address will not be published. Required fields are marked *