Oracle Database Administration

REM * REM * PROGRAM:     rahc_sec_profiles.sql REM * USAGE:       @rahc_sec_profiles.sql REM * REM * LANGUAGE:    SQL*Plus REM * REM * DESCRIPTION: Check FND security profile REM *    Please pay attention in the following profile REM *        Sign-On:Audit Level                   (A=None,B=User,C=Responsibility,D=Forms) REM *        Sign-On:Notification                  Y/N        REM *        Signon Password Custom                        custom function to encrypt/decrypt pass...

DBMS_SCHEDULER set feedback off set echo off set lines 205 column owner format a15 column job_name format a22 column program_name format a24 column status format a10 column state format a10 column last_start format a25 column last_start_norm format a18 column "DURATION (d:hh:mm:ss)" format a21 column next_run format a25 column next_run_norm format a18 var local_offset number begin    select extract(timezone_hour from systimestamp) into :local_offset from dual; end; / select dsj.owner,        dsj.job_name,        dsj.program_name,        dsjlmax.status,        dsj.state, --     to_char(dsj.last_start_date,'dd-mon-yyyy hh24:mi TZH:TZM') last_start,        to_char(dsj.last_start_date + (:local_offset-extract(timezone_hour from dsj.last_start_date))/24,'dd-mon-yyyy hh24:mi') last_start_norm,       ...

http://dbawiki.wordpress.com/ Oracle logs clearing on Linux hosts 06 Aug Every two weeks on Linux hosts with Oracle RAC runs this script (/home/oracle/log_backup.sh). It deletes logs older 14 days from /u01/app/ folder. Archives big current log files (alert.log, listener.log) to folder /u01/app/oracle/log_backup/ and nullifies them. It runs every second and fourth friday of every month at 1:15 am through crontab. The script’s logs are in u01/app/oracle/log_backup/. cd /u01/app/oracle mkdir log_backup chmod 700 /home/oracle/log_backup.sh chmod 700 /home/oracle/mv_log_backup.sh #Runs every second and fourth friday of every month at 1:15 am. crontab -l crontab -e 15 1 8-14,22-28 * Fri /home/oracle/log_backup.sh >> /u01/app/oracle/log_backup/log_backup.log 2>&1 15 3 8-14,22-28 * Fri /home/oracle/mv_log_backup.sh #log_backup.sh #Deletes logs older 14 days from /u01/app/ folder. Archives big current log files. export timestamp=$( date +%d.%m....