Creating Pluggable Database using OEM

Here in this article, I would demonstrate how we can create a new Pluggable Database using Oracle Enterprise Manager 13c.


1 - Login to the Oracle Enterprise Manager to go the Container Database target Home Page in which you want to create the new Pluggable Database.

2 - From the drop-down Menu of Cluster Database, Navigate to Provisioning > Provision Pluggable Databases.

3 - Create Pluggable Database : Creation Options page opens, Select "Create a new PDB" and provide oracle software owner credentials in the "Host Credentials" property. Click Next.

Click Next.

It validates the /tmp directory space on the nodes being provisioned.

You can schedule the provision date/time or you can just start the job right away with immediate option.

You can monitor the CreatePluggableDatabase job progress - Click on "View Execution Details" tab to monitor the progress.

Provisioning job's status now "Succeeded" and you are done with provisioning. You can validate the PDB status in OEM or by logging to the Container CDB at the host.







Hope it helps, thanks for reading, please subscribe to this blog to stay updated with latest news on Oracle Cloud Infrastructure and Oracle Autonomous Database Cloud Services and new articles.

Twitter : https://twitter.com/rajsoft8899
Linkedin : https://www.linkedin.com/in/raj-kumar-kushwaha-5a289219/
Facebook : https://www.facebook.com/rkushawaha

DBCS - Database Cloud Service Patching

Here in this article, I would summarize how easily we can do the "Database Cloud Service" patching online just via few clicks from the "Oracle Cloud Service Console".


Login to the Cloud Console and go to the DBCS instance page.

Click on the DBCS instance you want to patch, Instance Overview page opens. In my below example, there is a primary and standby Cloud instances.

At left side, click on the "Administration" tab, Patching page opens up which has list of all Available Patches for the underline DBCS instance.

Choose the right PSU Update and click on the right side hamburger sign, and click on Patch prechecks. Once you click on the pre-checks, it confirms if the patch is downloadable and /u01 mount on the DBCS instance host has enough free space available.

You can navigate through "Activity" tab to see the pre-check detail steps.

Once the pre-check completes, then initiates the actual patching job, it asks for the Patching Notes and choose whether you want to patch with "Switch-over" so there is no down-time.


The node hosting the standby database is patched first. A switchover operation is performed after patching is complete on the standby and then the patch is applied to the node hosting the new
standby.

If you want errors to be ignored during the patching operation, select the Force apply patch option. Then, click Patch.

Hope it helps, thanks for reading, please subscribe to this blog to stay updated with latest news on Oracle Cloud Infrastructure and Oracle Autonomous Database Cloud Services and new articles.

Twitter : https://twitter.com/rajsoft8899
Linkedin : https://www.linkedin.com/in/raj-kumar-kushwaha-5a289219/
Facebook : https://www.facebook.com/rkushawaha

Oracle Cloud Infrastructure Cloud Shell

One of the most awaited feature every Oracle Cloud Admin, developers were waiting for is now released by Oracle - Oracle Cloud Infrastructure "Cloud Shell". Cloud Shell is a web based browser terminal accessible from the Oracle Cloud console.

Cloud Shell provides Linux shell with a pre-authenticated OCI CLI. This feature is available for all Oracle Cloud users and accessible from console. 

Cloud Shell provides:

* An ephemeral machine to use as a host for a Linux shell, pre-configured with the latest version of the OCI Command Line Interface (CLI) and a number of useful tools

* 5GB of storage for your home directory

* A persistent frame of the Console which stays active as you navigate to different pages of the console

Following are the Tools Included With Cloud Shell:

Cloud Shell is a small Linux virtual machine. In addition to the OCI CLI, the Cloud Shell VM comes with current versions of several useful tools and utilities pre-installed, including:

> Git

> Java

> Python (2 and 3)

> SQL Plus

> kubectl

> helm

> maven

> gradle

> terraform

TO start the OCI Cloud Shell, you just have to click on Cloud Shell icon just left to the console notification bell icon at the right top.

 Once you click on the Cloud Shell, a small Linux virtual machine gets created that is equipped with latest oci cli and other various tools listed above and finally you are ready to interact with Oracle Cloud resources from the web-based terminal.

To allow a group of users to use the Cloud Shell, you need to create an IAM policy for this so that all users in that group can use it.

allow group group_name to use cloud-shell in tenancy

Hope it helps, thanks for reading, please subscribe to this blog to stay updated with latest news on Oracle Cloud Infrastructure and Oracle Autonomous Database Cloud Services and new articles.



Twitter : https://twitter.com/rajsoft8899
Linkedin : https://www.linkedin.com/in/raj-kumar-kushwaha-5a289219/
Facebook : https://www.facebook.com/rkushawaha

Oracle Cloud Infrastructure OS Management

Oracle Cloud Infrastructure OS Management service provides simple and very robust tool for general operation system maintenance activities for the compute instances running on Oracle Cloud OCI.

Using this OS management service, you can monitor the packages installed on compute instances, you can do the linux packages maintenance works i.e. adding/installing new packages, removing the existing packages or updating the existing one when that becomes available to its public yum repository.

OS management service is not enabled by default. It is an agent based service that you have to enable by installing osms-agent agent on the underline compute node.

All compute instances which has enabled osms-agent installed is called managed instance. You can manage the managed instances individually or you can group the managed instances and do the bulk maintenance but all the managed instances in the group must have same OS and version.

For detailed learning and understanding of the OS Management service - click here.