Oracle Database 10g: Managing Oracle on Linux for Database Administrators

Phone
800-766-1884


ISBN-13 978-0-9844282-1-2	Library of Congress Number: 2011921295
420 pages: Perfect Bind- 9x7	Publication Date:911
Shelving: Database/Oracle	Oracle In-Focus Series # 38

Oracle Certified Linux Expert Exam Cram:
OCE Exam: 1Z0-046: Managing Oracle on Linux Certified Expert

Hubert Savio

Retail Price $39.95 / £27.95

Only $29.95
(30% off)


Key Features	About the Authors	Reader Comments
Table of Contents	Errata

Written by a top Oracle Linux specialist with over a decade of experience in Oracle, this is the most detailed OCE Exam Guide Available in the Oracle community.

Prepare to pass the OCE Oracle Database 10g under Linux certification exam with this 1Z0-046 exam preparation guide. This book will help you prepare for all topics of exams 1Z0-046 with real world examples, exercises and practical tests.

For use in preparations for Exam 1Z0-046

Certifications required for Exam:
Oracle Database 10g: Managing Oracle on Linux Certified Expert

* Provides a clear picture of what is expected for the OCE exam 1Z0-046

*Complete preparation guide for OCE exam 1Z0-046

*Assessment tests and practical exercises for exam preparation

About the Authors:

Hubert Savio		*Hubert Savio* is a senior IT specialist currently employed as a Senior Database Administrator at IBM Denmark. Hubert has worked with Oracle since late 1996 as far back as releases 6 and 7.3.4. Before working at IBM, he worked in several companies as a Linux/Unix system engineer and IT consultant. Hubert holds a Masters degree in IT from the Centre d'etudes Supérieures Industrielles of Strasbourg (in France). Hubert is specialized in Oracle Real Application Clusters, Oracle under Unix and Linux. He works on implementation projects for IBM. He also holds several Oracle certifications, including OCP on 10g, OCE on both RAC and Oracle under Linux and is also certified on Linux. Hubert passed also the ITIL and the Open Group Master Certified IT specialist program. Hubert is a regular contributor on the Oracle Forum. Hubert lived in Lyngby north of Copenhagen in Denmark.

Technical Editors:
Taeke S. Tuinstra		Taeke S. Tuinstra has worked as an IT specialist since 1988. He worked for large national social security organization on IT headquarters as VAX/VMS system manager and systems auditor. Currently and since 7 or 8 years Oracle DBA (10g & 11g OCP) mainly working for ING bank but also smaller/shorter assignments. Mr. Tuinstra is interested in programming languages and operating systems. Very recently delving into Amazon Elastic Compute Cloud (EC2) and now working for a new joint venture within VX Company in the realm of data oriented forensic analytics.

Denis Canty		*Denis Canty* attended University College Cork (Ireland) at the tender age of 16, and from there obtained a Bachelor degree in Electrical Engineering and Micro Electronics. Now, with over 20 years experience in Telecommunications and IT consultancy, he currently works as an IT-consultant for a major Danish consultancy company. Denis has several years system administration experience on Unix/Linux systems and is an Oracle Certified Professional (10g). Having travelled the four corners of the globe, Denis has now settled down with his family in Copenhagen, Denmark.

Table of Contents:

Preface

Foreword

Reasons to Certify

Certification Tracks

Where to Find Official Information

What This Book Covers

The Structure of the Book

Exam Objectives and Requirements

Exam Topics

Exam Information

Advice for Taking the OCE Exam

How to Use This Book

Evaluating Knowledge: Assessment Test

Answers

Chapter 1: Introduction to Linux

What is Linux?

History of Linux and UNIX

The Linux Kernel

The Different Distributions of Linux

How is Linux Structured?

Why Oracle on Linux?

What is the Oracle Unbreakable Linux Program?

Hardware Supported by Linux OS

Defining User’s Linux Version

Processes and Threads in Linux

Devices in Linux

Commands and Programs in Linux

Environment Variables

Linux and RPM

Summary

Exercises

Q&A

Questions

Answers

Solutions to Exercises

Chapter 2: Linux Level 2: File Permissions and Processes

Users and Groups

Users

Groups

Administering Users by Command

Rules about the UID and GID

How to Set Up a BASH Environment or Profile

File Permissions

File Security and Administration

How to Change File Permissions

How to Create Links

Processes

Commands to Manage Processes

Kernel Parameters

Introduction to Semaphores

Modifying Parameters for the Semaphores

Shared Memory Parameters

Commands Used For Changing Values

Network Parameters

File Handler Parameters

Summary

