Bulk File Edit
- This script will go through each file with the *.dat extension in a directory and fill the 3rd pattern "<>" in the line that contains a specified directory, with a specified path.
new
(Added: 5-Aug-2009 Hits: 0 Rating: 0 Votes: 0) Rate It
Check_alertlog
- This Script search for Oracle error messages in last 100 lines in the alert log file , send a email message to concerned and keep log to a file.
You should pass name of ORACLE_SID as a parameter.
for eg: Ck_alerlog FINL
pop
(Added: 7-Jul-2000 Hits: 16334 Rating: 5.04 Votes: 20) Rate It
Oracle Database, Listener and Names Server Monitor
- Monitor the status of the Oracle database, listener, names server can be added in the cron to be executed on regulary basis.
pop
(Added: 23-Aug-1999 Hits: 15515 Rating: 6.22 Votes: 22) Rate It
BEFORE APPEND
- This script will insert a message into a specific line of multiple files.
(Added: 1-Oct-2008 Hits: 1989 Rating: 0 Votes: 0) Rate It
Beyond Find
- Delete all the files from the temporary directory, leaving only the recently created last 4 files.
(Added: 9-Feb-2007 Hits: 4482 Rating: 10.00 Votes: 1) Rate It
Estimate Space Utilization Script
- This script queries your database for tablespaces and estimates their space utilization like allocated space, used space, free space available and percentage of used space. The script can also search if %used space is more than 80, send an email to concerned, and log details to a file.
(Added: 30-Nov-2001 Hits: 7678 Rating: 6.33 Votes: 3) Rate It
Login Script
- As an Oracle DBA, I connect to several databases. During login to a database running on a UNIX operating system, these steps are inevitable.
export ORACLE_SID=jiwa
sqlplus /nolog
connect /as sysdba
This script simplifies these steps by taking the ORACLE_SID arguement to connect to the database.
(Added: 16-Mar-2009 Hits: 367 Rating: 0 Votes: 0) Rate It
pidinfo for unix
- Script to find parents and descendants of a given process id.
Puts arrow on pid given as argument parents and descendants of given process id are shown in proper order and indented for readability
(Added: 25-Aug-2003 Hits: 4445 Rating: 10.00 Votes: 3) Rate It
Unix script for performing repetitive jobs
- Unix script/ Awk command for performing repetitive jobs, like creating directories from u01 u99 on an unix server.
(Added: 12-Sep-2006 Hits: 3658 Rating: 0 Votes: 0) Rate It