Course Content:
Concepts and Administration
§ Oracle installation in linux and
solaris
§ Configuration kernel parameters
§ Oracle architecture
§ 10G Automatic management
§ Program Global Area
§ Startup and shutdown options
§ Creating database
§ Managing control files
§ Managing log file
§ Managing tablespaces
§ Managing datafiles
§ Managing tables and indexes
§ Materialized views
§ Partitions
§ Locks
§ Data integrity
§ Space and storage parameters
§ Undo
§ temp management
§ Temporary database
§ Users
§ Roles and privilages
§ Profiles
§ Scheduler
§ DBMS_JOBS
§ Workshop with Scenarios
§ Assessments
Backup and recovery
§ Export
§ Import and Datapump
§ RAID
§ SAN
§ NAS
§ NFS Storage
§ User Managed backup(UMB)
§ UMB Cloning User Managed Recovery
§ Point in time to recover(PITTR)
§ Configuration RMAN
§ RMAN Backups
§ RMAN Cloning
§ Merge Backups
§ RMAN PITTR
§ Maintaining Recovery Catalog
§ Workshop with Scenarios
§ Assessments
Network Administrator
§ Client server configuration
§ Tnsnames
§ LDAP and Naming Servers
§ Listiner Control utility
§ Unix tools:FTP,SFTP,SCP,WINSCP
§ Workshop with Scenarios
§ Assessments
Oracle Utilities
§ Exp/imp