Overview
-
Oracle 12c is the leading relational database management system. Learn the fundamentals for installation, configuration, and administration of an Oracle database.
Syllabus
-
Introduction
- Welcome
- Target audience
- Exercise files
- Learning supports
- Database instance
- Database storage
- Server processes
- System global area
- Shared pool
- Buffer cache
- Redo log buffer
- Other SGA pools and the PGA
- SGA and PGA sizing
- Database writer
- Log writer
- Checkpoint process
- SMON process
- PMON process
- RECO process
- LREG process
- Archiver process
- Oracle listener
- TNSNAMES.ORA config files
- How client connections work
- Database storage file types
- Datafiles and tablespaces
- Special Oracle tablespaces
- Redo log files
- Control files
- Backup files
- Additional storage files
- Benefits of the 12c architecture
- New vs. old
- Backward compatibility
- Startup
- Shutdown
- Prerequisites for installation
- O/S configuration
- Download the software
- Install software
- Use NETCA to create a listener
- Use DBCA to create a database
- SQL *Plus for administration
- SQL Developer for development
- Oracle Enterprise Manager
- Start and stop the instance
- Start and stop the listener
- View and set parameters
- Create users and assign permissions
- Data dictionary
- Troubleshoot using the Alert Log
- Storage: Tablespaces and datafiles
- Next steps
