D50794GC11, Oracle Database 10g: Managing Oracle on Linux for System Administrators

Patlaban šis kurss nav ieplānots. Izmantojiet zemāk redzamo hipersaiti, lai to pieprasītu
Pieprasīt kursu

Kursa apraksts nav pieejams latviešu valodā!

Kursa mērķi

This course prepares a Linux system administrator for managing a system on which Oracle Database has been installed. Elements of how Oracle works on Enterprise Linux and specific steps for preparing Linux for a database installation are covered. This course provides the system administrator, who already has some Linux experience, with
the skills needed to diagnose an Oracle Database using system administration tools. The Oracle Database architecture is covered, which will help the system administrator understand what affect database activity and configuration can have on the process list, disk space, memory use, and CPU utilization.

The Linux system administrator will also learn how to perform some tasks that are sometimes shared between the system administrator and database administrator. The course provides information on how the operating system tools and techniques affect the tasks and settings that are often the DBA's responsibility. File systems, including OCFS2, network configuration, memory management, and package management using the Unbreakable Linux Network are discussed. Demos and practices reinforce the concepts presented, including the installation and use of several tools that help in gathering diagnostic information that can be provided to Oracle Support Services.

Mērķauditorija

• Technical Administrator

Pēc kursa

• Configure Oracle to startup and shutdown automatically with the system
• Configure Linux and Oracle to address large amounts of memory on a 32 bit system
• Set up a local yum repository based on the Unbreakable Linux Network repository
• Diagnose and recover from Oracle instance errors
• Prepare Linux for Oracle Database
• Implement OCFS2

Priekšzināšanas

• Working knowledge of the Linux operating system.

Kursa materiāli

The student kit includes a comprehensive workbook and other necessary materials for this class.

Kursa saturs

1. Oracle Database Architecture:

• Components of the Oracle environment
• Database Management Tools
• Using SQL*Plus for SELECT queries
• Using Database Control to View System Statistics

2. Oracle Database Users and Files:

• Creating the Needed Groups and Users
• The Oracle Inventory
• Navigating the Oracle Directories
• Physical Database Limits

3. Oracle Instance Processes:

• Listing Oracle Instance Processes
• Automating Startup and Shutdown of the Database
• Configuring Command Line History for SQL*Plus
• Setting Kernel Parameters for the Oracle Database

4. Oracle and Linux Memory:

• Configuring Shared Memory for Oracle Database
• Linux Memory Zones
• Configuring Linux and Oracle for a Large SGA
• Linux Memory Caches

5. Creating a ULN Repository:

• Accessing the Unbreakable Linux Network
• Configuring and Populating a yum Repository
• Updating the System Using a yum Repository

6. Diagnosing the System:

• Determining the CPU and Process Load
• Detecting Out-of-memory Conditions
• Listing Oracle port Usage
• Monitoring I/O Activity
• Generating Memory Dumps
• Installing and Using OSWatcher

7. Diagnosing Processes:

• Determining the Environment of a Running Process
• Identifying Memory-Leaking Processes
• Viewing Oracle Shared Memory Segments
• Viewing Oracle Semaphore Usage
• Recovering From Database Crashes
• Locating Oracle Process Core Dump Files
• Recording Shell Activity

8. Managing Database Storage:

• I/O Modes
• Oracle Database Storage Options
• Sizing I/O for Performance
• Data Striping Strategies
• Using RAID
• Sizing Disk Partitions for Oracle Files
• Configuring udev
• Using ASM and ASMLib

9. Implementing OCFS2:

• Oracle Real Application Clusters Concepts
• Considering Clusters
• Scalability Considerations
• OCFS2 Concepts
• Installing OCFS2
• Configuring an OCFS2 Cluster
• Formatting OCFS2 Volumes

10. Configuring and Diagnosing the Network:

• Displaying Network Status
• Using DHCP with a Static IP Address
• Using nmap
• Configuring SSH
• Connecting to SSH Without a Password
• Configuring an Interconnect for Oracle Clusters
• Network Interface Bonding

11. Configuring netdump:

• The Need for netdump
• netdump Concepts
• Configuring the netdump Server
• Configuring the netdump Client
• Configuring netconsole