ORACLE DBA 12C ONLINE COURSE TRAINING

INTRODUCTION & COURSE CONTENT

• CREATING GROUP
• CREATING USER
• PASSWORD ASSIGNING
• CREATING DIRECTORY PATH
• PERMISSIONS
• OWNERSHIP
• BASH PROFILE CONFIGURATION
• EXECUTING BASH PROFILE
• XHOST +
• INSTALLING ORACLE SOFTWARE
• CREATING DATABASE
• BASIC INSTALLATION METHOD
• EXECUTING SCRIPT
• ADVANCED INSTALLATION METHOD
• DBCA CONFIGURATION METHOD
• MANUAL DATABASE CREATION
• CONNECTING TO DATABASE
• VIEW DATABASE NAME 

Data Creation 

  • BASIC INSTALLATION
  • ADVANCE INSTALLATION
  • DB_RECOVERY_FILE_DEST
  • FLASH RECOVERY AREA
  • ARCHIVE LOG MODE
  • NO ARCHIVE LOG MODE
  • REDO LOG
  • DBCA INSTALLATION
  • MANUAL DATABASE
  • CREATION OF PARAMETER FILE
  • CREATING CONTROL FILE
  • EXECUTING SCRIPTS
  • DATA DICTIONARY VIEWS
  • PACKAGES AND PROCUDURES
  • USERS,ROLES AND PRIVILIGES

 Oracle Networking services  

• TCP IP CONFIGURATION
• PING TESTING
• TROUBLESHOOT
• LISTERNER CONFIGURATION
• TNS NAMES CONFIGURATION
• NETCA TOOL
• PORT RANGE CONFIGURATION
• ORACLE_HOME/NETWORK/ADMIN
• LISTERNER SERVICES
• BOUNCING SERVICES
• STOPPING SERVICES
• STARTING SERVICES
• MONITORING SERVICES
• TESTING CONNECTIVITY
• CLIENT SIDE CONFIGURATION
• LINUX CLIENT
• WINDOWS CLIENT
• INSTALLING ORACLE CLIENT SOFTWARE
• CONFIGURE NETCA TOOL
• ORACLE_HOME/NETWORK/ADMIN/TNSNAMES.ORA
• FINAL TEST AND LOGIN  

CONNECTING TOOLS TO DATABASE

  • SQL
  • DATABASE SERVER CONFIGURATION
  • LISTERNER CONFIGURTAION
  • TNSNAMES CONFIGURATION
  • MONITORING SERVICES
  • BOUNCING SERVICES
  • NET SERVICE NAME CONFIGURATION

USER MANAGEMENT SECURITY  

• CREATION OF USER

• CONNECTING USER TO DATABASE
• CREATING ROLE
• ASSIGNING PRIVILEGE TO ROLE
• ASSIGNING ROLE TO USER
• REVOKING PRIVILEGE FROM ROLE
• DISPLAY USER ROLES
• DISPLAY USER PRIVILEGES
• USER PASSWORD ASSIGNING
• USER LOCKING
• USER UNLOCKING
• DROPPING USER
• DROPPING USER CASCADE
• DEFAULT TEMPORARY TABLESPACE
• DEFAULT PERMANENT TABLESPACE
• QUOTA CONFIGURATION
• ASSIGNING SIZE TO USERS
• INCREASING QUOTA
• DECREASE QUOTA
• REVOKE QUOTA
• ASSING UNLIMITED QUOTA
• PROFILES CONFIGUATION
• PASSWORD CONFIGURATION
• KERNEL CONFIGURATION

Oracle Instance 

  • SYSTEM GLOBAL AREA
  • BACKGROUND PROCESS
  • RAM MEMORY
  • VERIFYING BP
  • DATABASE BUFFER CACHE
  • ALGORITHM TO UNDERSTAND
  • DATABASE WRITER
  • .DBF
  • REDOLOG BUFFER CACHE
  • LOG WRITER
  • REDOLOG GROUP
  • REDOLOG MEMBERS
  • LOG WRITER
  • SWITCHING LOGS
  • MANUAL SWITCHING
  • ARCHIVE LOG MODE
  • NO ARCHIVE LOG MODE
  • FLASH RECOVERY AREA
  • REDO LOG MULTIPLEXING

 REDO LOG FILE  MANAGEMENT 

ORACLE INSTANCE FAILURE
• CHARACTERISTICS OF REDOLOG FILE
• REDOLOG ALGORITHM
• REDOLOG MULTIPLEXING
• LOG FILE
• LOG
• DISPLAY REDOLOG GROUPS
• VIEW REDOLOG MEMBERS
• REDOLOG CREATION
• DROP REDOLOG GROUP
• ADDING MEMBER TO REDOLOG GROUP
• VIEW STATUS
• MANUAL SWITCHING
• DROPPING MEMBES FROM GROUP
• CONFIGURE DATABASE IN ARCHIVE MODE
• CONFIGURE DATABASE IN NO ARCHIVE MODE
• CONFIGURE FLASH RECOVER AREA  

Control File Management  

  • ORACLE INSTANCE STARTUP PROCESS
  • PHYSICAL FILES
  • DATABASE OPEN STAGE
  • CHARACTERISTICS
  • PARAMETER FILE
  • SERVER PARAMETER FILE
  • ADVANTAGES
  • DISADVANTAGES
  • CONFIGURING PARAMETER FILE
  • COFIGURING SERVER PARAMETER FILE
  • UNDERSTANDING SPFILE SCOPE
  • HOW TO CREATE SPFILE FROM PFILE
  • HOW TO CREATE PFILE FROM SPFILE
  • MULTIPLEXING FOR CONTROL FILES
  • IMPLEMENTING MULTIPLEXING
  • TESTING MULTIPLEXING

CONTACT US