Monthly Archives: March 2018

How Axxana Improves Oracle Far Sync Performance

How Axxana Improves Oracle Far Sync Performance

Discussion on how to protect mission-critical applications and databases – without affecting performance – when using Axxana’s zero-data-loss Phoenix for Oracle Far Sync solution. https://attendee.gotowebinar.com/register/8406136219486430467

read more »
Starting the Oracle Data Guard Broker Observer in the Background

Starting the Oracle Data Guard Broker Observer in the Background

            Prior to Oracle 12.2, we had to find some homemade tricks to run the Observer in the background this way: $ nohup dgmgrl -silent sys/P@$$w0rd@prmy_db “start observer” & Finally, starting with Oracle 12.2, the Observer can run in the background using wallet authentication to connect to primary and standby databases and the Far Sync instance. For configuring the wallet, use the steps described in my post, Creating a wallet – secure external password store.

read more »
Log Mining a Redo Log File / Archive Log File on a Remote Database

Log Mining a Redo Log File / Archive Log File on a Remote Database

At the source site Enable the database to write to a directory you choose. In this example, I use /tmp: alter system set utl_file_dir=’/tmp’ scope=spfile;  Restart of the database is required in order for the parameter utl_file_dir to be active. Extract the LogMiner dictionary to a flat file called dictionary.ora: lEXECUTE DBMS_LOGMNR_D.BUILD(‘dictionary.ora’, ‘/tmp/’, DBMS_LOGMNR_D.STORE_IN_FLAT_FILE);  

read more »
Resolve tns Alias from the Database (DBMS_TNS.RESOLVE_TNSNAME)

Resolve tns Alias from the Database (DBMS_TNS.RESOLVE_TNSNAME)

When a given tns alias is not working via SQL*Plus, a database link, or within Data Guard, I traditionally troubleshoot connectivity via the tnsping utility—at first just to understand the target host, port, and service name. In Oracle 12.2, we have a new function called DBMS_TNS.RESOLVE_TNSNAME that enables us to query the return string as we receive it from tnsping.

read more »