LAMP & Oracle Technical Information

If you run the following script, you got an error sometimes.

This is using -e (existing a file check) that is working fine on individual files. This code works fine if the result is one file;
but if you have more files returned,  it fails with the following error:

line x: [: too many arguments

To run SQL*Plus, or any Oracle-supplied command, you must have several environment variables set.
You can set these environment variables automatically at login by editing your login script, or
you can use an environment variable script built, When you installed Oracle Database XE, the installer
creates two scripts that define the environment variables for you.

Environment Variable Script(Bourne, Korn, Bash):
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server

This is a sample backup script to keep the mysql dump for 3 days.

Example: