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

SET ROWLIMIT in Oracle 18c

Sets a limit for the number of rows to display for a query. By default, ROWLIMIT is OFF. SET ROWLIMIT {n | OFF} n can be any number between 1 and 2,000,000,000. An error is displayed when the value that is entered is outside this range. OFF displays all the rows in the output. Example To set […]

Read More

Duplicating a PDB to an Existing CDB in Oracle 18c

Use the DUPLICATE command to duplicate a PDB to an existing CDB. To duplicate a PDB to an existing CDB: Ensure that the required prerequisites are met. Review the limitations of duplicating a PDB to an existing CDB Create the directories that store the duplicate database files on the destination CDB Establish Oracle net connectivity […]

Read More

createPluggableDatabase with DBCA in Oracle 18c

In this post, we can use createPluggableDatabase command creates a pluggable database (PDB) in a multitenant container database (CDB) with DBCA in Oracle 18c.

Let’s connect to the database and check the PDB is created or not.

In the next post, we can delete the PDB with DBCA in Oracle 18c. Stay tuned for more […]

Read More