As an Oracle Database administrator, it is important to plan the database to ensure that the database software is installed properly. Planning involves the logical storage structure, the overall design, and a backup strategy. It is also important to manage the database instance after the installation to ensure that it runs properly, and is started and shut down correctly to avoid problems. This course describes the DBA tasks to plan a database installation and how to use the Database Configuration Assistant (DBCA) to install the Oracle Database 11g software. It demonstrates how to manage the instance, including setting initialization parameters, accessing the database and Enterprise Manager, viewing information about the instance, startup and shutdown stages, and viewing the alert log to ensure that there are no issues with the instance. This course also demonstrates how to use Oracle Restart to manage components.
This course is one of a series in the Skillsoft learning path that covers the objectives for the Oracle Database 11g: Administration I (1Z0-052) exam. Passing this exam will earn the learner Oracle Certified Associated (OCA).
Database Creation and Access
- plan a database
- choose the character set for the database
- configure a database using the DBCA
- access a database instance using various Oracle tools
- recognize the scope and capabilities of database initialization parameters
- modify database initialization parameters
- configure database startup and shutdown options
- assess database performance and metadata information
- use Oracle Restart to manage components
- create a new database
- stop and start the database