Tip and Tricks to pass OCM exam

I wrote an exam on 9th and 10th Apr in India, After 17 long days, the result was out. Now officially I’ve successfully passed 11G OCM, Oracle Database 11g Certified Master Exam. It was almost more than 15 months that I’ve been preparing for this exam but actual preparation started almost 6 years back when I […]

Read More

Upgrade Grid Infrastructure to 18.2 by applying RU

Database 18c Patch As of the Release date (17-Apr-2018), the only Oracle Database 18 software that is available is 18.1.0 for on-premise Exadata. Therefore, the following patches for Oracle Database 18 are only for on-premise Exadata systems that are running Oracle Database 18.1.0. More Info: Database 18 Proactive Patch Information (Doc ID 2369376.1) OPatch Utility Information You must […]

Read More

Patching (or Updating) home and database to 18.2 from base release by applying RU

Database 18c Patch As of the Release date (17-Apr-2018), the only Oracle Database 18 software that is available is 18.1.0 for on-premise Exadata. Therefore, the following patches for Oracle Database 18 are only for on-premise Exadata systems that are running Oracle Database 18.1.0. More Info: Database 18 Proactive Patch Information (Doc ID 2369376.1) OPatch Utility Information […]

Read More

Evaluation and Prediction in Oracle RAC 12c

In a DBA’s routine, we perform thousands of command every day. Sometimes it also happens we don’t know the post-impact of the command. Then, Oracle 12c Comes up with very powerful feature WHAT IF EVALUATION. It shows us the impact of command without actually performing it. So with help of this our life can become […]

Read More

Manually Converting Non-RAC DB to RAC DB

In previous articles, we have seen various methods of converting Non-RAC database to RAC database. In this article, we will convert non-RAC database to RAC database using RMAN backup-restore utility. Single Instance DB Name RAC DB name RAC Instance Node RAC Instance Name RAC Node Name MGR MGR Node 1 db1 RAC1 Node 2 db2 […]

Read More

View All Rules with REST API in Oracle Cloud

The following example shows how to view detailed information about a Database Cloud Service instance by submitting a GET request on the REST endpoint using cURL. To know basic about RESTAPI In the last post, we created an access rule with RestApi. Now, in this post, we will see how to get the information about that […]

Read More

Enable an Access Rule with REST API in Oracle Cloud

The following example shows how to view detailed information about a Database Cloud Service instance by submitting a GET request on the REST endpoint using cURL. To know basic about RESTAPI In the last post, we created an access rule with RestApi. Now, in this post, we will see how to get the information about that […]

Read More

Create a Access Rule with REST API in Oracle Cloud

The following example shows how to view detailed information about a Database Cloud Service instance by submitting a GET request on the REST endpoint using cURL. To know basic about RESTAPI The following example shows how to create a rule by submitting a POST request on the REST endpoint using cURL. In this example, the […]

Read More

Restart a Service Instance with REST API in Oracle Cloud

The following example shows how to view detailed information about a Database Cloud Service instance by submitting a GET request on the REST endpoint using cURL. To know basic about RESTAPI The following example shows how to restart a Database Cloud Service instance by submitting a POST request on the REST endpoint using cURL. In […]

Read More

How to check the status of OMS and Agent in OEM 13cR2

We used 2 servers, one for the Database server and another one is for the management server. 10.237.1.207 em13c.localdomain em13c 10.237.2.107 host01.localdomain host01 To check the status of OMS, we can login to em server. eg10438 : [oracle@em13c ~]$emctl status oms Oracle Enterprise Manager Cloud Control 13c Release 2 Copyright (c) 1996, 2016 Oracle Corporation. […]

Read More