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
| 
