Coloring alert.log Output via Tail and Less

Coloring alert.log Output via Tail and Less

To make my day-to-day job easier and more convenient, I like having some utilities and aliases. We, the DBA nation, need to look at the alert.log file frequently. So, basically, I did the following: Created a script to tail my alert.log file Colored the important words Added an alias to the script

read more »
Grid Autostart

Grid Autostart

Hi, Checking if the database resource is configured to restart automatically after reboot / shutdown of the host / cluster: $ crsctl stat res ora.fdb1.db -f |grep AUTO_START AUTO_START=restore Restore means that after restart

read more »
Axxana Shares Best Practices for Optimizing Disaster Recovery in Oracle 12c Environments

Axxana Shares Best Practices for Optimizing Disaster Recovery in Oracle 12c Environments

The Axxana Engineering team recently performed research to see which configurations provide the best performance in Oracle 12c disaster recovery environments. Alain Azagury, Axxana’s VP of R&D, reviewed highlights of this experimentation with colleagues at NoCOUG. The presentation, titled Squeezing the Max out of Oracle 12c Disaster Recovery, was very well received. We’re sharing the recording here so that others can take advantage of the findings.

read more »
3D Journey Inside Axxana’s Phoenix Black Box

3D Journey Inside Axxana’s Phoenix Black Box

If you’ve wondered about the nuts and bolts that set Axxana’s Phoenix Black Box apart from any other disaster recovery solution, now’s your chance to find out. Axxana’s new animated video provides an insider’s view of the extensive, multi-layered protection that Axxana employs to ensure zero data loss and rapid recovery in worst-case scenarios. It’s a thrilling, two-minute ride that will leave you convinced that Axxana has covered all the contingencies of disaster recovery.

read more »

Change Listener Ports in RAC Environment

Look at the current port configured for the scan_listener: $ srvctl config scan_listener SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521 SCAN Listener LISTENER_SCAN2 exists. Port: TCP:1521 SCAN Listener LISTENER_SCAN3 exists. Port: TCP:1521 $ lsnrctl status LISTENER_SCAN1 LSNRCTL for Solaris: Version 11.2.0.4.0 – Production on 01-JAN-20** 21:26:16 Copyright (c) 1991, 2013, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1))) STATUS of the LISTENER

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 »