Maaz Anjum's Blog

With my previous post on creating Profiles with OEM12c completed, I wanted to use them for actual deployments. If you recall, Mr. Green wants to make sure that his deployments are consistent across each environment.

What I'd to achieve today

• Provision RDBMS software and Create a Database using a procreated profile

Let's Begin
1. Find your custom profiles by navigating to the Database Provisioning homepage.

2. Highlight the Profile you'd like to use and click "Provision".

3. On the next page, the profile you selected in the previous screen is already populated. Click the "Add" button, and select the correct host. Note, that you can select multiple hosts, but unfortunately I only have a single one to test with.

Configuration
4. On the next screen, as we have seen with earlier posts, the Configuration screens require a step-through of the Host, Software, Database, and Compliance areas.
4.1 Click on Setup Hosts

4.2 Select the correct values from the next couple of screens.

4.3 Click on "Deploy Software".

4.4 Enter the Oracle Base and Home directories.

4.5 Time for "Create Database".

4.6 Configure Database settings accordingly.

4.7 I usually just skip the Compliance setup. Clicked through it to get ahead.


4.8 Getting close to the end now!

4.9 Submit the task!

Progress
5. The procedure activity screen displays periodically refreshed status updates.
5.1 Let's start with the first one.

5.2 Bingo, we're done!


6. Upon searching for the container database, I find it.

Conclusion
The story doesn't end here, I could go a few steps further to provision the GI, RDBMS, and Database with a single profile. I'd like to save that for another time :)

I do understand, that in a test/lab environment the results aren't as critical as in a production one. The aim of these exercises is to show you that it is possible to leverage profiles to provision software plus database quite easily.

Cheers!