|
PishonTech-XTRA Series - Oracle Database: Advanced Projects/Labs
Any person with basic aptitude for information technology who is motivated to learn
and driven to succeed can become a successful IT professional. We also recognize that entering an IT career
may seem overwhelming and our team approach to teaching ensures our students are supported at every step.
our instructors offer tremendous knowledge, professional accomplishment and real-world credibility.
Their expertise is sought and respected because they’ve earned it. Many have worked as commercial
software developers and Database Administrators for leading U.S. companies and been responsible for major projects.
PishonTech-XTRA Series consist of carefully designed Projects to ensure our graduates exit the program
highly trained and ready to contribute – to hit the ground running PishonTech-XTRA Series takes the Database Administrator beyond
Intermediate level to advanced features including Installation and configuration of Windows and UNIX Servers, Oracle Grid Infrastruture,
Automatic Storage Management(ASM), Enterprise Manager Cloud Control, Active Standby Database (Dataguard) and
Real Application Cluster (RAC).
|
|
AdminI_Lab01A - Install Oracle on Windows 2008 Server_ptlearn11gwin
The Windows System Administrator has provided a Windows 2008 Server. You will Install Oracle 11gR2
and configure inbound/outbound oracle related traffic on the Windows Firewall. You will also install/configure Oracle 11g Client on your Windows 7/8 workstation;
and define connection to the database using SQL*Plus, Oracle SQL Developer and Oracle Enterprise Manager (OEM)
|
|
|
AdminI_Lab01B - Install Oracle on Windows 2008 Server
In this Lab, you will install and configure a Windows 2008 Server on a new Machine and create Windows Users/Groups, enable
remote Desktop, Fixed IP address/DNS/ Default Gateway, configure inbound / outbound oracle related traffic on the Windows
Firewall, You will Install Oracle 11gR2 (Software only), configure TNSNAMES, SQLNET and multiple LISTENERs using NETCA
and NETMGR; and create OLTP database using DBCA. You will also install/configure Oracle 11g Client on your Windows 7/8 workstation and define connection to the database
using SQL*Plus, Oracle SQL Developer and Oracle Enterprise Manager (OEM)
|
|
|
AdminI_Lab02A - Install Oracle on Linux_ptlearn11g64
The UNIX System Administrator has provided a Red Hat Linux server. You will Install Oracle 11gR2
and configure inbound/outbound oracle related traffic on the Linux Firewall. You will also install/configure
Oracle 11g Client on your Windows 7/8 workstation; and define connection to the database using
SQL*Plus, Oracle SQL Developer and Oracle Enterprise Manager (OEM)
|
|
|
AdminI_Lab02B - Install and Configure Linux and Oracle 11gR2
In this Lab, you will install and configure a Red Hat Linux Server on a new Machine; and create UNIX Users/Groups/Directories,
set kernel parameters/xhost/Fixed IP address/DNS/Default Gateway, Install appropriate packages, configure inbound / outbound oracle related traffic on the
UNIX Firewall. You will learn SSH, FTP, SFTP You will Install Oracle 11gR2 (Software only), configure TNSNAMES, SQLNET and multiple LISTENERs using
NETCA and NETMGR;and create OLTP database using DBCA. You will also install/configure Oracle 11g Client on your Windows 7/8 workstation and define connection to the database
using SQL*Plus, TOAD for Oracle and Oracle Enterprise Manager (OEM)
|
|
|
AdminI_Lab04 - RMAN Hot & Cold Backup and Archivelog Mode
In this Lab, you will configure backup settings using Enterprise Manager and perform a Cold backup using RMAN.
Switch the database to Archive log mode , perform Hot/Cold as well as view backup report using RMAN.
|
|
|
AdminI_Lab05 - Using Data Pump & SQL Loader to Move Data
In a typical production environment, there is the constant need to move data from non-oracle source into Oracle
Database as well as move data between Oracle Databases. In this lab, you will use SQL*LOADER and Data Pump
utilities to move a Flat file and a Table. Use the attached script as a guide to designing a UNIX script to
automate the process.
|
|
|
AdminII_Lab06 - RMAN Restore-Recover,loss of Control file and Data file
In this Lab, you will simulate disaster by deliberately deleting 1 control file and 1 data file; and
implementing RMAN restore/recovery steps as well as recreating the Server Parameter file to get your
database working again. You will also multiplex control file and redo log on a new disk as part of
your disaster recovery strategy.
|
|
|
AdminII_Lab07A - Clone ORACLE_HOME
In this Lab, you will clone a copy of ORACLE HOME from Production (Prod) Server to Development (DEV) Server.
This is a critical skill set for a DBA.
Sample Video 1
|
|
|
AdminII_Lab07B - Clone Database Using RMAN Duplicate (Stage)
In this Lab, you will create and configure a Stage copy of Oracle
Database from Production (Prod) and retain the ORACLE_SID. This is a critical skill set for a DBA.
|
|
|
AdminII_Lab07C - Clone Database Using RMAN Duplicate (DEV)
In this Lab, you will create and configure a Development (DEV) copy of Oracle Database from Production (Prod)
using RMAN without target connection. This is a critical skill set for a DBA.
|
|
|
AdminII_Lab08 - Install ASM Instance plus Oracle 11GR2 Database
In this Lab, you will be installing and configuring Grid Infrastructure for Automatic Storage Management
(ASM) to administer disk groups in a UNIX platform. ASMLIB will be used to mark the disks for the ASM Instance.
Oracle 11gR2 database would then be installed on the ASM File System.
Sample Video
|
|
|
AdminII_LAB09 - Applying Patches to Oracle Database
In this Lab, you will apply a patch to Oracle version 11.2.0.1.0 upgrading it to version 11.2.0.3.0 using the opatch utility. The opatch utility must be upgraded to the latest version before the patch is applied.
|
|
|
PTXTRA_LabP2 - Install and Configure Oracle 11gR2 Active Data Guard
Having implemented everything required to make your database always available (High Availability), how do you
safe guard your database from total site failure due to unforeseen fire/water/weather related disaster.
In this Lab, you will setup a replica of your production database at another geographical location using Oracle
Data Guard Infrastructure to achieve Maximum Availability.
|
|
|
PTXTRA_LabP3 - Install and Configure a 2-node RAC
This Lab will provide you step by step guidance to create a 2-node RAC environment and hands-on training administering cluster databases using Enterprise Manager and command-line utilities like SRVCTL, CRSCTL, ASMCMD and SQL*Plus.
|
|
|
PTXTRA_LabP3A - Adding a 3rd Node to a 2-node RAC
This course will provide you step by step guidance to add a 3rd Node to a 2-node RAC environment and hands-on training administering cluster databases using Enterprise Manager and command-line utilities like SRVCTL, CRSCTL, ASMCMD and SQL*Plus.
|
|
