Tuesday, August 6, 2013

Listener not starting on Oracle 11g Transparent gateway server

Oracle transparent gateway is a product that can be used to access data from non-Oracle databases (eg. MS-SQL,DB2,etc), and even non-relational data sources.

Transparent Gateways are most commonly used and enable access to non-Oracle data sources as if they were Oracle databases. They allow you to interact with these foreign databases without regard to differences in SQL implementation and with the added ability to perform distributed processing.
Some of the available transparent gateways:
Microsoft SQL Server
Informix
Sybase
IBM DB2
IBM DB2/400
IBM DRDA
EDA SQL

Please see below link for solution:


Good luck !!!!

Create physical standby database using RMAN duplicate command from active database feature

This is new feature in Oracle 11g. We can create a standby database using RMAN duplicate command.

Please refer below link for step by step method:

http://onelineroracledba.blogspot.in/2013/06/standby-database-using-11g-rman.html

Good luck !!!!