Curriculum
- 1 Section
- 22 Lessons
- 5 Days
Expand all sectionsCollapse all sections
- Topics22
- 1.1CONFIGURING THE SERVER FOR INSTALLATION IDENTIFY system requirements OPTIMAL flexible architecture (OFA) ORACLE_BASE ORACLE_HOME CONFIGURE linux installation CONFIGURE MS windows installation PREREQUISITE checs & fixup utility
- 1.2ENTERPRISE EDITION INSTALLATION MORE about the installation START the installation DESKTOP class installation 11g r2 SERVER class installation 11g r2 POST-installation configuration
- 1.3VERIFY THE INSTALLATION ACCESSING the EM database control USING the EM interface USING sql*plus USING em sql worksheet USING ssh
- 1.4UPGRADE, DEINSTALLATION & PATCHING DATABASE upgrade NETCA DBUA ONLINE patching ORACLE deinstaller
- 1.5MANUALLY STARTING & STOPPING DATABASE SERVICES STARTING & stopping database control STARTING & stopping the listener STARTING & stopping the database SYSBDA
- 1.6EXPLORING THE ORACLE DATABASE ARCHITECTURE: GENERAL THE oracle enterprise architecture GENERAL database architecture V$VERSION
- 1.7EXPLORING THE ORACLE DATABASE ARCHITECTURE: INSTANCE MEMORY MORE about database instances USING V$SGA_dynamic_components ABOUT the pga MANAGING memory
- 1.8EXPLORING THE ORACLE DATABASE ARCHITECTURE: INSTANCE PROCESSES INSTANCE background processes SQL execution processes USING V$SESSION
- 1.9CREATING AN ORACLE DATABASE CREATE a new database CONFIGURE an existing database DROP a database MANAGE DBCA templates MANUALLY create a database MORE about the database files
- 1.10ENABLING TRANSPARENT DATA ENCRYPTION TRANSPARENT data encryption MANAGING TDE IMPLEMETNING column encryption
- 1.11MANAGE DATABASE STORAGE STRUCTURES: TABLESPACES ABOUT tablespaces TABLESPACE management AUTOEXTEND options DROP tablespace ALTER tablespace
- 1.12MANAGE DATABASE STORAGE STRUCTURES: ADVANCED TABLESPACES MORE about temporary tablespaces USING V$SORT_segment ABOUT temporary tablespace groups MORE about permanent tablespaces ABOUT database_properties MORE about bigfile tablespaces MORE about the sysaux tablespace
- 1.13MANAGE DATABASE STORAGE STRUCTURES: DATA FILES & TEMP FILES MANAGING data files MANAGING temp files ENABLE oracle-managed files (OMF)
- 1.14MANAGING UNDO DATA ABOUT undo space management CONFIGURE undo management UNDO_management UNDO_tablespace UNDO_retention GUARENTEE undo retention MONITOR undo space USE the undo advisor
- 1.15NETWORK ENVIRONMENT: ORACLE NET SERVICES ORACLE net services architecture ORACLE net configuration assistant ORACLE net manager CONFIGURATION using EM TROUBLESHOOTING network problems COUNTERING database attacks NETWORK environment: oracle shared servers SHARED servers architecture CONFIGURE shared servers MONITOR shared servers V$SHARED_server V$SHARED_server_monitor V$SESSION V$CIRCUIT V$DISPATCHER & v$dispatcher_config V$QUEUE
- 1.16SECURITY: IMPLEMENTING DATABASE SECURITY DATABASE system privileges DATABASE object privileges AUDITING of database activity AUDIT_trail parameter ENHANCED default security settings
- 1.17SECURITY: ADMINISTERING USER SECURITY CREATE & managed database accounts GRANT & revoke database privileges RESOURCE limits via profiles ALTER profile DROP profile PASSWORD management via profiles ABOUT role-based security WITH admin option WITH admin option & system privileges WITH grant option & object privileges ALTER user…default role SET role ENHANCED default security settings SEC_case_sensitive_logon setting
- 1.18MOVING DATA: SQL LOADER LOADER concepts CONTROL file options LOAD methods USING the EM interface
- 1.19MOVING DATA: EXPORT & IMPORT MANAGE directory objects ABOUT the data pump architecture DATA pump import DATA pump data dictionary views USING the EM interface
- 1.20DATA MAINTENANCE & PERFORMANCE MONITORING MANAGEMENT & advisory framework MANAGE awr ADDM USE metrics & alert thresholds AUTOMATIC maintenance tasks
- 1.21MANAGING CONCURRENCY & LOCKS ABOUT latches & locks MANAGE & monitor latches V$LOCK V$LOCKED_OBJECT V$SESSION V$SESSION_WAIT DBA_BLOCKERS & dba_waiters DBA_DMI_LOCKS & dba_ddl_locks DML_LOCKS
- 1.22BACKUP & RECOVERY CONCEPTS & CONFIGURATION ABOUT backup & recovery structures MANAGING redo data MANAGING archival data AUTOMATIC crash recovery CREATING a basic backup strategy
MANAGING UNDO DATA ABOUT undo space management CONFIGURE undo management UNDO_management UNDO_tablespace UNDO_retention GUARENTEE undo retention MONITOR undo space USE the undo advisor
Prev
SECURITY: IMPLEMENTING DATABASE SECURITY DATABASE system privileges DATABASE object privileges AUDITING of database activity AUDIT_trail parameter ENHANCED default security settings
Next