Oracle script tutorials
Practical examples and useful tips.

The list of oracle script articles below will help you solve your technical problems
and show you tips and techniques to make your life easier.

I have used the Linux operating system for most scripts which have an OS component.

Some scripts are simple examples of how to do something quickly or practically
to make your daily DBA admin work easier.

Even though Oracle now has great GUI tools (dbcontrol, grid control) to make the life of the DBA easier,
there are still some tasks that need hands-on interaction.

I prefer to execute a task manually with a script until a GUI tool has proven itself where possible.

Once the GUI tool can do the job correctly, I will replace the script with the GUI tool.

Occasionally, a GUI tool will break with unclear errors,
and then it is good to know that you can quickly implement your old script to keep the environment
running until you figure out what is causing the problem with the GUI.

Another disadvantage of the GUI approach is that you do not learn what is happening in the background if you rely on the GUI too much.

If you are going to use GUI, make the most of the 'show sql' buttons that usually accompany the tool.

This way you will get the best of both worlds.
You get the job done quickly and you are broadening your knowledge base.


Articles list:

• Oracle ftp script
  Set up a script to ftp a series of files automatically.
  
• NFS Mount article
  Learn how to share a file system using nfs mount on linux.
  
• Compile oracle schema
  How to compile another Oracle user schema.
  
• Kill oracle processes
  How to kill Oracle processes which are keeping your shutdown from completing.
  
• Raise errors to the oracle alert log.
  Use this unsupported but useful package to log your user error code in the database's alert.log
  
• Track down a runaway server process, find its database twin session.
  Identify the oracle session whose shadow process is using excessive resources, with these 'Match os process to oracle session' instructions
  
• Open cursors
  Resolve ORA-01000: maximum open cursors exceeded
  
• VSFTPD
  How to install VSFTPD on your CentOS server, and stop and start it.
  
• AWR reports
  Follow the steps in these shell scripts to run AWR reports manually and mail them to yourself daily.
  
• Linux du command, get a meaningful result
  I always forget how to use this command to summarize disk space usage, so here is it in black-and-white..
  
• VNC Tutorial
  Quick guide to setting up the Free VNC server to enable you to use a 'remote desktop'-like interface on Unix.
  
• Kill Oracle process
  One line command to kill a number of processes without specifying process ids.
  

Recommended reading: