Book description
The Unix for Oracle DBAs Pocket Reference puts within easyreach the commands that Oracle database administrators need mostwhen operating in a Unix environment. If you are an Oracle DBAmoving to Unix from another environment such as Windows NT or IBMMainframe, you know that these commands are far different fromthose covered in most beginning Unix books. To jump start yourlearning process, Don Burleson has gathered together in thissuccinct book the Unix commands he most often uses when managingOracle databases. You'll be able to reach into your pocket for theanswer when you need to know how to:
Display all Unix components related to Oracle,identify the top CPU consumers on your server, and even killprocesses when necessary
Stack Unix commands into powerful scripts that canperform vital DBA functions
Monitor Unix filesystems, and automatically manageyour trace files, dump files, and archived redo log files
Use essential server monitoring commands such astop, sar, and vmstat
And there's much more between these covers. If you need to get upto speed with Oracle on Unix, and quickly, this book is for you.
Publisher resources
Table of contents
- Special Upgrade Offer
- A Note Regarding Supplemental Files
-
1. Unix for Oracle DBAs Pocket Reference
- 1.1. Introduction
- 1.2. Understanding Unix
- 1.3. Building Unix Commands
-
1.4. Unix Server Environment
- 1.4.1. Set a Standard Unix Prompt
- 1.4.2. Create Useful Unix Aliases for Oracle
- 1.4.3. Place a SQL*Plus Script in a Unix Shell Wrapper
- 1.4.4. Submit a Task to Run in the Background
- 1.4.5. Watch the Execution of a Background Process
- 1.4.6. Ensure That Proper Parameters Are Passed to an Oracle Shell Script
- 1.4.7. Ensure That Only the Oracle User Can Run a Script
- 1.4.8. Validate an Oracle SID Passed to a Unix Script
- 1.4.9. Loop Between Unix Servers
- 1.4.10. Execute a SQL*Plus Script on All Databases
- 1.4.11. Send Unix Files via Internet Mail
- 1.4.12. Change a String in All Files in a Directory
- 1.5. Process Management
- 1.6. Server Values
-
1.7. Memory and CPU Management
- 1.7.1. Display RAM Size in DEC Unix
- 1.7.2. Display RAM Size in HP-UX
- 1.7.3. Display RAM Size in Solaris
- 1.7.4. Display RAM Size in AIX
- 1.7.5. Use svmon in AIX
- 1.7.6. Display Allocated Memory Segments
- 1.7.7. Manually Deallocate a Memory Segment
- 1.7.8. Display the Number of CPUs
- 1.7.9. Display the number of CPUs in Solaris
- 1.8. Semaphore Management
- 1.9. System Log Messages
- 1.10. Server Monitoring
-
1.11. File Management
- 1.11.1. List Recently Touched Files
- 1.11.2. List Recently Changed Files
- 1.11.3. Delete Unchanged Files
- 1.11.4. Display File Sizes in 512-Byte Blocks
- 1.11.5. Locate Files That Contain Certain Strings
- 1.11.6. Find Recently Created Files
- 1.11.7. Find Large Files on a Server
- 1.11.8. Delete Files in Bulk
- 1.11.9. Delete Old Trace and Audit Files
- 1.11.10. Allocate an Empty File
- 1.11.11. Change Default File Permissions
- 1.11.12. Change File Ownership
- 1.11.13. Change File Permissions
- 1.12. Disk Management
-
1.13. Miscellaneous Shell Scripts
- 1.13.1. Create a Soft Link for a File
- 1.13.2. Make a Tape Backup Using tar
- 1.13.3. Copy tnsnames.ora to All Unix Servers
- 1.13.4. Test for a Dead Net8 Listener
- 1.13.5. Exit a Script When the Database Is Not Running
- 1.13.6. Detect When Oracle Is Not Accepting Connections
- 1.13.7. Mail ORA-600 Errors from the Alert Log to the DBA
- 1.13.8. Schedule Tasks with cron
- Index
- Special Upgrade Offer
- Copyright
Product information
- Title: Unix for Oracle DBAs Pocket Reference
- Author(s):
- Release date: February 2001
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9780596000660
You might also like
book
Oracle SQL*Plus Pocket Reference, 3rd Edition
The Oracle SQL is a must-have for anyone working with Oracle databases, especially those looking to …
book
Linux and Solaris Recipes for Oracle DBAs, Second Edition
Linux and Solaris Recipes for Oracle DBAs, 2nd Edition is an example–based book on managing Oracle …
book
Oracle RMAN Pocket Reference
Oracle RMAN Pocket Reference is a handy guide for DBAs who intend to use Oracle Recovery …
book
Perl for Oracle DBAs
Perl is a very powerful tool for Oracle database administrators, but too few DBAs realize how …