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

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.

To check the status of OMS, we can login to em server.

To get more details about port and URL, then we can use -details in status command.

How to check the status of Agent […]

Read More

CDB Fleets in Oracle 18c

A lead CDB is the central location for monitoring and managing the CDBs in the fleet. A CDB fleet provides the database infrastructure for scalability and centralized management of many CDBs. Designate one CDB in the fleet to be the lead CDB by setting its LEAD_CDB database property to TRUE. The other CDBs in the […]

Read More

ORA-65179 PDB in Oracle 12c

While dropping the PDB, we receive the error like cannot keep datafiles for a pluggable database that is not unplugged.

Solution:

Thank you for giving your valuable time to read the above information. If you want to be updated with all our articles send us the Invitation or Follow us: Telegram Channel: https://t.me/helporacle Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/ […]

Read More