Monthly Archives: December 2017

Far Sync for Oracle 12.1 – Best Practices

Far Sync for Oracle 12.1 – Best Practices

This post is a continuation of my post, Using Standby as an Alternate for Far Sync (12c): Limitations and Considerations. It is for database administrators who want to set up Far Sync for the first time. Creating a Far Sync instance requires a number of manual steps and there are many parameters to consider or set. The Axxana team recently ran numerous scenarios using Oracle™ Active Data Guard with a Far Sync instance. Our goals were to: Check Far Sync functionality and reliability Validate that Far Sync has a low footprint under heavy load

read more »
Data Guard – Changing IP Addresses

Data Guard – Changing IP Addresses

          Hi, When changing IP address of a host, we should update/recheck the following places: /etc/hosts or DNS listener.ora tnsnames.ora Database parameters (local_listener, remote_listener) Data Guard configuration This document is also relevant when changing the IP address of the connection between the hosts, other than the original IP addresses we used during the installation. When installation is done using the hostname and not the IP address, most of the changes are not relevant except for /etc/hosts. In this document, I will describe how to change the Data Guard Broker configuration.

read more »
Oracle Connection Manager

Oracle Connection Manager

  Connection manager is working as oracle SQL*NET proxy and firewall. In this example, I am using Connection Manager of Oracle Database 12c Release 2 running on Linux x86_64 Footprint Storage: 1.7 G Memory: 5~28.4 MB Requires: Installation of Oracle Client in a separated folder than the database software Register the connection manager in the grid infrastructure as a cluster resource

read more »
On the Road

On the Road

Reflections from the Road We’ve participated in a number of dynamic conferences this fall and want to share some of our key takeaways from those events. Oracle Open World 2017 As always, OOW was a lot of fun, with even higher attendance than previous years. Some of our product managers and chief architects were at the conference, which gave us a chance to share our roadmap with our customers.

read more »
Creating Far Sync instance step by step

Creating Far Sync instance step by step

            These are the steps of creating Far Sync instance in the command line: ·  Create 12.1 primary db ·  Create 12.1 physical standby ·  Create regular standby DG broker configuration ·  modify network file (on primary and standby) and add entries for the far_sync instance, add to tnsnames.ora on Primary hosts and standby hosts:

read more »
Axxana’s Phoenix Black Box – Behind the Scenes

Axxana’s Phoenix Black Box – Behind the Scenes

If you ask somebody, what’s a “Black Box,” you would probably hear, “It’s that indestructible flight recorder used on airplanes that can help determine what happened in a plane crash.” Another answer, from computer-science folks, would be “It’s a box with known input and output, but you don’t care how it does the work inside.”

read more »