ora-02097 parameter cannot be modified because specified value is invalid

You might get ORA-02097 while changing PGA_AGGREGATE_LIMIT.

To set PGA_AGGREGATE_LIMIT we should take care of following allowable values : 2 GB (default value) 200% of the PGA_AGGREGATE_TARGET value 3 MB times the value of the PROCESSES parameter. Less then 1.2 X RAM – SGA Here In my case I am changing value according my […]

Read More

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:

2) As the Oracle Grid Infrastructure owner (on every node) relink the Grid Infrastructure Oracle Home […]

Read More

Oracle Database 18c and it’s features

Finally, Oracle officially released Oracle Database 18c with Oracle Documentation available on Oracle Public Cloud(OPC).  To get more detailed on Oracle 18c release read Oracle Support Document 2285040.1. List of some new features in Oracle 18c: Data Guard Oracle Data Guard Multi-Instance Redo Apply Supports Use of Block Change Tracking Files for RMAN Backups Automatic Correction […]

Read More

Fast Application Notification [FAN] overview

As the Oracle docs say, The Oracle RAC, FAN, Oracle 12c Fast Application Notification (FAN) feature provides a simplified API for accessing FAN events through a callback mechanism. This mechanism enables third-party drivers, connection pools, and containers to subscribe, receive and process FAN events. These APIs are referred to as Oracle RAC FAN APIs. If […]

Read More

Sosreport on Oracle Linux

The “sosreport” is a tool to collect troubleshooting data on an Oracle Linux system. It generates a compressed tarball of debugging information that gives an overview of the most important logs and configuration of a Linux system, to be sent to Oracle Support. Among other things, the sosreport includes information about the installed rpm versions, […]

Read More

TopicWise Interview Question on Oracle Database

Here is some Oracle Listeners Interview Question, hope it will help you. Listener Question: http://clouddba.co/generic-dba/ Here is some Oracle Tablespace  Interview Question, hope it will help you. Tablespace Question: http://clouddba.co/generic-dba/ Here is some Oracle EXPDP IMPDP Datapump Interview Question, hope it will help you. EXPDP IMPDP Datapump Question: http://clouddba.co/expdp-impdp-datapump-interview-questions/ Here is some Oracle Database Architecture Interview Question, hope it will help you. Database Architecture Question: http://clouddba.co/database-architecture-interview-questions/ […]

Read More

Types of Supplemental logging at Database level

Redo log files are generally used for instance recovery and media recovery. The data needed for such operations is automatically recorded in the redo log files. However, a redo-based application may require that additional column be logged in the redo log files. The process of logging these additional columns is called supplemental logging. There are two […]

Read More

Downgrading Grid Infrastructure from 12.1.0.2 to 11.2.0.4

In the last article, we performed downgrade of Oracle RAC Database from 12c to 11gR2. In this article, we are going to downgrade Oracle Grid Infrastructure from 12c (12.1.0.2) to 11gR2 (11.2.0.4) which contains two nodes ( node 1 & node 2). Before doing CRS downgrade we need to take backup of following files : Take tar […]

Read More

Downgrading a RAC database from 12.1.0.2 to 11.2.0.4

In the last article, we performed downgrade of Oracle Standalone Database from 12c to 11gR2. In this article, we can downgrade the 2 node RAC 12.1.0.2 database to 11.2.0.4, downgraded the database only and not the grid home. Assume all commands are being run on node 1, any commands that need to be run on node 2 […]

Read More

Downgrade Oracle Database from 12c to 11gR2

We have already upgraded Oracle Database11gR2 to 12c, the whole process is still relatively smooth, although some of the previous version of the upgrade is not the same, but the overall difficulty is not too large, because of too many different features, greatly extended the upgrade time. But for Oracle 12c back to the previous […]

Read More