book

Linux and Solaris Recipes for Oracle DBAs, Second Edition

Name: Linux and Solaris Recipes for Oracle DBAs, Second Edition
ISBN: 9781484212547

by Darl Kuhn, Charles Kim, Bernard Lopuz

November 2015

Intermediate to advanced

500 pages

11h 59m

English

Apress

Read now

Unlock full access

Cover
Title
Copyright
Dedication
Contents at a Glance
Contents
About the Authors
About the Technical Reviewer
Acknowledgments
Introduction

Chapter 1: Getting Started
1-1. Connecting Securely to a Remote ServerProblemSolutionHow It Works1-2. Logging on Remotely via the Command LineProblemSolutionHow It Works1-3. Logging off the ServerProblemSolutionHow It Works1-4. Running a CommandProblemSolutionHow It Works1-5. Getting HelpProblemSolutionHow It Works1-6. Correcting Command-Line MistakesProblemSolutionHow It Works1-7. Clearing the ScreenProblemSolutionHow It Works1-8. Resetting the ScreenProblemSolutionHow It Works
Chapter 2: Working in the Shell
2-1. Displaying the Current ShellProblemSolutionHow It Works2-2. Running Previously Entered CommandsProblemSolutionHow It Works2-3. Automatically Completing Long CommandsProblemSolutionHow It Works2-4. Viewing Environment VariablesProblemSolutionHow It Works2-5. Automatically Setting Shell VariablesProblemSolutionHow It Works2-6. Customizing the Command PromptProblemSolutionHow It Works2-7. Creating a Command ShortcutProblemSolutionHow It Works2-8. Providing Input to CommandsProblemSolutionHow It Works2-9. Redirecting Command OutputProblemSolutionHow It Works2-10. Sending Output to NowhereProblemSolutionHow It Works2-11. Displaying and Capturing Command OutputProblemSolutionHow It Works2-12. Recording All Shell Command OutputProblemSolutionHow It Works2-13. Changing the Login ShellProblemSolutionHow It Works2-14. Modifying Command Path SearchProblemSolutionHow It Works2-15. Viewing Built-in CommandsProblemSolutionHow It Works2-16. Setting the Backspace KeyProblemSolutionHow It Works2-17. Typing a Long Command in Multiple LinesProblemSolutionHow It Works
Chapter 3: Managing Processes and Users
3-1. Listing ProcessesProblemSolutionHow It Works3-2. Terminating ProcessesProblemSolutionHow It Works3-3. Listing the Users Logged OnProblemSolutionHow It Works3-4. Listing the Last Logon Time of a UserProblemSolutionHow It Works3-5. Limiting the Number of User ProcessesProblemSolutionHow It Works3-6. Viewing How Long the Server Has Been RunningProblemSolutionHow It Works3-7. Viewing How Long a Process Has Been RunningProblemSolutionHow It Works3-8. Displaying Your UsernameProblemSolutionHow It Works3-9. Changing Your PasswordProblemSolutionHow It Works3-10. Becoming the System Privileged (root) UserProblemSolutionHow It Works3-11. Running Commands as the root UserProblemSolutionHow It Works3-12. Adding a GroupProblemSolutionHow It Works3-13. Removing a GroupProblemSolutionHow It Works3-14. Adding a UserProblemSolutionHow It Works3-15. Removing a UserProblemSolutionHow It Works
Chapter 4: Creating and Editing Files
4-1. Creating a FileProblemSolutionHow It Works4-2. Maneuvering Within a FileProblemSolutionHow It Works4-3. Copying and PastingProblemSolutionHow It Works4-4. Manipulating TextProblemSolutionHow It Works4-5. Searching for and Replacing TextProblemSolutionHow It Works4-6. Inserting One File into AnotherProblemSolutionHow It Works4-7. Joining LinesProblemSolutionHow It Works4-8. Running Operating System CommandsProblemSolutionHow It Works4-9. Repeating a CommandProblemSolutionHow It Works4-10. Undoing a CommandProblemSolutionHow It Works4-11. Displaying Line NumbersProblemSolutionHow It Works4-12. Automatically Configuring SettingsProblemSolutionHow It Works4-13. Creating Shortcuts for CommandsProblemSolutionHow It Works4-14. Setting the Shell Default Text EditorProblemSolutionHow It Works4-15. Setting the SQL*Plus Text EditorProblemSolutionHow It Works4-16. Toggling Syntax Text ColorProblemSolutionHow It Works
Chapter 5: Managing Files and Directories
5-1. Showing the Current Working DirectoryProblemSolutionHow It Works5-2. Changing DirectoriesProblemSolutionHow It Works5-3. Creating a DirectoryProblemSolutionHow It Works5-4. Viewing a List of DirectoriesProblemSolutionHow It Works5-5. Removing a DirectoryProblemSolutionHow It Works5-6. Listing FilesProblemSolutionHow It Works5-7. Creating a File QuicklyProblemSolutionHow It Works5-8. Changing File PermissionsProblemSolutionHow It Works5-9. Changing File Ownership and Group MembershipProblemSolutionHow It Works5-10. Viewing the Contents of a Text FileProblemSolutionHow It Works5-11. Viewing Nonprinting Characters in a FileProblemSolutionHow It Works5-12. Viewing Hidden FilesProblemSolutionHow It Works5-13. Determining File TypeProblemSolutionHow It Works5-14. Finding Differences Between FilesProblemSolutionHow It Works5-15. Comparing Contents of DirectoriesProblemSolutionHow It Works5-16. Copying FilesProblemSolutionHow It Works5-17. Copying DirectoriesProblemSolutionHow It Works5-18. Moving Files and DirectoriesProblemSolutionHow It Works5-19. Renaming a File or DirectoryProblemSolutionHow It Works5-20. Removing a FileProblemSolutionHow It Works5-21. Removing Protected Files Without Being PromptedProblemSolutionHow It Works5-22. Removing Oddly Named FilesProblemSolutionHow It Works5-23. Finding FilesProblemSolutionHow It Works5-24. Finding Strings in FilesProblemSolutionHow It Works5-25. Finding a Recently Modified FileProblemSolutionHow It Works5-26. Finding and Removing Old FilesProblemSolutionHow It Works5-27. Finding the Largest FilesProblemSolutionHow It Works5-28. Finding a File of a Certain SizeProblemSolutionHow It Works5-29. Sorting Files by SizeProblemSolutionHow It Works5-30. Finding the Largest Space-Consuming DirectoriesProblemSolutionHow It Works5-31. Truncating an Operating System FileProblemSolutionHow It Works5-32. Counting Lines and Words in a FileProblemSolutionHow It Works5-33. Creating a Second Name for a FileProblemSolutionHow It Works5-34. Creating a Second Name for a DirectoryProblemSolutionHow It Works5-35. Viewing a Large FileProblemSolutionHow It Works5-36. Downloading FilesProblemSolutionHow It Works
Chapter 6: Archiving and Compressing Files
6-1. Bundling Files Using tarProblemSolutionHow It Works6-2. Unbundling Files Using tarProblemSolutionHow It Works6-3. Finding Differences in Bundled Files Using tarProblemSolutionHow It Works6-4. Bundling Files Using cpioProblemSolutionHow It Works6-5. Unbundling Files Using cpioProblemSolutionHow It Works6-6. Bundling Files Using zipProblemSolutionHow It Works6-7. Unbundling Files Using zipProblemSolutionHow It Works6-8. Bundling Files Using findProblemSolutionHow It Works6-9. Compressing and Uncompressing FilesProblemSolutionHow It Works6-10. Validating File ContentsProblemSolutionHow It Works
Chapter 7: Shell Scripting
7-1. Writing a Simple Shell ScriptProblemSolutionHow It Works7-2. Checking Simple ConditionsProblemSolutionHow It Works7-3. Testing a ConditionProblemSolutionHow It Works7-4. Checking Complex ConditionsProblemSolutionHow It Works7-5. Repeating a TaskProblemSolutionHow It Works7-6. Iterating Until a Condition Is MetProblemSolutionHow It Works7-7. Displaying a Menu of ChoicesProblemSolutionHow It Works7-8. Running Commands Based on Success/Failure of the Previous CommandProblemSolutionHow It Works7-9. Modularizing ScriptsProblemSolutionHow It Works7-10. Passing Parameters to ScriptsProblemSolutionHow It Works7-11. Processing ParametersProblemSolutionHow It Works7-12. Running Database Commands in ScriptsProblemSolutionHow It Works7-13. Crafting a Robust DBA Shell ScriptProblemSolutionHow It Works7-14. Running Scripts in the BackgroundProblemSolutionHow It Works7-15. Monitoring the Progress of a ScriptProblemSolutionHow It Works7-16. Debugging a ScriptProblemSolutionHow It Works
Chapter 8: Analyzing Server Performance
8-1. Identifying System BottlenecksProblemSolutionHow It Works8-2. Analyzing Current and Past System PerformanceProblemSolutionHow It Works8-3. Identifying CPU-Intensive ProcessesProblemSolutionHow It Works8-4. Identifying CPU BottlenecksProblemSolutionHow It Works8-5. Identifying Memory-Intensive ProcessesProblemSolutionHow It Works8-6. Identifying Memory BottlenecksProblemSolutionHow It Works8-7. Identifying I/O-Intensive ProcessesProblemSolutionHow It Works8-8. Identifying I/O BottlenecksProblemSolutionHow It Works8-9. Monitoring Network TrafficProblemSolutionHow It Works8-10. Troubleshooting Database ConnectivityProblemSolutionHow It Works8-11. Tracing a ProcessProblemSolutionHow It Works8-12. Listing Files Opened by ProcessesProblemSolutionHow It Works
Chapter 9: Viewing and Configuring System Resources
9-1. Displaying Server Hardware and the Operating SystemProblemSolutionHow It Works9-2. Listing CPUsProblemSolutionHow It Works9-3. Displaying Physical MemoryProblemSolutionHow It Works9-4. Viewing Kernel ParametersProblemSolutionHow It Works9-5. Modifying Kernel ParametersProblemSolutionHow It Works9-6. Displaying SemaphoresProblemSolutionHow It Works9-7. Configuring SemaphoresProblemSolutionHow It Works9-8. Viewing Memory StructuresProblemSolutionHow It Works9-9. Removing In-Memory StructuresProblemSolutionHow It Works9-10. Viewing Network Configuration SettingsProblemSolutionHow It Works9-11. Configuring Network SettingsProblemSolutionHow It Works9-12. Modifying System Open File LimitsProblemSolutionHow It Works9-13. Showing Shell LimitsProblemSolutionHow It Works9-14. Changing Shell LimitsProblemSolutionHow It Works
Chapter 10: Automating Jobs with cron
10-1. Enabling Access to Schedule JobsProblemSolutionHow It Works10-2. Editing the cron TableProblemSolutionHow It Works10-3. Understanding cron Table EntriesProblemSolutionHow It Works10-4. Setting Operating System VariablesProblemSolutionHow It Works10-5. Specifying the Execution ShellProblemSolutionHow It Works10-6. Redirecting cron OutputProblemSolutionHow It Works10-7. Embedding Conditional LogicProblemSolutionHow It Works10-8. Troubleshooting cronProblemSolutionHow It Works
Chapter 11: Managing Server Software
11-1. Installing PackagesProblemSolution #1Solution #2How It Works11-2. Switching to the Oracle Unbreakable Linux NetworkProblemSolutionHow It Works11-3. Associating Linux Files with RPM PackagesProblemSolution #1Solution #2How It Works11-4. Listing the Contents of an RPM PackageProblemSolution #1Solution #2How It Works11-5. Downloading PackagesProblemSolutionHow It Works11-6. Automating Server Builds with Oracle RDBMS Server PreInstall RPMProblemSolutionHow It Works11-7. Upgrading PackagesProblemSolution #1Solution #2How It Works11-8. Removing PackagesProblemSolution #1Solution #2How It Works11-9. Checking RPM Requirements to Install Oracle DatabaseProblemSolutionHow It Works11-10. Performing Initial Silent Oracle Software Installation with Response FilesProblemSolution #1Solution #2How It Works11-11. Creating a Database with a Response FileProblemSolutionHow It Works11-12. Creating a Network Configuration with a Response FileProblemSolutionHow It Works11-13. Applying Patch Set Updates (PSUs) and Interim PatchesProblemSolutionHow It Works11-14. Cloning an Oracle HomeProblemSolutionHow It Works11-15. Attaching an Oracle HomeProblemSolutionHow It Works
Chapter 12: VirtualBox for Oracle
12-1. Installing Oracle VM VirtualBoxProblemSolutionHow It Works12-2. Setting Up VirtualBox Virtual Machine (VM)ProblemSolutionHow It Works12-3. Starting Up a VM for the First TimeProblemSolutionHow It Works12-4. Creating Additional Virtual DisksProblemSolutionHow It Works12-5. Provisioning/Sharing a Disk with Another VMProblemSolutionHow It Works12-6. Configuring the Virtual NetworkProblemSolutionHow It Works12-7. Leveraging/Creating Oracle VM VirtualBox Prebuilt TemplatesProblemSolution #1: Leveraging Oracle’s Prebuilt TemplateSolution #2: Creating Your Own OVA TemplateHow It Works12-8. Cloning a VMProblemSolutionHow It Works12-9. Working with SnapshotsProblemSolutionHow It Works
Chapter 13: Optimizing Linux for Oracle Databases
13-1. Minimalizing the Linux Environment for Performance and SecurityProblemSolutionHow It Works13-2. Configuring HugepagesProblemSolutionHow It WorksAutomating Hugepages Server ConfigurationComputing the Value of Huge Pages on an Existing Linux ServerDisabling Transparent Huge Pages13-3. Enabling Jumbo FramesProblemSolutionHow It Works13-4. Determining and Implementing the Right I/O SchedulerProblemSolutionHow It Works13-5. Setting Pertinent Kernel Parameters for Oracle DatabasesProblemSolutionHow It Works13-6. Configuring NTP for OracleProblemSolutionHow It Works13-7. Bonding Network InterfacesProblemSolutionHow It Works13-8. Enabling Network Services Cache Daemon (nscd)ProblemSolutionHow It Works13-9. Aligning Disk Partitions CorrectlyProblemSolutionHow It Works
Chapter 14: Working Securely Across a Network
14-1. Setting Up SSHProblemSolutionHow It Works14-2. Generating Host KeysProblemSolutionHow It Works14-3. Logging On SecurelyProblemSolutionHow It Works14-4. Copying Files SecurelyProblemSolutionHow It Works14-5. Authenticating Through Public KeysProblemSolutionHow It Works14-6. Configuring a Promptless LogonProblemSolutionHow It Works
Chapter 15: Managing X Window
15-1. Configuring an X ServerProblemSolutionHow It Works15-2. Starting an X ServerProblemSolutionHow It Works15-3. Stopping the X ServerProblemSolutionHow It Works15-4. Displaying an X Client on a Remote ServerProblemSolutionHow It Works15-5. Tunneling X Over SSHProblemSolutionHow It Works15-6. Manipulating the Terminal Emulator for X WindowsProblemSolutionHow It Works
Chapter 16: Managing Remote Servers with VNC
16-1. Downloading the VNC SoftwareProblemSolutionHow It Works16-2. Installing the VNC SoftwareProblemSolutionHow It Works16-3. Manually Starting and Stopping the VNC ServerProblemSolutionHow It Works16-4. Automatically Starting the VNC Server on LinuxProblemSolutionHow It Works16-5. Automatically Starting the VNC Server on SolarisProblemSolutionHow It Works16-6. Starting the VNC ViewerProblemSolutionHow It Works16-7. Securing a VNC ConnectionProblemSolutionHow It Works16-8. Accessing VNC via a Proxy ServerProblemSolutionHow It Works16-9. Running X Applications with VNCProblemSolutionHow It Works16-10. Troubleshooting VNCProblemSolutionHow It Works
Appendix A: RAID Concepts
Understanding RAIDDefining Array, Stripe Width, Stripe Size, Chunk SizeRAID 0RAID 1Generating ParityRAID 4RAID 5Building Hybrid (Nested) RAID DevicesRAID 0+1RAID 1+0RAID 5+0Determining Disk RequirementsCapacity Planning
Appendix B: Server Log Files
Managing Linux Log FilesRotating Log FilesSetting Up a Custom Log RotationMonitoring Log FilesManaging Solaris Log FilesViewing System Message Log FilesRotating Solaris Log FilesSummary
Index

