Oracle DBA Scripts and Tips
It has come to our attention that an Oracle Development company have
copied our scripts without our permission and are using them as part of
their own products for which they are charging users a license fee.
As a result of this, we have decided to suspend access to our DBA scripts
until further notice and we regret the impact that this decision will
inevitably have upon genuine users of the scripts repository.
We are continuing to monitor the situation and would encourage you to
check back in the future for developments.
Scripts sorted by Title
- Cold Database Backup ( Oracle : 8i 9i )
Shell Script : Retreives a list of all database files from the database whilst still running an Updated: 24-NOV-04
- Cold Database Backup ( Oracle : 7 8 )
Shell Script : Retreives a list of all database files from the database whilst still running an Updated: 08-JAN-02
- Create Database TEmplate ( Oracle : 7 8 )
Shell Script : Creates a database. You will need to edit this and enter you system tablespace d Updated: 26-OCT-98
- Create Database Template ( Oracle : 8i 9i )
Shell Script : Creates a database. You will need to edit this and enter you system tablespace d Updated: 18-APR-02
- Database Shutdown ( Oracle : 7 8 )
Shell Script : Simple database shutdown script. Gets the ORACLE_HOME from /etc/oratab. This scr Updated: 29-JUL-98
- Database Shutdown ( Oracle : 8i 9i 10g )
Shell Script : Simple database shutdown script. Gets the ORACLE_HOME from /etc/oratab. This scr Updated: 18-APR-02
- Database Size ( Oracle : 7 8 )
Shell Script : Displays physical size off all databases on a UNIX Machine. Updated: 08-JAN-02
- Database Size ( Oracle : 8i 9i )
Shell Script : Displays physical size off all databases on a UNIX Machine.
Updated: 03-APR-02
- Database Startup ( Oracle : 7 8 )
Shell Script : Simple database startup script. Gets the ORACLE_HOME from /etc/oratab. This scri Updated: 29-JUL-98
- Database Startup Script ( Oracle : 8i 9i 10g )
Shell Script : Simple database startup script. Gets the ORACLE_HOME from /etc/oratab. This scri Updated: 18-APR-04
- Display the Number Of CPUS ( Oracle : )
Shell Script : Display the number of CPUS in the major UNIX platforms Updated: 31-JAN-03
- Full Database Export ( Oracle : 7 8 8i 9i )
Shell Script : Full database export and compress using named pipes. Use the full database impor Updated: 29-JUL-98
- Full Database Import ( Oracle : 7 8 8i 9i )
Shell Script : Full database import and uncompress using named pipes.You will need this if you Updated: 24-MAY-99
- Hot Database Backup ( Oracle : 7 8 )
Shell Script : Generates SQL script put the tablespace in backup mode and to do a unix copy to Updated: 29-JUL-98
- Hot Database Backup ( Oracle : 8i 9i )
Shell Script : Generates SQL script put the tablespace in backup mode and to do a unix copy to Updated: 13-SEP-02
- Set Database ARCHIVELOG Mode ( Oracle : 7 8 )
Shell Script : Shut database down and sets the database in Archive Log Mode.
This script us Updated: 29-JUL-98
- Set Database ARCHVELOG Mode ( Oracle : 8i 9i )
Shell Script : Shut database down and sets the database in Archive Log Mode. Updated: 18-APR-02
- Show Installed Oracle Version ( Oracle : 7 8 8i )
Shell Script : This script will list out all Oracle products installed by the last Oracle insta Updated: 08-OCT-02
- Solaris Memory Calculation ( Oracle : )
Shell Script : Gives actual memory usage of Oracle from a Solaris Operating System using the 'p Updated: 28-FEB-02
- Standby Database Gap Detection Script. ( Oracle : 8i )
Shell Script : Detects if a standby database is up to date. Send an OEM alert is not.
Script Updated: 02-JUN-05
|
Site Map
General Information :
Home | Company Profile
| Contact Us | Legal
Database Support :
Proactive Support
|
Pay Per Incident Support
Expert Services :
High Availability
|
Creative Solutions
|
Training
Build Services :
Oracle Installations
|
Revive your Oracle Setup
|
Low Cost Development
Free Oracle Resources:
DBA Scripts
|
Oracle Links
|