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[…]
Oracle online patching a may impact OS/DB Performance
This article discusses the issue we faced during and oracle online patching on IBM AIX servers. What is the issue faced It is very simple. SQL plus connection to oracle database take about 2-3 seconds. No matter if it is a bequeath connection or listener connection. This issue surfaced when we tested Oracle Fusion MiddlewareRead more about Oracle online patching a may impact OS/DB Performance[…]
Grid Control 11.1.0.1 with 11.2.0.2 repository and SQL net security
Grid Control 11.1.0.1 with 11.2.0.2 repository has issue with SQL net security. You might see following message/errors logged to the repository alert log very frequently. You might see these error popping up in the target database alert log files as well. *********************************************************************** Fatal NI connect error 12170. VERSION INFORMATION: TNS for Linux: Version 11.2.0.2.0 –Read more about Grid Control 11.1.0.1 with 11.2.0.2 repository and SQL net security[…]
RMAN Backup and restore different Host
This posting is about restore and recover a database to different host. This procedure requires DBID of the original database. This is very usefully to copy a database to different datacenter. I mean to transporting using Disk/Tape/USB etc.. First step is to take a COLD backup of the source database. COLD BACKUP does not requireRead more about RMAN Backup and restore different Host[…]
Oracle Grid Control 11.1.0.1 Grid control Installation
This article is about installing Oracle Enterprise Manager 11g Release1 using an existing database. Grid Control 11g uses WebLogic Server instead of OC4J which was traditional with Grid Control versions 10.1 and 10.2; Grid Control 11g will deploy from an existing Weblogic Server during the Grid Control Installation. Hardware Requirements This is the extract fromRead more about Oracle Grid Control 11.1.0.1 Grid control Installation[…]