Duration: 5 days
This Oracle Database 11g R2: Administration I training class covers the administration of the Oracle database management system (DBMS) software environment and of the server systems on which the DBMS runs is one of the primary tasks required of database administrators. While it is true that the hardware and software platforms on which the DBMS runs have become increasingly complex, as has the database software itself, the capabilities provided by the Oracle database have correspondingly become more sophisticated.
The primary audiences for this course are database administrators, web server administrators, system administrators, implementation specialists, data center support engineers, and senior application designers and developers.
• Configure the Linux and MS Windows operating systems in anticipation of a database installation.
• Verifiy a valid database installation
• Explore database administrator interface options, including the use of Enterprise Manager, command-line SQL*Plus, and terminal console SSH
• Explore database deinstallation and inline software patching
• Start up and shut down database services and related software components
• Learn about super administrator authentication options
• Gain an in-depth understanding of the database architecture, including memory, process and data structures, and the management of those structures.
• Manage database files.
• Explore specialized facilities intended to maximize performance of enterprise-scale transactional applications, such as the shared SQL and PL/SQL cache, the Result Cache, the database buffer
• cache, and other similar components.
• Manage security policies and procedures, including administration of user accounts, roles, privileges and profiles.
• Utilize advanced self-tuning and self-management capabilities, including the use of Oracle-Managed Files, database Advisors and other components of the Management Framework.
• Perform monitoring, problem troubleshooting, and resolving lock and conflict issues.
Method of Delivery
• Onsite/Live class instructions or Online web conference
• Open discussion
• Case studies