MODULE 1: INFRASTRUCTURE SETUP
- INSTALLATION OF OPERATING SYSTEM
- INSTALLATION OF ORACLE ENTERPRISE LINUX IN GRAPHICAL MODE
- DISK DRUID CONFIGURATION IN INSTALLATION
- MANUAL CREATION OF SLICES
- ASSSIGNING TCP /IP TO ETHERNET
- PACKAGE SELECTION
MODULE 2: PRE INSTALLATION CONFIGURATION
- 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
MODULE 3: DATABASE 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
MODULE 4: ORACLE NETWORK 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
MODULE 5: CONNECTING TOOLS TO DATABASE
- SQL
- DATABASE SERVER CONFIGURATION
- LISTERNER CONFIGURTAION
- TNSNAMES CONFIGURATION
- MONITORING SERVICES
- BOUNCING SERVICES
- NET SERVICE NAME CONFIGURATION
MODULE 6: USER MANAGEMENT AND 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
MODULE 7: 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
MODULE 8: REDOLOG 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
MODULE 9: 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
MODULE 10: TABLESPACE MANAGEMENT
- PERMANENT TABLESPACE
- TEMPORARY TABLESPACE
- UNDO TABLESPACE
- SYSTEM .dbf
- SYSAUX.dbf
- USRERS.dbf
- Temp.dbf
- Unodtbs.dbf
- ROLL BACK
- CREATING PERMANENT TABLESPACE WITH LIMITED SIZE
- CREATING PERMANENT TABLESPACE WITH UNLIMITED SIZE
- CREATING PERMANENT TABLESPACE WITH FIXED SIZE
- ADDING DATAFILE TO EXISTING TABLESAPCE
- RESIZING DATAFILE
- TABLESPACE ONLINE
- TABLESPACE OFFLINE
- DROPPING TABLESSPACE
- AUTOEXTEND FEATURE
- DISPLAY USER TABLESPACE
- DETERMING DATABASE SIZE
- DETERMING USED DATA SIZE
- DETERMINE ALLOCATION DATA SIZE
- DETERMINE TABLESPACE SIZE
- DETERMINE TABLE SIZE