Installation of EBS 12.2 Vision instance

Step-by-step installation of an EBS 12.2 Vision instance

Prerequisites:

Hardware:

2 CPU Cores

8 GB RAM

HDD: 10-12 GB (root+swap)

          40 Gb for s/w staging area

Continue reading “Installation of EBS 12.2 Vision instance” »»»»»

Oracle Gateway for Oracle & Mysql ODBC Connection

–Demo for Oracle Gateway ODBC connection between Oracle & Mysql

Prerequisites:-

Machine: X86_64 bit

OS: RHEL 6.4

Database: Oracle 11.2.0.3.0 , & MySql 5.5.27 RPM

Gateway:  linux.x64_11gR2_gateways.zip

Mysql Connector/ UnixODBC driver: mysql-connector-odbc-5.2.5-1.ansi.el6.x86_64.rpm

ODBC driver manager: unixODBC-2.2.14-12.el6_3.x86_64 RPM

–Follow below steps for Oracle Gateway ODBC connection between Oracle & Mysql:

 

Continue reading “Oracle Gateway for Oracle & Mysql ODBC Connection” »»»»»

TAF (Transparent Application Failover) for Data Guard

TAF (Transparent Application Failover) for Data Guard:

Below implementation will be continued after DG broker configuration.

To know DG broker configuration, go to below link:

http://oracledbahub.com/2013/02/dg-broker-configuration/

 

Continue reading “TAF (Transparent Application Failover) for Data Guard” »»»»»

ORA-16826: apply service state is inconsistent with the DelayMins property

DGMGRL> show configuration;

Configuration – cobra

Protection Mode: MaxAvailability

  Databases:
    cobra    – Primary database
    cobradup – (*) Physical standby database
      Warning: ORA-16826: apply service state is inconsistent with the DelayMins property

Continue reading “ORA-16826: apply service state is inconsistent with the DelayMins property” »»»»»

Convert Physical Standby to Snapshot Standby

Snapshot Standby:-  Oracle indroduces Snapshot standby database feature in Datagurad 11g. where one can convert a Physical standby database(Read-Only) to a Snapshot Standby(Read/Write) in READ/WRITE mode and make any DDL/DML operation further and once the Testing purpose is completed, you can resyncronize your database as physical standby back.

Convert a Physical Standby to Snapshot Standby with SQL*Plus

Check that  Flashback feature is enabled/disabled
If that is not enabled, perform the following steps to enable flashback on both  database(standby & primary) :

Set (if needed) the db_recovery parameters on both database(standby & primary)  

–On Primary
SQL> show parameters db_recovery;

Continue reading “Convert Physical Standby to Snapshot Standby” »»»»»

DG Broker Configuration

Data Guard Broker Configuration With failover and Switchover:

Setup DG Broker

Primary: cobra

Standby: cobradup

–In below steps above two are used as primary and standby databases.

Enable Data Guard Broker Start on the Primary and Standby databases

Continue reading “DG Broker Configuration” »»»»»

oracle database upgrade from 10.2.0.3 to 10.2.0.5

Upgrade From 10.2.0.3 to 10.2.0.5

On Standalone Machine (Non RAC):

 Step1. Take full backup.(You can choose your own way to take full backup, below script will take full backup through RMAN)

Export ORACLE_SID=kpdb

Continue reading “oracle database upgrade from 10.2.0.3 to 10.2.0.5” »»»»»