Oracle DBA Automation Quick Reference

Oracle DBA Automation Quick Reference

Authors: Charlie Russel, Robert Cordingley

Pages: 320

Publisher: Prentice Hall PTR

ISBN13: 9780131403017

The fast, practical Oracle 9i/10g automation reference for every DBA!

Automate Oracle—and save your time for more important tasks! This is the Oracle automation reference every working Oracle DBA needs...concise, straightforward, and incredibly easy to use. Discover proven solutions for automating installation, database creation, management, monitoring, tuning, backup/recovery, and more. Keep this book by your desk, near your server...wherever you need fast, reliable automation solutions right now!

Master scripting for both Oracle 9i and Oracle 10g!

Use Oracle Universal Installer to create response files for automating any installation

Use Oracle Network Configuration Assistant (NetCA) to configure network components during installation

Use Oracle Database Configuration Assistant (DBCA) to create and clone databases, and to reverse engineer them into templates and scripts

Manage files and tablespaces, tune memory, perform backup/recovery, schedule automated administration tasks, and more

Extend and customize any script to your own needs

Includes concise reference to Perl DBI and its Oracle-specific components—with real-world examples and syntax