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 […]
Monthly Archives: March 2018
How to Check/Validate That RMAN Backups Are Good
From today’s post, I am going to remind you all about those colleges day when we used to learn about the validation in programming languages. In daily life are aware of validation. In the database world, it is little different. Let’s have look at the types of validation in general terms. Some of […]
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 […]
Installing Oracle Database Using RPM Packages in Oracle 18c
Starting with Oracle Database 18c, you can use the Oracle Preinstallation RPM and the rpm -ivh command to perform an RPM-based single-instance Oracle Database or Oracle Database Client installation. Note: An RPM-based Oracle Database installation is supported only on Oracle Linux systems. Use RPM packages to perform a single-instance, Oracle Database installation on Oracle Linux […]
Fast Application Notification[FAN] Events
In previous articles we have seen FAN overview Fast Application Notification [FAN] overview and benefits of using FAN In this article we will see supported event types of FAN. Node Down : This event notifies that node is not reachable.The Cluster sends this event when a node is no longer able to accept work. Service Up: […]
Connection Load Balancing in Oracle RAC
Load balancing means “to distribute load among multiple entities”. In Oracle RAC ,Load Balancing feature is very well maintained. Load is distributed among all instance. However we need to take care of some things , like creating service based on group of users connecting database.Assigning number of backup instance if service fails on preferred instance […]
Convert Single Instance Database to RAC Database using RCONFIG
In Previous article we learned about overview of RCONFIG . In this Article we will see Conversion of Single Instance DB to RAC DB with RCONFIG Prerequisites : Single Instance DB Name RAC DB name RAC Instance Node RAC Instance Name RAC Node Name test TEST Node 1 db1 RAC1 Node 2 db2 RAC2 Step […]
RCONFIG overview
RCONFIG is a non interactive command line utility for converting a Single-Instance database to RAC database.It is installed by default as a executable file under $GRID_HOME/bin and $ORACLE_HOME/bin. It takes XML file as input and process the conversion procedure. Benefits of using RCONFIG : It’s very light and easy to use utility for conversion of Single Instance database […]
ora-02097 parameter cannot be modified because specified value is invalid
You might get ORA-02097 while changing PGA_AGGREGATE_LIMIT. SQL> show parameter PGA_AGGREGATE_LIMIT NAME TYPE VALUE ———————————— ——————————– —————————— pga_aggregate_limit big integer 2G SQL> SQL> alter system set PGA_AGGREGATE_LIMIT=5G scope=both; alter system set PGA_AGGREGATE_LIMIT=5G scope=both * ERROR at line 1: ORA-02097: parameter cannot be modified because specified value is invalid ORA-00093: pga_aggregate_limit must be between 6000M and […]