Patch and Provision with EM12c: #1 Database Provisioning – Provision Me a Database!

Preface
Among the several (too many to list) useful features in Enterprise Manager 12c (specifically 12.1.0.3) is Database Provisioning. With the numerous benefits of a multi tenant architecture in newer releases Database 12c, I want to begin this series of blog posts with starting with a simple database provisioning exercise. Provisioning is, in my humble opinion, a key feature in OEM. It offers a means to cleanly deploy and provision databases, bare metal, and middleware targets.
This post assumes:

  • The intended host for the database provisioning is already in the OEM Inventory
  • There are existing 12c Databases in the inventory to create profiles
  • Configured the Software Library
  • 12.1.0.1.0 Installation Media has been uploaded to the Software Library (see my post on the setup)
  • Pre-requisite checks for installation of Oracle Database 12.1.0.1.0 were configured as per documentation

Lets begin.

What is “Database Provisioning”
Straight from the Docs: “The Provisioning solution is an important part of Lifecycle Management solution offered by Cloud Control. As part of the database provisioning solution, Cloud Control enables you to provision Oracle Databases (also known as single-instance databases) and Oracle Real Application Clusters databases, extend or delete Oracle Real Application Clusters nodes, provision Oracle Real Application Clusters One node databases, provision pluggable databases, and also upgrade Oracle single-instance databases in a scalable and automated manner.”
NewImage
How Does It Work?
1. Navigate to the “Database Provisioning” Section
NewImage
2. On the “Database Provisioning” screen, you’ll notice several sections; Setup, Target Host Setup, Current Status, and a few others. This page is connected to several other functionalities within OEM; for example, Add Targets, Named Credentials, 
NewImage
3. We should proceed with the “Setup” to configure the Software Library (if not already setup), Credentials, and Notifications (if needed).

Credentials Setup
3.1 To keep the exercise simple, we’ll proceed with the SYSMAN user. Ideally, a user with the correct privileges should perform the steps. I will discuss this in a later post. (EDIT).
NewImage
3.1.1 Click the “Setup” link next to Credentials. This redirects to the “Security” page where Credential Sets can be easily created.
NewImage
3.1.2 Create credentials by clicking on the “Create” button. Fill in the details, then click on “Test and Save”
NewImage
3.1.3 Select the appropriate host for the test.
NewImage
3.1.4 After creating the Oracle user credentials, for easy of usability, I created one for a privileged user.
NewImage
At this point we have configured the Software Library, and Credentials.

Provisioning Wizard
4. Back on the “Database Provisioning” screen, there are several “out-of-the-box” profiles. For starters, we will simply use the “Single Instance using File System for 12.1.0.1.0 on Unix” profile. Click the “Provision” button to continue.
I do intend to expand on creating a new “Profile” in a later post.
NewImage
4.1 Since we started with a Provisioning Profile, the correct one is preselected. For this example, we will not install the GI Software, only the Database Software and Create a database.
NewImage
4.2 Add the target host for deployment.
NewImage
Configuration
4.3 Next, configure the host.
NewImage
4.3.1 Next, select the Normal and Privileged OS user. Please note, in my example, these are two different credential sets where I’ve chose to override the “Preferred Credentials”.
NewImage
4.3.2 Next, specify the OS Groups for the software installer. I’ve never heard of or seen the last three groups.
NewImage
4.4 Back to the Configure screen, click on the “Deploy Software” link.
NewImage
4.4.1 Select the component that will be used during the software deployment. I left the default values for Oracle Base, and Oracle Home. Click on Next.
NewImage
4.5 Next, click on Create Databases.
NewImage
4.5.1 The next few screens will remind you of our friend the DBCA 🙂
NewImage
4.6 Final section in the Configuration. Lets move ahead with the Compliance Standards.
NewImage
4.6.1 I’m going to chose “None”. This can be applied at a later date.
NewImage 
4.7 With all the Configuration steps completed, click Next!
NewImage
Scheduling
5. We’re nearly there. I want to review the prerequisite checks prior to committing the deployment, therefore I checked the option in the “Prerequisite only mode”.
NewImage
Blast-Off!
6. Finally, review the configuration and click Submit.
NewImage
6.1 Progress can be tracked via the Procedure Activity screen for the provisioning task.
NewImage
6.2 Some errors I encountered along the way:
During the “Deploy Oracle Database” step, the provisioning activity failed due to the error below:
NewImage
It was an easy fix, but I would have thought the root fixup script was responsible for it.
NewImage 
Where’s All My Hard Work?
7. We can view the newly created Deployment Procedure (which I kept saving along the way and eventually renamed).
7.1 Make your way back to the Database Provisioning page.
NewImage
7.2 There it is!
NewImage 
7.3 A neat feature of the deployment procedures is, that it actually add’s the targets (Database) into OEM. Navigate to the Databases page.
NewImage 
7.4 Since I specified a new database software home, the installer for some reason use the “11g” phrase in the Oracle Home Name variable.
NewImage
Conclusion
I’ve only scratched the surface with all that the Provisioning and Patching feature in OEM12c has to offer. I future posts, I’d like to explore other deployment procedures which include:

  • Database Provisioning: Cloning of an Oracle home, Uninstallation of Software.
  • Middleware Provisioning: Deploying WebLogic domains etc.

Hope you enjoyed reading.
Cheers!

Next in Series: Profiles

Advertisements

2 comments

  1. oracledba · · Reply

    I am in the process of provisioning a 11.2.04 database using a 12c OMS on a RHEL 6 server. I am aware of a bug in the prerequisites where it does not check for RHEL6 prerequisites and there was a work around where we are required to modify the file before running the pre-requisites. How is this done when prvisioning the 11.2.0.4 database using OMS12c where I would like to complete the software provisioning without any interuption where I got to manually ignore the failed check once it fails for the pdksh package. I would like to know if there is a pre-requisite check file in OMS 12C I would need to modify or a patch available to apply.

    Thanks In Advance.

    1. You could do a “Create Like” for the Deployment Procedure and omit the directive where the pre-requisite checks occur. I have to admit, I haven’t attempted that myself but let me know if you run into any challenges.

      Cheers,
      Maaz

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Musings

Things I see and learn!

Thoughts from James H. Lui

If you Care a Little More, Things Happen. Bees can be dangerous. Always wear protective clothing when approaching or dealing with bees. Do not approach or handle bees without proper instruction and training.

bdt's oracle blog

Sharing experience (by Bertrand Drouvot)

Frits Hoogland Weblog

IT Technology; Oracle, linux, TCP/IP and other stuff I find interesting

Vishal desai's Oracle Blog

Just another WordPress.com weblog

%d bloggers like this: