Oracle Consulting Oracle Training Oracle Support Development
Home
Catalog
Oracle Books
SQL Server Books
IT Books
Job Interview Books
eBooks
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
image
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
 Phone
 800-766-1884
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books
image
image

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle

STATSPACK Viewer

Privacy Policy

 

 

   
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)
Buy it now
       
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

 
Key Features

* 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

 

A

anacron

ASM

ASM binaries

ASM instance

asm_diskgroups

asm_diskstring

asm_power_limit

ASMLib

at

Automatic Shared Memory Management (ASMM)

Automatic Storage Management (ASM)

Automatic Storage Management Library (ASMLib)

 

B

batch

block device

block devices

block groups

Bourne-Again Shell

 

C

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

 

D

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)

 

E

Enterprise Manager dbconsole

ext2

ext3

 

F

fdisk

FIFO

file permissions

file system

file systems

free

fsck

 

G

GID (Group Identifier)

Global Database Name

GNU GPL licenses

groups

GRUB (Grand Unified Bootloader)

GUI (Graphical User Interface)

 

H

hugepages

 

I

Information Technology Infrastructure Library (ITIL)

init mode

init modes

initialization parameters

inode

insert mode

installation process

instance_type

inventory

iostat

iSQL*Plus

J

 JAccelator

Java NCOMP

JFS (IBM Journalized File System)

job-identifier

 

K

kernel parameters

kernel-hugemem package

 

L

LILO (Linux Loader)

line mode

link process

Linus Torvalds

Linux kernel

Linux kernel parameters

LKM (loadable kernel modules)

LMT (Locally Managed Tablespace)

lsmod

 

M

master boot record (MBR)

measurement tools

memory measurement tools

MINIX

modinfo

monolithic kernel

mount

 

N

named pipe

netstat

Network File System (NFS)

network parameters

nobody user

nofile limits

nproc limits

 

O

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)

 

P

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

 

R

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

 

S

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

 

T

task scheduler

top

tuning

 

U

UID (User Identifier)

umask

umount

Unbreakable Linux Network (ULN)

user permissions fields

users

 

V

vi text editor

Virtual File System (VFS)

VLM (Very Large Memory)

vmstat

 

X

X Windows

xargs

xload

xosview


Readers Comments


Errata

 

   

 Copyright © 1996 -2016 by Burleson. All rights reserved.


Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks