Ashok tutorials

websites for Practice questions on AWS ----------------------------------------- 1. Whizlabs 2. ACG 3. Cloud Academy app (&day free trial on Questions)

[Note: This is for only Oracle Entriprise Edition( Not for Standard Edition)] Step 1:-   Add below lines: # visudo Comment below line: #Defaults    requiretty Add below line zabbix ALL=(ALL) NOPASSWD: ALL Step 2:-    Create sh files #vi /etc/zabbix/appliedlogs.sh sqlplus -s / as sysdba << EOF set echo off set heading off SELECT to_char(SEQUENCE#) FROM V\$LOG_HISTORY WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V\$LOG_HISTORY GROUP BY THREAD#) AND THREAD#=1; exit; EOF #  vi /etc/zabbix/receivedlogs.sh sqlplus -s / as sysdba << EOF set echo off set heading off SELECT to_char(SEQUENCE#) FROM V\$ARCHIVED_LOG WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V\$ARCHIVED_LOG GROUP BY THREAD#) AND THREAD#=1; exit; EOF        # vi /etc/zabbix/drloggap.sh sqlplus -s / as sysdba << EOF set echo off set heading off SELECT to_char((ARCH.SEQUENCE# - APPL.SEQUENCE#)) FROM (SELECT