Oracle Database 11g: Database Creation, Instance Management, and Connectivity
Identify the steps for creating a new Oracle Database 11g database and then configuring it and managing the instance, and also recognize the steps for configuring new Oracle Net Listeners and database connectivity.
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators
A working knowledge of SQL
Expected Duration (hours)
Lesson Objectives Oracle Database 11g: Database Creation, Instance Management, and Connectivity
recognize the steps for creating, configuring, or deleting a database using the Database Configuration Assistant (DBCA), and also for managing a database instance using various Oracle tools.
recognize the scope and capabilities of Oracle Database 11g initialization parameters and identify the steps for maintaining them.
recognize the steps for configuring database startup and shutdown options, administering a blackout, and using alerts and dynamic data to assess database performance.
recognize the steps for using the Data Dictionary to find information about users, objects, constraints, and storage.
create a database using the DBCA and manage instances using Enterprise Manager.
recognize ways of configuring and managing the Oracle network, and identify the steps for creating a new Oracle Net Listener via Enterprise Manager.
identify the steps for connecting to an Oracle Database 11g database using different naming methods as well as advanced connection options, and identify when to employ connection pooling.
identify the steps for using and configuring Oracle Net Services in a given scenario.