Overview

Linux and Solaris Recipes for Oracle DBAs, 2nd Edition is an example–based book on managing Oracle Database under Linux and Solaris. The book is written for database administrators who need to get work done and lack the luxury of curling up fireside with a stack of operating-system documentation. What this book provides instead is task-oriented coverage designed around the needs of the Oracle Database Administrator. Find the right chapter. Look up the task to perform. See the solution. Implement the solution straight away in your own environment. Get the job done.

New in this edition is coverage of Oracle's own Solaris operating system. Oracle Corporation has been working diligently to bring commonality between Solaris and Linux, and this book takes advantage of those efforts to provide task-oriented solutions that work on common distributions of Linux such as Red Hat Enterprise Linux and Oracle Enterprise Linux while also accommodating the growing number of Oracle Solaris customers. Examples in the book match the tasks DBAs perform daily, even hourly. Solutions come first in the book, but always are followed by close explanations of the details.

Database administrators won't go wrong with Linux and Solaris Recipes for Oracle DBAs. It's the book to buy if you're after clear and reliable examples to help in getting the job done, and getting home to your family.

• Takes you directly from problem to solution

• Covers the "right" mix of operating-system tasks for database administrators

Respects your time by being succinct and to–the–point

• Includes coverage of Solaris in addition to common Linux distributions

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Publisher Resources

ISBN: 9781484212547Purchase book

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills