Shell Programming � introduction, variable declaration, logical and relational
operators, if condition, case statements, loops and positional parameters
Searching files using find command by using various options
Communication Tools - using write, mesg, talk, mail and wall commands
Linking Files using hard and soft (symbolic links)
Advanced Filters - pattern matching, filtering text files, field processing
Shell Scripting
Process Scheduling - background processes, killing a process
Pre Requisite : Unix, Oracle & Unix
Administration
Architecture
Defining
an
Oracle
Server,
Database,
Instance.
Understanding
Physical
Structure,
Memory
Structure,
Process
Structure,
Logical
Structure,
Execution
of SQL
Statements,
User
Session
Creating a New
Database
Identifying
the
application
and the
no. of
applications
the DB
will
support.
Adv. of
having
each
application
on each
DB. Adv.
of
having
common
DB for
all
Applications.
Understanding
TS,
Changing
Initialization
parameters
� SGA
size,
Processes,
TS
Naming
Conventions,
Block
Sizes,
Type of
DB, No.
of users
the DB
has to
support,
etc,
Dropping
a
Database,
ASM
Database.
Managing an Oracle
Database
Creating
and
Managing
Initialization
files
�
PFILE
and
SPFILE,
Adv.
of
SPFILE
over
PFILE
Identifying
the
various
states/options
of
Instance
Startup/Shutdown,
DB
Mount/Open
stages
Monitoring
Alert
and
Trace
Files
in
udump,
bdump
and
cdump
for DB
Troubleshooting
Configuring
System
Global
Area (SGA)
� DB
Buffer
Cache,
Log
Buffer
and
Shared
Pool
Understanding
Background
Processes
�
Mandatory/Optional
and
the
jobs
performed
by
them
using
the
Data
Dictionary
to
retrieve
information
about
the
database
� V$,
DBA_
views
Managing
Tablespaces and
Datafiles
Creating
and
Altering
Tablespaces,
adding,
resizing,
renaming
and
relocating
a
Datafile,
Renaming
Tablespace.
Creating
and
Managing
a
Tablespace
when
using
OMF
and
the
advantages
of OMF
feature
Extent
management-
Dictionary
Managed
and
Locally
Managed
Tablespaces
(AUTOALLOCATE,
UNIFORM)
and
advantages
of
locally
managed
over
dictionary
managed
tablespaces
Obtaining
table
information
like
avg.
row
length,
chained
rows,
etc
after
analyzing
the
tables
Managing,
Listing
diff.
types
of
Indexes
and
their
uses,
Creating
B-Tree
and
Bitmap
Indexes,
Maintaining
Indexes,
Identifying
unused
Indexes,
Obtaining
Index
Information
User Management
Creating user�s, Managing resources with profiles, User Authentication, Managing user
privileges, schema management, Security
Creating roles and Managing roles.
Managing Export�s & Import�s
Main Tasks of Exports and Imports
Incremental, Cumulative and Complete Export and Import
Points to remember before doing export and import
Oracle Data Pump
Introduction, Benefits of Data Pump Export and Import
Data Pump Export and Import modes
Managing,
Transport of Tablespace across different platform�s, TTS for a single partition
Maintaining the Control File, Redo Log File and Archive Log Files
Importance, Role, Sizing, Contents, Multiplexing and Backing up of the Control File
Purpose of and how online redo log files work with their associated Background
Processes
Controlling log switches and checkpoints, Multiplexing and Archiving online redo
log files
Networking
Overview
Explaining
solutions
included
with
Oracle
for
managing
complex
networks
Oracle
Net
Architecture
�
Explaining
the
key
components,
Role
in
Client/Server
connections
Oracle
Net
Services
Server-side
Configuration,
Oracle
Net
Services
Client-Side
Configuration
Configuring
and
Maintaining
Distributed
DBs by
creating
DB
Links,
Materialized
Views
Usage
and
Configuration
of
Oracle
Shared
Server,
Components
of the
Oracle
Shared
Server,
Configuring
Shared
Servers
and
Dispatchers,
Identifying
Useful
Data
Dictionary
Views
Backup and Recovery
Describing the basics of DB
Backup, Restore and
Recovery, Listing the types
of Failures that may occur
in an Oracle Environment,
Defining Backup and Recovery
Strategies
Instance and Media Recovery
Structures � Describing the
Oracle Processes, Memory
Structures and Files related
to Recovery, Identifying the
importance of Checkpoints,
Redo Log Files and Archived
Log Files, Describing the
ways to tune Instance
Recovery
User Managed Backups and
Recoveries � Backup and
Recovery Operations, Closed
and Open DB Backups (Hot and
Cold), Complete Recovery,
Identifying the situations
which require Incomplete
Recovery, Recovery from loss
of Online Redo Logs,
Creating Clone DBs
Oracle Recovery Manager (RMAN)
� Features and Components,
Repository, Channel
Allocation, Configuring RMAN
Environment, Backup Commands
and Scripts for Backup sets,
Image copies, Complete and
Incomplete Recovery and
Full/Incremental Compressed
backups, Incremental baclups
with block change tracking
VPCC (Virtual Private Catalogs)
Availability
Dataguard - offers Maximum
Protection/Performance,
centralizing and simplifying
mgmt., safeguarding against
physical corruptions,
provides Fail Over and
Switch Over
Logminer � Read and Analyze
the contents of redo log
files, obtain info. about
DML activities on standard
tables, provides a means of
auditing actions to either
specific tables or by users
Flashback Technology � Intro
to Flash Recovery Area,
Flashback Version Query,
Flashback Transaction Query
Oracle10g�s New Features
Performance Tuning
Overview of Tuning Phases, Goals, Methodology
and Common Performance problems
DB Conf. and I/O Issues, File Striping,
Optimize/Tuning Sorting Operations, Diagnosing
and Tuning Latch and Lock Contention,
Partitioning, Redo Log File Configuration,
Online Segment Shrinking
Introduction of Clusters, Types of Cluster,Components of a Cluster,Hardware Requirement for Clusters
Define Oracle Real Application Clusters,List the advantages of using RAC, RAC Architecture and Concepts,SGA structures,Background processes
Oracle 10g RAC Installation
Operating System preparation for RACIntroduction to Network hardware,Private and Public Network configuration,SHMMAX and Semaphores for Oracle 10g RAC,Groups and Users for Oracle Software,Cluster Setup Tasks,Introduction to 10g RAC daemons,Installing Cluster Ready Services,Install Database Software
Storage Options for RAC Database files
Introduction to ASM,Advantages of ASM,Parameters used to configure ASM,Creating ASM Instance in RAC,Introduction to OCFS2,Advantages of OCFS2,Database creation in RAC,Required RAC database files,Parameters used for RAC database,RAC Initialization Parameter Files
Administrating RAC
Manage redo log groups in a RAC environment,Manage undo tablespaces in a RAC environment,Enabling and Disabling instances,Working with spfile in RAC environment,Archiving schemes in RAC,Management of OCR and Voting Disk (Adding, Removing)
Managing Backup & Recovery
in RAC
Consideration for Logical Backups in RAC
Consideration of Flash Recovery Area in RAC
Physical Backup and Recovery in RAC through RMAN
High Availability connections configuration
Configure client side connect-time load balancing,Configure server side connect-time load balancing,Configure Transparent Application Failover (TAF),Configure and manage service in a RAC environment
Enterprise Manager
Enterprise manager configuration for RAC, emctl commands for EM, Administrating services with EM, Administering Alerts with EM,Configuration of backup with EM
RAC administration with srvctl commands
Starting and stopping instances and database,Managing services with srvctl commands,New features of DBCA in 10 g,Installation of OCFS2
RAC Performance Tuning
Determine RAC specific tuning,Automatic Workload Repository and Automatic Database Diagnostic Monitor in RAC,EM Cluster Database Performance pages
Hard �
disk
Layout,
Configurating
Multi-OS
on the
same
hard
Drive
Understanding
about
disk
partitions.
Installation
of
Solaris
on
Pentium
and
SPARC
observing
various
options
(Interactive,
Web
start
methods).
Exploring
Solaris
common
Admin.
Commands
Introduction
to CDE,
Opeenwin
and
Admin
Tool.
Installation
Ans-Book
2
Day2
Understanding
Partitions
and
Slices
of
Solaris.
Creating
Swap
space
and
UFS
File
Systems
and
Mounting
/
Unmounting
File
System.
File
System
Maintenance,
open
Boot
Prompt
(OBP)
commands
On
SPARC
Day3
Managing
system
and
user
Accounts
in
Unix-Customizing
User
environments.
Details
about
shell,
profiles
home
dir
and
Impl.
Disk-Quotas.
Solaris
systems
Start
ups
and
Shut
downs
Processes
Creating
shell
programs
in/etc/rc
directories.
Day4
Introducing
to
Networking.
TC/IP
Concepts,
Clients/Server.
Architecture.
Understanding
TCP/IP
application
Telnet,
ftp,
rlogin,
rep,
rsh,
etc.
Day5
Configuring
Printers,
dump-terminals,
adding
second
hard
disk
in
Solaris.
Understanding
NFS,
cache
FS,
Auto-mounting.
Day6
Understanding
and
Implementation
of
DHCP
Understanding
and
Implementing
of DNS
Day7
Understanding
and
Implementation
of NIS
Day8
Automation
of
jobs
in
Unix-FIND,
CRON,
AT,
NOHUP.
SAMBA
(SWAT)
&
APACHE
Configuration.
Day9
Observing
and
Tuning
system
performance
of
CPU,
Memory
and
Disk
activities
by
using
sar
commands
&
Security
issues
( ACLs
,
Sticky
bit ,setuid
and
Setgid
)
Day10
Backup
and
Recovery
using
tar,
cpio
ufsdump
and
ufsrestore.
Configuring
SCSI
Tape
Drives.
"Introduction
to
Oracle
11g.
Introduction
to
Oracle
DBA,
Oracle
Architecture,
Physical
and
Logical
structures
including
Oracle
Instance,
Database
Creation.
"
Creation
of
Users,
Roles,
Profiles
and
Privileges,
Grants
and
Revokes,
Password
file
Management,
Undo
management
and Flashback in Oracle
Day4
Undo
management
and
Flashback
in
Oracle
10g,Redolog
file
and
control
file
Management.
Archivelog
and
Noarchivelog,Modes.
OMF
management.
Day5
Oracle Utilities: Export, Import implementing logical backups using Incremental and cumulative backups. TTS for single partition.,SQL*Loader, Data Pump.
Day6
Physical
Backup
- Cold
backup
using
Unix
commands
(cpio,
tar) -
cases
on
recovery
Including
Noarchivelog
mode
and
Archivelog
mode.
HOT
Backups
and
cases
recoveries
using
HOT
Backups.
Day7
Recovery
Manager
(RMAN):
Backups
&
copies
using
RMAN,
Incremental
and
Cumulative
Backups,
recovery
Scenarios
using
RMAN
Day8
Performance
Tuning
with
CPU,
I/O
and
MEMORY,
Application
Tuning
using
TKPROF,
Explain
Plan, and AWAR/ASH/ASMM/DDM, Result Cache
Day9
Introduction to Data Guard, Configuring Data Guard, Switchover, failover, snapshot standby database, Dataguard protection modes.
Day10
Partitioning: Range partitions, Hash partitions & List partitions, Oracle Advanced Indexing: Function based Indexes, Bitmap Indexes, Reverse Indexes, Descending Indexes Index -Organized - Tablets, Partionining Enhancements.
Day11
Configuring
Multi
Threaded
Servers
(MTS)
Designing
an
Audit
Plan
and
Enabling
and
Disabling
Auditing.
Logminer,
Resumable
space
management Row migration and Row Changing,
Day12
Oracle 11g r2 Installation on Linux 5.3. Oracle ASM (Automatic Storage Management).
Introduction
to
Veritas
Volume
Manager
(VXVM,
VXFS &
VMSA).RAID
TECHNOLOGIES,
Installation
and
Interfaces,
Virtual
Objects
Day2
Managing
Disks
and
Disk
Groups,
Creating
Volumes,
Configuring
Volumes,
Reconfiguring
Volumes
online,
snapshots.
Day3
Encapsulation
and
Rootability,
Recovery
Essentials
Plex
Probems
and
Solutions,
Monitoring
Performance.
Mirroring
Root
Disk
for
High
Availability.
Day4
Storage
Technologies
Direct
Attach
Storage
(DAS),
Network
Attach
Storage
(NAS),
Storage
Area
Network
(SAN).
Day5
Implementing
Veritas
Clusters
over
SAN.VCS
Building
Blocks,
Preparing
a Site
for
VCS
Implementation,
Installing
VERITAS
Cluster
Server,
Preparing
Services
For
High
Availability,
Cluster
Communications,
Clustering
NFS.
Day6
Veritas
Netbackup
Installing
Netbackup,
Netbackup
Essentials,
Configuring
Devices,
Configuring
Storage
Units,
Configuring
Media,
Configuring
Policies:
Attributes
And
Schedules,
Performing
Manual
Backups,
Using
Debug
Logs
And
Reports,
Performing
Restores,
Using
Debug
Logs
And
Reports.
Introduction
to DWH
Characterstics
of DWH
OLTP,
OLAP
Databases
ROLAP,MOLAP
&
HOLAP,
Data
Mining,
DWH
Architecture,
Approaches
:
Kimball
V/s
Inmon
, Data
Cleansing
ETL
Concepts,
Meta
Data,
Data
Warehouse
&
Marts
Multidimensional
Cubes,
Warehouse
Modeling
Day2
Case
Study:
Sales
Schema
ERWIN
4.1
Day3
Informatica
Suite
Components,
Informatica
Power
Center
7.1,
Components,
Informatica
Architeture,
Configuration
of
Repositor
Server
&
Informatica
Server,
Basic
ETL/Network
Demo
