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
August 5th, 2013 
rishi –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
March 26th, 2013 rishi 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
March 3rd, 2013 rishi 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
March 1st, 2013 rishi 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
February 28th, 2013 rishi 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
oracle database upgrade from 10.2.0.3 to 10.2.0.5
February 9th, 2013 rishi 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” »»»»»
