OCA: Oracle Database 11g Administrator Certified Associate Study Guide- P12: There is high demand for professionals in the information technology (IT) industry, and Oracle certifications are the hottest credential in the database world. You have made the right decision to pursue certification, because being Oracle Database 11g certified will give you a distinct advantage in this highly competitive market. | Using DBCA to Create Oracle 11g Databases 481 When the creation process is complete connect to the database with one of the tools such as SQL Plus or Enterprise Manager to ensure that all the database options and components were installed properly. Logging into Enterprise Manager will give you an overview of the new database. By using the URL specified in Figure you can invoke the Database Control home page. Log in using the SYSMAN account with the password you supplied in Figure . Figure shows the home screen of Enterprise Manager Database Control. FIGURE Enterprise Manager Database Control home page Configuring an Oracle Database Using the DBCA The DBCA lets you change various aspects of an existing database. To change the database configuration select Configure Database Options on the DBCA Operations screen shown earlier in this chapter in Figure . If the database is not started the DBCA starts it for you automatically. You must connect to the database as a user who has DBA authority. 482 Chapter 9 Creating an Oracle 11g Database Once you have selected and started the database you can add options that may not have been previously included in the database. Using DBCA you can perform the following changes to database configuration Add database components refer to Figure . Change database security settings from pre-11g default security setting to 11g enhanced security settings or vice versa refer Figure . Change the default connection mode for the database. You can change from dedicated server mode to shared server mode or vice versa refer Figure . Deleting an Oracle Database Using the DBCA You can also delete a database using the DBCA. On the Operations screen Figure choose Delete a Database and click Next to open the Database screen. The DBCA lists all the databases available for deletion. Choose the database you want to delete. If you click Finish the DBCA removes all files on the disk associated with the database you .
