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[…]

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[…]

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[…]

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[…]