deletePluggableDatabase with DBCA in Oracle 18c

In this post, we can use deletePluggableDatabase 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 deleted or not.

Stay tuned for more articles on Oracle 18c  Thank you for giving your valuable time to read the […]

Read More

createDuplicateDB with DBCA in Oracle 18c

We can use createDuplicateDB command duplicates a database with DBCA in Oracle 18c. Syntax and Parameters Use the dbca -createDuplicateDB command with the following syntax:

For creating the duplicate database, our primary database must be in archive log, otherwise we will get an error.

Run the following command to create a duplicate database.

Stay tuned for more […]

Read More

executePrereqs with DBCA in Oracle 18c

The executePrereqs command executes the prerequisites checks and reports the results. This command can be used to check the environment before running dbca to create a database. Syntax and Parameters Use the dbca –executePrereqs command with the following syntax:

Run the DBCA with executePrereqs

Stay tuned for more articles on Oracle 18c  Thank you […]

Read More

Shadow Tablespaces in Oracle 18c

A shadow tablespace is a bigfile tablespace intended for shadow lost write protection. Purpose of Shadow Tablespaces Shadow lost write protection provides fast detection and immediate response to a lost write. A data block lost write occurs when an I/O subsystem acknowledges the completion of the block write even though the writers did not occur or when a former […]

Read More

Image-Based Oracle Database Installation in Oracle 18c

Starting with Oracle Database 18c, installation and configuration of Oracle Database software are simplified with the image-based installation. To install Oracle Database, create the new Oracle home directory, extract the image file into the newly-created Oracle home, and run the setup wizard to register the Oracle Database product. Using image-based installation, you can install and […]

Read More

View 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 In last post, we created an instance with RestApi. Now, in this post, we will see how to get the information about that instance. […]

Read More

Create a Service Instance with REST API in Oracle Cloud

The following example shows how to create a Database Cloud Service instance by submitting a POST request on the REST endpoint using cURL. To know basic about RESTAPI In this example, the identity domain is “idcs-bac676f0a2c643a281868616b45986da” and the Oracle Cloud user name and password are “clouduser” and “Pa$$word“. The request body specifies the creation of a service instance named […]

Read More

Delete a Service Instance with REST API in Oracle Cloud

The following example shows how to delete a Database Cloud Service instance by submitting a DELETE request on the REST endpoint using cURL. To know basic about RESTAPI In this example, the identity domain is “idcs-bac676f0a2c643a281868616b45986da” and the Oracle Cloud user name and password are “clouduser” and “Pa$$word“. The service instance being deleted is named […]

Read More

View All Service Instances with REST API in Oracle Cloud

The following example shows how to view information about all Database Cloud Service instances by submitting a GET request on the REST endpoint using cURL. To know basic about RESTAPI In this example, the identity domain is “idcs-bac676f0a2c643a281868616b45986da” and the Oracle Cloud user name and password are “clouduser” and “Pa$$word“. The response shows two running […]

Read More

Cancel Session in Oracle 18c

As of Oracle 18c , you can not only abort a database session, but also just a single SQL command. This tip shows how it works. There are situations where the execution of SQL commands takes too long and there is a desire to cancel them. Be it because the SQL command is incorrect, or […]

Read More