Oracle Study Guide

install rlwrap (available from http://utopia.knoware.nl/~hlub/rlwrap/)

then add this to the bash_profile:

alias sqlplus=’rlwrap sqlplus’

alter system set log_archive_trace=7935;

This will cause lgwr and archN to write a bunch of stuff to the alert log.

Make sure the server hostname does NOT change. It will cause problems with all of the oracel services restarting!