About the Technical Reviewer
by Bernard Lopuz, Charles Kim, Darl Kuhn
Linux and Solaris Recipes for Oracle DBAs, Second Edition
- Cover
- Title
- Copyright
- Dedication
- Contents at a Glance
- Contents
- About the Authors
- About the Technical Reviewer
- Acknowledgments
- Introduction
- Chapter 1: Getting Started
- Chapter 2: Working in the Shell
- 2-1. Displaying the Current Shell
- 2-2. Running Previously Entered Commands
- 2-3. Automatically Completing Long Commands
- 2-4. Viewing Environment Variables
- 2-5. Automatically Setting Shell Variables
- 2-6. Customizing the Command Prompt
- 2-7. Creating a Command Shortcut
- 2-8. Providing Input to Commands
- 2-9. Redirecting Command Output
- 2-10. Sending Output to Nowhere
- 2-11. Displaying and Capturing Command Output
- 2-12. Recording All Shell Command Output
- 2-13. Changing the Login Shell
- 2-14. Modifying Command Path Search
- 2-15. Viewing Built-in Commands
- 2-16. Setting the Backspace Key
- 2-17. Typing a Long Command in Multiple Lines
- Chapter 3: Managing Processes and Users
- 3-1. Listing Processes
- 3-2. Terminating Processes
- 3-3. Listing the Users Logged On
- 3-4. Listing the Last Logon Time of a User
- 3-5. Limiting the Number of User Processes
- 3-6. Viewing How Long the Server Has Been Running
- 3-7. Viewing How Long a Process Has Been Running
- 3-8. Displaying Your Username
- 3-9. Changing Your Password
- 3-10. Becoming the System Privileged (root) User
- 3-11. Running Commands as the root User
- 3-12. Adding a Group
- 3-13. Removing a Group
- 3-14. Adding a User
- 3-15. Removing a User
- Chapter 4: Creating and Editing Files
- 4-1. Creating a File
- 4-2. Maneuvering Within a File
- 4-3. Copying and Pasting
- 4-4. Manipulating Text
- 4-5. Searching for and Replacing Text
- 4-6. Inserting One File into Another
- 4-7. Joining Lines
- 4-8. Running Operating System Commands
- 4-9. Repeating a Command
- 4-10. Undoing a Command
- 4-11. Displaying Line Numbers
- 4-12. Automatically Configuring Settings
- 4-13. Creating Shortcuts for Commands
- 4-14. Setting the Shell Default Text Editor
- 4-15. Setting the SQL*Plus Text Editor
- 4-16. Toggling Syntax Text Color
- Chapter 5: Managing Files and Directories
- 5-1. Showing the Current Working Directory
- 5-2. Changing Directories
- 5-3. Creating a Directory
- 5-4. Viewing a List of Directories
- 5-5. Removing a Directory
- 5-6. Listing Files
- 5-7. Creating a File Quickly
- 5-8. Changing File Permissions
- 5-9. Changing File Ownership and Group Membership
- 5-10. Viewing the Contents of a Text File
- 5-11. Viewing Nonprinting Characters in a File
- 5-12. Viewing Hidden Files
- 5-13. Determining File Type
- 5-14. Finding Differences Between Files
- 5-15. Comparing Contents of Directories
- 5-16. Copying Files
- 5-17. Copying Directories
- 5-18. Moving Files and Directories
- 5-19. Renaming a File or Directory
- 5-20. Removing a File
- 5-21. Removing Protected Files Without Being Prompted
- 5-22. Removing Oddly Named Files
- 5-23. Finding Files
- 5-24. Finding Strings in Files
- 5-25. Finding a Recently Modified File
- 5-26. Finding and Removing Old Files
- 5-27. Finding the Largest Files
- 5-28. Finding a File of a Certain Size
- 5-29. Sorting Files by Size
- 5-30. Finding the Largest Space-Consuming Directories
- 5-31. Truncating an Operating System File
- 5-32. Counting Lines and Words in a File
- 5-33. Creating a Second Name for a File
- 5-34. Creating a Second Name for a Directory
- 5-35. Viewing a Large File
- 5-36. Downloading Files
- Chapter 6: Archiving and Compressing Files
- 6-1. Bundling Files Using tar
- 6-2. Unbundling Files Using tar
- 6-3. Finding Differences in Bundled Files Using tar
- 6-4. Bundling Files Using cpio
- 6-5. Unbundling Files Using cpio
- 6-6. Bundling Files Using zip
- 6-7. Unbundling Files Using zip
- 6-8. Bundling Files Using find
- 6-9. Compressing and Uncompressing Files
- 6-10. Validating File Contents
- Chapter 7: Shell Scripting
- 7-1. Writing a Simple Shell Script
- 7-2. Checking Simple Conditions
- 7-3. Testing a Condition
- 7-4. Checking Complex Conditions
- 7-5. Repeating a Task
- 7-6. Iterating Until a Condition Is Met
- 7-7. Displaying a Menu of Choices
- 7-8. Running Commands Based on Success/Failure of the Previous Command
- 7-9. Modularizing Scripts
- 7-10. Passing Parameters to Scripts
- 7-11. Processing Parameters
- 7-12. Running Database Commands in Scripts
- 7-13. Crafting a Robust DBA Shell Script
- 7-14. Running Scripts in the Background
- 7-15. Monitoring the Progress of a Script
- 7-16. Debugging a Script
- Chapter 8: Analyzing Server Performance
- 8-1. Identifying System Bottlenecks
- 8-2. Analyzing Current and Past System Performance
- 8-3. Identifying CPU-Intensive Processes
- 8-4. Identifying CPU Bottlenecks
- 8-5. Identifying Memory-Intensive Processes
- 8-6. Identifying Memory Bottlenecks
- 8-7. Identifying I/O-Intensive Processes
- 8-8. Identifying I/O Bottlenecks
- 8-9. Monitoring Network Traffic
- 8-10. Troubleshooting Database Connectivity
- 8-11. Tracing a Process
- 8-12. Listing Files Opened by Processes
- Chapter 9: Viewing and Configuring System Resources
- 9-1. Displaying Server Hardware and the Operating System
- 9-2. Listing CPUs
- 9-3. Displaying Physical Memory
- 9-4. Viewing Kernel Parameters
- 9-5. Modifying Kernel Parameters
- 9-6. Displaying Semaphores
- 9-7. Configuring Semaphores
- 9-8. Viewing Memory Structures
- 9-9. Removing In-Memory Structures
- 9-10. Viewing Network Configuration Settings
- 9-11. Configuring Network Settings
- 9-12. Modifying System Open File Limits
- 9-13. Showing Shell Limits
- 9-14. Changing Shell Limits
- Chapter 10: Automating Jobs with cron
- Chapter 11: Managing Server Software
- 11-1. Installing Packages
- 11-2. Switching to the Oracle Unbreakable Linux Network
- 11-3. Associating Linux Files with RPM Packages
- 11-4. Listing the Contents of an RPM Package
- 11-5. Downloading Packages
- 11-6. Automating Server Builds with Oracle RDBMS Server PreInstall RPM
- 11-7. Upgrading Packages
- 11-8. Removing Packages
- 11-9. Checking RPM Requirements to Install Oracle Database
- 11-10. Performing Initial Silent Oracle Software Installation with Response Files
- 11-11. Creating a Database with a Response File
- 11-12. Creating a Network Configuration with a Response File
- 11-13. Applying Patch Set Updates (PSUs) and Interim Patches
- 11-14. Cloning an Oracle Home
- 11-15. Attaching an Oracle Home
- Chapter 12: VirtualBox for Oracle
- 12-1. Installing Oracle VM VirtualBox
- 12-2. Setting Up VirtualBox Virtual Machine (VM)
- 12-3. Starting Up a VM for the First Time
- 12-4. Creating Additional Virtual Disks
- 12-5. Provisioning/Sharing a Disk with Another VM
- 12-6. Configuring the Virtual Network
- 12-7. Leveraging/Creating Oracle VM VirtualBox Prebuilt Templates
- 12-8. Cloning a VM
- 12-9. Working with Snapshots
- Chapter 13: Optimizing Linux for Oracle Databases
- 13-1. Minimalizing the Linux Environment for Performance and Security
- 13-2. Configuring Hugepages
- 13-3. Enabling Jumbo Frames
- 13-4. Determining and Implementing the Right I/O Scheduler
- 13-5. Setting Pertinent Kernel Parameters for Oracle Databases
- 13-6. Configuring NTP for Oracle
- 13-7. Bonding Network Interfaces
- 13-8. Enabling Network Services Cache Daemon (nscd)
- 13-9. Aligning Disk Partitions Correctly
- Chapter 14: Working Securely Across a Network
- Chapter 15: Managing X Window
- Chapter 16: Managing Remote Servers with VNC
- 16-1. Downloading the VNC Software
- 16-2. Installing the VNC Software
- 16-3. Manually Starting and Stopping the VNC Server
- 16-4. Automatically Starting the VNC Server on Linux
- 16-5. Automatically Starting the VNC Server on Solaris
- 16-6. Starting the VNC Viewer
- 16-7. Securing a VNC Connection
- 16-8. Accessing VNC via a Proxy Server
- 16-9. Running X Applications with VNC
- 16-10. Troubleshooting VNC
- Appendix A: RAID Concepts
- Appendix B: Server Log Files
- Index
About the Technical Reviewer
Jay Nielsen is an OCP developer (6i) and OCP DBA (10g), and is right in the middle of upgrading to OCP PL/SQL developer. He has worked in an Oracle environment since January 1989, starting with Oracle version 5.1 while in the U.S. Air Force. He retired from the USAF in 1995 and has continued as a Department of Defense contractor in the DC metro area. Jay has been married since 1975 and has 14 children. He currently works in the Cyber Division of NCIS HQ. Jay has a master’s degree in database technology from Regis University. Darl Kuhn was his favorite instructor from Regis University Online.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.