SUMMARY

SEARCH

Disclaimer: Authors have full rights over their works. Reproduction of any part of the content is prohibited without prior authorization.

BOOK LINUX AND SOLARIS RECIPES FOR ORACLE DBAS

SUMMARY

275

About the Authors
About the Technical Reviewer
Acknowledgments
Introduction
Chapter 1: Getting Started
Chapter 2: Working in the Shell
Chapter 3: Managing Processes and Users
Chapter 4: Creating and Editing Files
Chapter 5: Managing Files and Directories
Chapter 6: Archiving and Compressing Files
Chapter 7: Shell Scripting
Chapter 8: Analyzing Server Performance
Chapter 9: Viewing and Configuring System Resources
Chapter 10: Automating Jobs with cron
Chapter 11: Managing Server Software
Chapter 12: VirtualBox for Oracle
Chapter 13: Optimizing Linux for Oracle Databases
Chapter 14: Working Securely Across a Network
Chapter 15: Managing X Window
Chapter 16: Managing Remote Servers with VNC
Appendix A: RAID Concepts
Appendix B: Server Log Files
About the Authors
About the Technical Reviewer
Acknowledgments
Introduction
Chapter 1: Getting Started
1-1 Connecting Securely to a Remote Server
1-2 Logging on Remotely via the Command Line
1-3 Logging off the Server
1-4 Running a Command
1-5 Getting Help
1-6 Correcting Command-Line Mistakes
1-7 Clearing the Screen
1-8 Resetting the Screen
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
10-1 Enabling Access to Schedule Jobs
10-2 Editing the cron Table
10-3 Understanding cron Table Entries
10-4 Setting Operating System Variables
10-5 Specifying the Execution Shell
10-6 Redirecting cron Output
10-7 Embedding Conditional Logic
10-8 Troubleshooting 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-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 Fil
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
#1: Leveraging Oracle’s Prebuilt Template
#2: Creating Your Own OVA Template
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
Automating Hugepages Server Configuration
Computing the Value of Huge Pages on an Existing Linux Server
Disabling Transparent Huge Pages
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
14-1 Setting Up SSH
14-2 Generating Host Keys
14-3 Logging On Securely
14-4 Copying Files Securely
14-5 Authenticating Through Public Keys
14-6 Configuring a Promptless Logon
Chapter 15: Managing X Window
15-1 Configuring an X Server
15-2 Starting an X Server
15-3 Stopping the X Server
15-4 Displaying an X Client on a Remote Server
15-5 Tunneling X Over SSH
15-6 Manipulating the Terminal Emulator for X Windows
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
Understanding RAID
Defining Array,Stripe Width,Stripe Size,Chunk Size
RAID 0
RAID 1
Generating Parity
RAID 4
RAID 5
Building Hybrid (Nested) RAID Devices
RAID 0+1
RAID 1+0
RAID 5+0
Determining Disk Requirements
Capacity Planning
Appendix B: Server Log Files
Managing Linux Log Files
Rotating Log Files
Setting Up a Custom Log Rotation
Monitoring Log Files
Managing Solaris Log Files
Viewing System Message Log Files
Rotating Solaris Log Files