Share
Buyer's protection
Act locally to avoid scam
Anonymous payment gateways are very unsafe
Cheques payments are not recommended
Oracle 11gR2, 12cR2 & 13cR1 DBA Course Contents(100% job guarantee)
Course Contents
1) LINUX Administration for Oracle DBA

2) SQL for Oracle DBA

3) OPERATING SYSTEM INSTALLATIONS0
 Oracle Enterprise Linux 5.5 and 6 Installations (Text Mode and Graphical Mode)
 Oracle Enterprise Linux 5.5 and 6 Installations (Text Mode and Graphical Mode)

4) ORACLE Database Creations
 Oracle Manual database creation for 11g R2 and 12c
 Oracle Database Creation Using Basic Installation Method for 11g R2 and 12c
 Oracle Advanced Database Creation for 11g R2 and 12c
 Oracle Database Creation using Database Configuration Assistant (DBCA)

5) Oracle Database 11g R2 and 12c Architecture.
 Oracle Logical Storage Structures
 Oracle Logical Database Structures.
 Oracle Physical Storage Structures.
 Oracle Instance Architecture
 Shared and Dedicated Server processes
 Oracle Memory Structures
 Database Buffer Cache
 Redolog Buffer Cache
 Shared Pool
 Large Pool
 Java Pool
 Streams Pool
 Background Processes

6) Controlling the Database
 Creating and Configuring a listener.ora and tnsnames.ora file
 For Manual Installations as well as advanced and DBCA installations.
 Starting and Stopping ISQL* Plus
 Starting and Stopping Database Control
 Changing the Listener Status
 Startup and Shutdown
 Starting Up a Database NOMOUNT
 Starting Up a Database MOUNT
 Starting Up a Database OPEN
 Shutting down the database.
 SHUTDOWN OPTIONS like Shutdown Normal, Shutdown Transactional, Shutdown Immediate and Shutdown Abort

7) TableSpace Management
 Tablespaces and Data Files
 Space Management in Tablespaces
 Creating a New Tablespace
 Storage for Locally Managed Tablespaces
 Altering a Tablespace
 Actions with Tablespaces
 Dropping Tablespaces
 Viewing Tablespace Information
 How to find the database size
 How to find used database size
 How to find free database size
 How to find the table size


8) Control files management
 Multiplexing Control files
 How to recreate a controlfiles from the trace file.
 How to take backup of a controlfile
 How to restore a controlfile

9) Redologfile Management
 How to multiplex redo log files.
 Creating Redo log groups
 How to drop redo log groups
 Adding Redolog Members to a Redolog Group
 Dropping a Redolog Member from a Group

10) Archivelog files management
 How to configure flash_recovery_area for manual database installations.
 How to configure flash_recovery_area size for manual database installations
 How to configure flash_recovery_area and flash_recovery_area size for basic, advanced and dbca installations.
 How to enable Archivelogmode
 How to change database mode from noarchivelog mode to Archivelogmode

11) Pfile and spfile
 Pfile
 Spfile
 Advantage and Disadvantages of pfile and spfile
 Creating spfile from pfile
 Creating pfile from spfile
 Creating pfile


12) Security
 Users and Resource Control
• Creating New Users
• Modifying User Settings with the ALTER USER Statement
• Removing Users
 Introduction to Profiles
• Creating Profiles
• Managing Passwords
• Controlling Resource Usage
• Dropping a Profile
 Changing User, Profile, Password, and Resource Data
 System and Object Privileges
• Identifying System Privileges
• Using Object Privileges
 Managing System and Object Privileges
• Granting and Revoking System Privileges
• Granting and Revoking Object Privileges
 Database Roles
• How to Use Roles
• Using Predefined Roles
 Creating and Modifying Roles
• Creating and Assigning Privileges to a Role
• Assigning Roles to Users and to Other Roles
• Limiting Availability and Removing Roles
 Roles in the Enterprise Manager Console
 Quotas
• Assigning Quota to User
• Altering Quota to a User
• Assigning Unlimited Quota to a User
• Removing Entire Quota from a User
 Assigning Permanent and Temporary Tablespaces to a User


13) Oracle Net Services
 Creating and configure a listener in client server environment
 Starting the Listener Server Process
 Stopping a listener process
 Oracle Networking and Database Connectivity
 Establishing Oracle Connectivity
 Listener Control Utility
 Monitoring with Listener Control
 Local Naming
 Testing Oracle Net Connectivity
 Linux Server to Linux Server Communication (DBA)
 Windows to Linux Server Communication (DBA) using putty
 Windows to Linux Server Communication by using tnsnames.ora file (DBA)
 Windows to Linux Server Communication by using Oracle 11g Client Software
 (Developer, Tester etc)
 Windows to Windows Server Communication using Remote Desktop (DBA)
 Windows to Windows Server communication using tnsnames.ora file (DBA)
 Windows Client to Windows Server Communication using Oracle 11g Client Software (Developer, Tester etc)
You must log in or register a new account in order to contact the advertiser.