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 […]
All posts by Skant Gupta
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 […]
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 […]
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 […]
Oracle Data Pump Changes in Oracle Database 18c
Oracle Data Pump, Export, and Import The Data Pump Import DATA_OPTIONS parameter has a new CONTINUE_LOAD_ON_FORMAT_ERROR option. If Data Pump encounters a stream format error when loading table data, Data Pump attempts to skip forward to find the start of the next row and continue loading that data from that location. For security purposes, Data […]
Oracle Database 18c Technical Architecture
This interactive diagram shows the Oracle Database 18c technical architecture. An Oracle Database consists of at least one database instance and one database. The database instance handles memory and processes. The database consists of physical files called data files, and can be a non-container database or a multitenant container database. An Oracle Database also uses […]
Apply Patch without shutting the Database
Most of the time, we can shut down the database and listener for patching the database home. But there is a method to apply the patch without shutting down the database and listener. Checking the database and listener running [oracle@oem 12834800]$ ps -ef|grep pmon oracle 16816 1 0 03:11 ? 00:00:00 ora_pmon_PROD4 oracle 18385 1 […]
Installing Oracle 18c Data Guard on Cloud
This article shows how to create Oracle 18c Data Guard in Oracle Database Cloud Service database deployment with simple steps. Create a New Instance of Oracle Data Guard Cloud Service Log in to your Oracle Cloud services account, go to the Oracle Database Cloud Service page, and create a new service:- For Instance Name enter DG18. – […]
Relink Oracle 12c Grid Infrastructure and RDBMS binaries.
In order to relink the Oracle Grid Infrastructure RAC/Cluster Installation, please follow the next steps after stopping all the services running: 1) As root OS user, please unlock the Grid Infrastructure Oracle Home (on every node) as follows: [root@RAC18C ~]# $ORACLE_HOME/crs/install/rootcrs.sh -unlock Using configuration parameter file: /u01/app/18.0.0.0/grid/crs/install/crsconfig_params The log of current session can be found […]
OPatch failed with error code 135 – Argument(s) Error… Given ‘ocmrf’ file does not exists
Issue Using opatch auto to apply patch 18706472, it failed with error code 135: opatchauto2017-09-23_04-21-57.log shows: 2017-09-23 04:24:41: s_run_as_user2: Running /bin/su oracle -c ‘ /oracle/product/11.2.0/db/OPatch/opatch napply /software_dump/latestpatch/18706472/18522509 -local -silent -ocmrf /home/grid/responsefile/file.rsp -oh /oracle/product/11.2.0/db -invPtrLoc /oracle/product/11.2.0/db/oraInst.loc ‘ 2017-09-23 04:24:42: Removing file /tmp/filexagz0g 2017-09-23 04:24:42: Successfully removed file: /tmp/filexagz0g 2014-09-23 04:24:42: /bin/su exited with rc=135 2017-09-23 04:24:42: […]