Oracle 12c Database: Administration

Oracle 12c is the leading relational database management system. Learn the fundamentals for installation, configuration, and administration of an Oracle database.

Introduction

• Welcome
• Target audience
• Exercise files
• Learning supports

1. Architecture

• Database instance
• Database storage
• Server processes

2. Instance Memory Pools

• System global area
• Shared pool
• Buffer cache
• Redo log buffer
• Other SGA pools and the PGA
• SGA and PGA sizing

3. Instance Background Processes

• Database writer
• Log writer
• Checkpoint process
• SMON process
• PMON process
• RECO process
• LREG process
• Archiver process

4. Client Connections

• Oracle listener
• TNSNAMES.ORA config files
• How client connections work

5. Physical Database Structures

• Database storage file types
• Datafiles and tablespaces
• Special Oracle tablespaces
• Redo log files
• Control files
• Backup files
• Additional storage files

6. Multitenant Database

• Benefits of the 12c architecture
• New vs. old
• Backward compatibility

7. Start and Stop the Database

• Startup
• Shutdown

8. Install Oracle 12c software

• Prerequisites for installation
• O/S configuration
• Download the software
• Install software

9. Create a Database Instance

• Use NETCA to create a listener
• Use DBCA to create a database

10. Tools for Developers and DBAs

• SQL *Plus for administration
• SQL Developer for development
• Oracle Enterprise Manager

11. Management

• 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

Conclusion

• Next steps