sqlplus -S scott/tiger <<EOF >$tempfile
set head off feed off verify off
select 'This account is LOCKED' from dual;
define exit_status = 0
col xs new_value exit_status
select username, account_status, 1 as xs from dba_users
where account_status = 'LOCKED'
and username in ('SCOTT','TEST_USER');
if [ $? = 0 ]
mailx -s "Account LOCK Check" $DBA1 < $tempfile
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
This post first appeared at Oracleinaction (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself).
I will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Why Shell Scripting?
Shell scripting is a powerful method of accessing UNIX systems and it is very flexible. Shell scripts are required when we want to execute a sequence of commands in Unix flavored operating systems. “Shell” is the command line i…