Sunday, December 4, 2016

Single Database High Available with Oracle Clusterware

It is interested thought to make a single (Multitenant) database High Available inside  the  Oracle Cluster environment. In most cases we make Application High available by making a resource  without predefined Cluster Resource Types. Instead every time create a full stack of settings we have now created a predefined type in which we have set the predefined attributes for the cluster resource to handle on. We have created a type which can be used multiple times by different resources with the same fingerprint.


Saturday, December 3, 2016

Introducing Oracle GoldenGate Studio 12.2.1

Learn Oracle Goldengate Studio 12.2.1. By Oracle University


Faster Goldengate Design and Deployments

Getting Started: My First Goldengate Studio Solution
by Oracle Learning Library

Wednesday, November 30, 2016

Introduction Oracle GoldenGate Veridata

Presentation of Oracle Goldengate Veridata

A Hands-On Lab from Oracle by Oracle fusion Middleware team

Monday, November 28, 2016

Goldengate Startup Articles

This blog reference to Oracle Goldengate Articles [ Ateam-Oracle]. 

Oracle GoldenGate provides real-time, log-based change data capture, and delivery between heterogeneous systems. Using this technology, it enables a cost-effective and low-impact real-time data integration and continuous availability solution. Oracle GoldenGate moves committed transactions with transaction integrity and minimal overhead on your existing infrastructure. The architecture supports multiple data replication topologies such as one-to-many, many-to-many, cascading, and bidirectional. Its wide variety of use cases includes real-time business intelligence; query offloading; zero-downtime upgrades and migrations; and active-active databases for data distribution, data synchronization, and high availability

Thursday, January 21, 2016

Multitenant Snapshot Copy using ZFSSA [Thin Database Cloning]

Starting with Oracle 12.1.0.1 it was also possible using snapshot clones with pluggable databases within the multitenant database architecture. It was limited to file systems that support sparseness and ACFS. With the first patch set 12.1.0.2 it’s possible to use direct NFS as well for snapshot copies.

Multitenant thin cloning can be managed on Oracle storage like ASM:ACFS and ZFSSA. Special thought here is not to use the clonedbparameter. This will force to use the thin cloning on database level instead the snap and clone technics inside the ZFSSA. For ZFSSA the snapshot copy command needs a key store keystore with the password of the ZFSSA server to communicate. The communication from the Database site is done with the executable ZFSSAADM which will be delivered with the Oracle software tree of the RDBMS. See my blog Using on ZFSSA:ZFSSAADM - Copy On Write (COW) on ZFS Storage Appliance (ZFSSA)

In this blog I will demonstrate and describes the steps to enable thin provisioning and instantaneous cloning features of Oracle Database 12c when it is deployed on Oracle ZFS Storage Appliance.

Thin Cloning of PDBs is a Snap with Oracle Storage

Preparations
  • Patch 18769809: MNTOPTS IN ORADISM NEEDS TO BE CORRECTED
  • Create an environment with ZFS Storage Appliance simulaton. 
  • Oracle Database environment 12c and Direct NFS. 
  • An operational multitenant CDB01 database.  
    • Important "Don’t use the init parameter CloneDB 

Tuesday, January 19, 2016

Forwarding SSH X-11 and magic cookies

On environments where Oracle or Grid accounts are access by sudo.
Then SSH X-11 forwarding and magic cookies are lost.

Here a simple trick that can be used tho solve this.

First login with your account and then execute:
xauth list