version 1.0.0, 2014-06-25 : Initial version
Getting log_mode of multiple databases
This little shell schript will provide the log_mode of all the databases of the linux/Unix server that are registered in the oratab file.It is supposed to be running in an sh or ksh environement.
Tested on AIX, Solaris and linux.
for oratab_path in /etc/oratab /var/opt/oracle/oratab ; do
if [ -f $oratab_path ]; then
export ORAENV_ASK=NO
for instance in $(awk -F: '/^[^#]/ {print $1}' $oratab_path); do
export ORACLE_SID=$instance
. oraenv > /dev/null
${ORACLE_HOME}/bin/sqlplus -S /nolog << __EOF__
connect / as sysdba;
set head off;
set lines 200 pages 1024;
select name, log_mode from v\$database;
__EOF__
done
export ORAENV_ASK=YES
fi
done | grep -v '^\s*$' | sort