Unix for Oracle DBAs Pocket Reference

Unix for Oracle DBAs Pocket Reference

by Donald K. Burleson
Released February 2001
Publisher(s): O'Reilly Media, Inc.
ISBN: 9780596000660

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Buy on Amazon Buy on ebooks.com
Start your free trial

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

    View/Submit Errata

    Table of contents

    1. Special Upgrade Offer
    2. A Note Regarding Supplemental Files
    3. 1. Unix for Oracle DBAs Pocket Reference
      1. 1.1. Introduction
        1. 1.1.1. Acknowledgments
        2. 1.1.2. Conventions Used in This Book
        3. 1.1.3. Long Code Lines
      2. 1.2. Understanding Unix
        1. 1.2.1. History
        2. 1.2.2. Case Sensitivity
        3. 1.2.3. Safety
        4. 1.2.4. Linkability
        5. 1.2.5. Shells
      3. 1.3. Building Unix Commands
        1. 1.3.1. Decompose a Complex Unix Command
        2. 1.3.2. Build a Complex Unix Command from Scratch
          1. 1.3.2.1. A script to kill all Oracle processes
          2. 1.3.2.2. A script to find all files containing a specific string
      4. 1.4. Unix Server Environment
        1. 1.4.1. Set a Standard Unix Prompt
        2. 1.4.2. Create Useful Unix Aliases for Oracle
        3. 1.4.3. Place a SQL*Plus Script in a Unix Shell Wrapper
        4. 1.4.4. Submit a Task to Run in the Background
        5. 1.4.5. Watch the Execution of a Background Process
        6. 1.4.6. Ensure That Proper Parameters Are Passed to an Oracle Shell Script
        7. 1.4.7. Ensure That Only the Oracle User Can Run a Script
        8. 1.4.8. Validate an Oracle SID Passed to a Unix Script
        9. 1.4.9. Loop Between Unix Servers
        10. 1.4.10. Execute a SQL*Plus Script on All Databases
        11. 1.4.11. Send Unix Files via Internet Mail
        12. 1.4.12. Change a String in All Files in a Directory
      5. 1.5. Process Management
        1. 1.5.1. Display Unix Processes
        2. 1.5.2. Display Top CPU Consumers
        3. 1.5.3. Show Number of Active Oracle Dedicated Connection Users
        4. 1.5.4. Kill Processes
        5. 1.5.5. Pin the Oracle SGA in Memory
      6. 1.6. Server Values
        1. 1.6.1. Display Server Device Values in HP-UX
        2. 1.6.2. Display Server Device Values in AIX
        3. 1.6.3. Display System Kernel Parameters in HP-UX
        4. 1.6.4. Display System Kernel Parameters in AIX
      7. 1.7. Memory and CPU Management
        1. 1.7.1. Display RAM Size in DEC Unix
        2. 1.7.2. Display RAM Size in HP-UX
        3. 1.7.3. Display RAM Size in Solaris
        4. 1.7.4. Display RAM Size in AIX
        5. 1.7.5. Use svmon in AIX
        6. 1.7.6. Display Allocated Memory Segments
        7. 1.7.7. Manually Deallocate a Memory Segment
        8. 1.7.8. Display the Number of CPUs
        9. 1.7.9. Display the number of CPUs in Solaris
      8. 1.8. Semaphore Management
        1. 1.8.1. Change Kernel Parameters
        2. 1.8.2. Display Values for Semaphores
        3. 1.8.3. Count Used Semaphores
        4. 1.8.4. Determine the Semaphore Sets Held by an Instance
        5. 1.8.5. Remove a Held Semaphore After a Crash
      9. 1.9. System Log Messages
        1. 1.9.1. Show Server Log in HP-UX
        2. 1.9.2. Show Server Log in AIX
      10. 1.10. Server Monitoring
        1. 1.10.1. Use top
        2. 1.10.2. Use sar
          1. 1.10.2.1. sar -u (CPU report)
          2. 1.10.2.2. sar -w (memory switching and swapping activity)
          3. 1.10.2.3. sar -b (buffer activity report)
        3. 1.10.3. Use sadc
        4. 1.10.4. Use vmstat
        5. 1.10.5. Automate vmstat Collection
          1. 1.10.5.1. cr_vmstat_tab.sql
          2. 1.10.5.2. get_vmstat.ksh
          3. 1.10.5.3. Sample vmstat report
        6. 1.10.6. Display Swap Usage in AIX
        7. 1.10.7. Display Swap Usage in HP-UX
        8. 1.10.8. Show Server Load Averages
        9. 1.10.9. Use iostat
        10. 1.10.10. Automate iostat Collection
          1. 1.10.10.1. cr_iostat_tab.sql
          2. 1.10.10.2. get_iostat.ksh
      11. 1.11. File Management
        1. 1.11.1. List Recently Touched Files
        2. 1.11.2. List Recently Changed Files
        3. 1.11.3. Delete Unchanged Files
        4. 1.11.4. Display File Sizes in 512-Byte Blocks
        5. 1.11.5. Locate Files That Contain Certain Strings
        6. 1.11.6. Find Recently Created Files
        7. 1.11.7. Find Large Files on a Server
        8. 1.11.8. Delete Files in Bulk
        9. 1.11.9. Delete Old Trace and Audit Files
        10. 1.11.10. Allocate an Empty File
        11. 1.11.11. Change Default File Permissions
          1. 1.11.11.1. Understand Unix file permissions
          2. 1.11.11.2. Find the systemwide default file permissions
          3. 1.11.11.3. Set default permissions for your session
        12. 1.11.12. Change File Ownership
        13. 1.11.13. Change File Permissions
      12. 1.12. Disk Management
        1. 1.12.1. List Logical Volumes in HP-UX
        2. 1.12.2. Display Unix Mount Points
          1. 1.12.2.1. Display mount points in HP-UX
          2. 1.12.2.2. Display mount points in AIX and Solaris
        3. 1.12.3. Manage Dialect Differences for Filesystems
        4. 1.12.4. Show Mount Points for a Physical Disk in AIX
      13. 1.13. Miscellaneous Shell Scripts
        1. 1.13.1. Create a Soft Link for a File
        2. 1.13.2. Make a Tape Backup Using tar
        3. 1.13.3. Copy tnsnames.ora to All Unix Servers
        4. 1.13.4. Test for a Dead Net8 Listener
        5. 1.13.5. Exit a Script When the Database Is Not Running
        6. 1.13.6. Detect When Oracle Is Not Accepting Connections
        7. 1.13.7. Mail ORA-600 Errors from the Alert Log to the DBA
        8. 1.13.8. Schedule Tasks with cron
          1. 1.13.8.1. View currently scheduled jobs
          2. 1.13.8.2. Schedule a new job
    4. Index
    5. Special Upgrade Offer
    6. Copyright

    Product information

    • Title: Unix for Oracle DBAs Pocket Reference
    • Author(s): Donald K. Burleson
    • Release date: February 2001
    • Publisher(s): O'Reilly Media, Inc.
    • ISBN: 9780596000660