Exercises

Q&A

Questions

Answers

Solutions to Exercises

Chapter 3: Linux Level 3: File Systems and Structures

File Systems

Superblocks

Inodes

Handling File Systems

File System Creation

Swap

Startup Sequences for Linux

init Modes

OS Patches

Summary

Exercises

Q&A

Questions

Answers

Solutions for Exercises

Chapter 4: Linux Measurements, Scheduling Tools and X Windows

Linux Measurements Tools

Memory Measurement Tools

X Windows GUI Measurement Tools

Scheduling Tools

Task Scheduler

X Windows

Summary

Exercises

Q&A

Questions

Answers

Solutions to the Exercises

Chapter 5: Linux Text Editor

Introduction

Launch vi

Modes with vi

Chapter 6: Preparing Linux for Oracle

Oracle on Linux

Metalink – My Oracle Support

Hardware Requirements

RPM Packages

Operating System Settings

Linux Kernel Parameters

Groups and User

Typical Groups for Oracle under Linux

Oracle Users

Download the Oracle Installation

Additional Resources and Tools

Summary

Exercises

Q&A

Questions

Answers

Solutions to Exercises

Chapter 7: Installing Oracle on Linux

Oracle Account Settings

OFA (Optimal Flexible Architecture)

Multiple Oracle Versions on the Same Server

Download the Installation Files

Installation

Oracle Universal Installer Log Files

OPatch Utility

Relink the Binaries

Solve Issues During the Installation

Topics Not On Exam

Java NCOMP

OUI Silent Installation

OUI Binaries Cloning

Summary

Exercises

Q&A

Questions

Answers

Solutions to Exercises

Chapter 8: Managing Storage

File System Features

Partitions in Linux

Supported and Certified File Systems by Oracle

Summary

Exercises

Q&A

Questions

Answers

Solutions to Exercises

Chapter 9: Automatic Storage Management

What is ASM?

What is ASM Able to Store?

ASM Installation, Settings and Best Practices

ASM Library Install and Setup

Perform the Disk Configuration

Mark Disks to be Used by ASM

Create the ASM Instance

ASMLib and ASM Digest

Summary

Exercises

Q&A

Questions

Answers

Solutions to Exercises

Chapter 10: Creating An Oracle Database

How to Create an Oracle Database

Oracle Instance Processes, Files and Structures

URL Information

OS Authentication

Oracle Diverse Commands and Files

Summary

Exercises

Q&A

Questions

Answers

Solutions to Exercises

Chapter 11: Customizing Oracle Databases Under Linux

Why Customize Oracle Databases under Linux?

Automatic vs. Manual Oracle Stop and Start

Script to Perform Stop and Start of an Oracle Database

Stop and Start Script dbora

Oracle EM Dbconsole Scheduling Possibilities

Customization of Oracle Initialization Parameters

Summary

Exercises

Q&A

Questions

Answers

Solutions to the Exercises

Chapter 12: Memory Management

Memory Models Available in Linux Kernels

Swap in Linux

Memory Report Tools

Hugepages

Configuration of Hugepages

SGA Relocation Operations

Kernel with Huge Memory

Summary

Exercises

Q&A

Questions

Answers

Solutions for Exercises

Chapter 13: Measurement, Tuning and Debugging

Introduction

Linux Measurement Tools

Memory Consideration and Tuning Tools

I/O Consideration and Tuning Tools

CPU Consideration and Tuning Tools

Tuning Performance

Debugging

RDA

OS Watcher

Solving the ORA-00600 & ORA-07445 Errors

Summary

Exercises

Q&A

Questions

Answers

Solutions for Exercises

Chapter 14: Post Certification Information

Congratulations!

DBA and Linux System Administrator Jobs

DBA Tasks

DBA Tools

Book Conclusion

Exam Topics

Introduction

Interpret Linux kernel version information
Identify a tainted kernel
Use common Linux commands
Write a simple bash shell script

Preparing Linux for Oracle

Use the package manager to determine and update package support
Set up the operating system environment for Oracle Database
Create the necessary groups and users for Oracle Database

Installing Oracle on Linux

Describe the Linux file system security
Install multiple versions of Oracle Database software on the same server
Accommodate multiple Oracle homes on one database server

Managing Storage

Distinguish the differences between certified and supported file systems
Select a file system

Automatic Storage Management

Install and initialize Automatic Storage Management Library Driver (ASMLib)
Mark disks for ASMLib
Create an Automatic Storage Management instance

Creating a Database

Create an Oracle database that uses ASM
Identify the location of various Oracle files
Implement OS authentication

