Oracle 19c has upgraded some of the minimum requirements such as the operating system distribution, packages, and other software requirements for Oracle Grid Infrastructure installation. A default Linux installation includes most of the required packages and helps you limit manual verification of package dependencies. Oracle does not support Leaf nodes in 19c. In Oracle Grid Infrastructure 19cRead more about Oracle 19c RAC (Grid Infrastructure) Installation.[…]
Rollback Segment Count settings in Oracle Database
One caveat of altering _rollback_segment_count to a higher value and reducing is that Oracle will never drop/remove newly created rollback segments. The segments will be OFFLINE after you restart the database. I just did some experiments with _rollback_segment_count in Primary/Standby environment. From Primary, we can see _rollback_segment_count is set to 0 and 11 rollback segmentsRead more about Rollback Segment Count settings in Oracle Database[…]
RAC node not joining cluster – Grid Interprocess Communication (GIPC)
GIPC is daemon used for inter-process communication between the nodes. This also support Redundant Interconnect Usage. GIPC Daemon (gipcd.bin)has an end point ‘gipcha://nodename:xxx’. You can see this in the below log entry. 2019-03-14 23:26:56.429 : GIPCGEN:718243584: gipcRequestSaveInfo: client took long time 2300 ms for consuming request 0x7fbc2407e530 [000000001b23a413] { gipcReceiveRequest : peerName ‘gipcha://stone:nm2_primcluster/ed1f-1959-1be4-9d99’, data 0x7fbc24092df8,Read more about RAC node not joining cluster – Grid Interprocess Communication (GIPC)[…]
Oracle Standby Redo Transport SYNC mode Tracing
Standby database is replica of Primary database synchronized using redo log (archived redo log). Redo log generated in Primary is send to standby depending upon transport settings in primary. It can be send using Log Write or Archiver process. There are 3 Dataguard protection modes. They are Maximum Availability, Maximum Performance and Maximum Protection. InRead more about Oracle Standby Redo Transport SYNC mode Tracing[…]
Rolling Upgrade Oracle 11.2.0.2 database to Oracle 12.1.0.2 using Standby with No Downtime
It is possible to use Standby database to upgrade a database with near no downtime. Application may experience a failover/switchover but no real downtime window that really interrupt the continued availability of application. This is using Oracle Logical standby feature as that allows application to connect to the database with read/write capability. This is no-RACRead more about Rolling Upgrade Oracle 11.2.0.2 database to Oracle 12.1.0.2 using Standby with No Downtime[…]
Oracle Dictionary Corruption and Ways to Analyze the Issue
Oracle Dictionary corruption can lead to various errors and database/instance crash. Some of the dictionary corruption may not be fatal and it may throw error only when a DML or DDL is attempted on the corrupted object. Here I am going through an ORA-600 error is raised when drop is attempted on a table. ORA-00600:Read more about Oracle Dictionary Corruption and Ways to Analyze the Issue[…]
RAC Hang Manager – A New Feature
Oracle Hang Manager is to reliably detect, if hang resolution is enabled, resolve hangs in a timely manner. Over various releases, Hang Manager has been enhanced along with the wait event infrastructure on which it relies. However, it is only in 11.2.0.2 that Hang Manager actually resolves any hangs by terminating sessions and/or processes. ThisRead more about RAC Hang Manager – A New Feature[…]
Step by Step oracle 11gR2 Physical Standby database setup
This article steps through the process of creating a physical standby database using RMAN from a live database. Preparing the primary database for standby environment Enable Force logging It is required to place the primary database in FORCE LOGGING mode after database creation. This makes the Oracle Database to force writing of redo records evenRead more about Step by Step oracle 11gR2 Physical Standby database setup[…]
Upgrading Oracle Databases from 11.2.0.1 to 11.2.0.2
This discussion is about performing an upgrade from 11.2.0.1 databases to 11.2.0.2. This is an out-of-place manual upgrade from 11.2.0.1 to 11.2.0.2. 11.2.0.2 Patch set is a full release. It cannot be installed on top of existing 11.2.0.1 ORACLE_HOME. Note the following steps 1. Install 11.2.0.2 into a separate ORACLE_HOME. 2. Take a full backupRead more about Upgrading Oracle Databases from 11.2.0.1 to 11.2.0.2[…]
A Peek into the SQL with most Redo Log Generation
I recently came across a situation in my stage database where a new third party application was getting deployed. The issue was with the amount of redo log generated in a day. The whole database was just 40G and it was generating about 300G of redo log per day. This made me to think moreRead more about A Peek into the SQL with most Redo Log Generation[…]