Any person with a 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 consists 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 Infrastructure, 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 the 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_Lab03 - Create Tablespace_Roles_Users_Priviledges
In the next Lab, you will be creating a Tablespace, Role, User and assigning System and Object privileges.
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.
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_Lab08B - Migrating Oracle Database From File System to ASM
In this Lab, you will be migrating Oracle Database from File System to Automatic Storage Management (ASM) on a UNIX Platform.
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_LabP1 - Install Oracle Enterprise Manager Cloud Control 12c
In this Lab, you will install and configure Enterprise Manager Cloud Control 12c (Grid Control) to administer multiple databases, Instances and Servers.
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_LabP2A - Install and Configure Oracle Data Guard Broker
In this Lab, you will manually configure Oracle Data Guard Broker to administer and monitor the Primary and Standby database from the DGMGRL command-line tool.
PTXTRA_LabP2B - Install and Configure Logical Standby database / Data Guard Broker using Grid Control
In this lab, you will turn-on the server running the Enterprise Manager Cloud Control 12c to administer the Primary and Standby databases after installing appropriate Grid Control agents on both instances. You will also create a Logical Standby database using Enterprise Manager Cloud Control 12c.
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.
PTXTRA_LabP4 - Upgrade Oracle Database (11.2.0.1 - 11.2.0.3)
PTXTRA_LabP4A - Patch/Upgrade Oracle Database (11.2.0.3.0 - 11.2.0.3.6)
PTXTRA_LabP4B - Upgrade Oracle Database (11gr2 - 12c)
PTXTRA_LabP4C - Upgrade Oracle Database (10g - 12c)
PTXTRA_LabP6 - SFTP - SecureCRT, SFTP - MobaXterm, and SCP in a nutshell
PTXTRA_LabP7 - Using TOAD for Oracle
PTXTRA_LabP8- SQL and UNIX Script in a nutshell