Customizing Oracle on Linux

Create automated startup/shutdown scripts
Automate tasks using scheduling tools
Configure Linux startup and shutdown sequence

Managing Memory

List the memory models available in Linux kernels
Implement hugepages
Describe /proc/meminfo contents
List the implications of Linux memory configuration on Oracle Database
Identify the issues regarding 32-bit OS versus 64-bit OS

Using Linux Measurement Tools

Use Linux monitoring tools
Interpret memory measurements
Interpret I/O measurements

Tuning Performance

Evaluate file systems
Tune supported file systems
Configure initialization parameters
Implement asynchronous input/output (I/O)
Implement advanced memory management techniques

Debugging Oracle 10g on Linux

Install and configure OS Watcher
Use Oracle Support's Remote Diagnostics Agent
Trace programs and processes with strace
Gather required information for resolving ORA-600 and ORA-7445 errors

Index:

$HOME/.profile

$ORACLE_BASE

$ORACLE_HOME

$ORACLE_SID

/proc

/proc/meminfo

/var/log/messages

anacron

ASM

ASM binaries

ASM instance

asm_diskgroups

asm_diskstring

asm_power_limit

ASMLib

Automatic Shared Memory Management (ASMM)

Automatic Storage Management (ASM)

Automatic Storage Management Library (ASMLib)

batch

block device

block devices

block groups

Bourne-Again Shell

character device

character devices

child processes

chmod command

cloning

Cluster Synchronization Services (CSS)

command mode

Critical Patch Updates

cron

crontab

CRS (Cluster Ready Services)

cssd

database buffer cache

Database Configuration Assistant

database creation

database files

Database Scheduler

database storage

database writer (DBWR)

db_writer_processes

DBA tasks

dbca (Database Configuration Assistant Client)

dbca utility

dbca wizard

dbora

dbwr_io_slaves

debugging

disk device

disk groups

dmesg

DMT (Dictionary Managed Tablespace)

DSS (Decision Support System/DWH (DataWareHouse)

Enterprise Manager dbconsole

ext2

ext3

fdisk

FIFO

file permissions

file system

file systems

free

fsck

GID (Group Identifier)

Global Database Name

GNU GPL licenses

groups

GRUB (Grand Unified Bootloader)

GUI (Graphical User Interface)

hugepages

Information Technology Infrastructure Library (ITIL)

init mode

init modes

initialization parameters

inode

insert mode

installation process

instance_type

inventory

iostat

iSQL*Plus

JAccelator

Java NCOMP

JFS (IBM Journalized File System)

job-identifier

kernel parameters

kernel-hugemem package

LILO (Linux Loader)

line mode

link process

Linus Torvalds

Linux kernel

Linux kernel parameters

LKM (loadable kernel modules)

LMT (Locally Managed Tablespace)

lsmod

master boot record (MBR)

measurement tools

memory measurement tools

MINIX

modinfo

monolithic kernel

mount

named pipe

netstat

Network File System (NFS)

network parameters

nobody user

nofile limits

nproc limits

OLTP (On Line Transaction Processing)

OPatch

operating systems

Optimal Flexible Architecture (OFA)

ORA-00600

ORA-97445

Oracle binaries

Oracle Certified Expert

Oracle Cluster File System (OCFS)

Oracle Enterprise Manager (OEM)

Oracle instance

Oracle Managed Files

Oracle System ID (SID)

Oracle Universal Installer (OUI)

oracle user

oracleasm

oracleasmlib

oracleasm-support

oraenv

OS authentication

OSW (Operating System Watcher)

PAE (Page Address Extension)

page table

pages

partitions

partprobe

Pearson VUE

perl script

PID (Process ID)

Pluggable Authentication Modules

PPID (Parent Process ID)

pre_page_sga

processes

procfs

raw device

raw devices

RDA

RDA (Remote Diagnostics Agent)

RDBMS binaries

Real Application Cluster (RAC)

Recovery Manager (RMAN)

redologs

rmmod

root user

RPM package

RPM packages

SAR (System Activity Reporter)

semaphores

semmni

semmns

semmsl

semopm

Setgid

Setuid

SGA (System Global Area)

shared memory

shell limit

shmall

shmmax

shmmni

shmseg

sockets

SQL scripts

Sticky bit

strace

superblock

swap

sysoper

task scheduler

top

tuning

UID (User Identifier)

umask

umount

Unbreakable Linux Network (ULN)

user permissions fields

users

vi text editor

Virtual File System (VFS)

VLM (Very Large Memory)

vmstat

X Windows

xargs

xload

xosview

Readers Comments

Errata