Friday, May 19, 2017

Oracle SQL Developer Command Line (SQLcl)

Oracle SQL Developer Command Line (SQLcl) is a free command line interface for Oracle Database. It allows you to interactively or batch execute SQL and PL/SQL. SQLcl provides in-line editing, statement completion, and command recall for a feature-rich experience,  all while also supporting your previously written SQL*Plus scripts

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 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 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