Creating the database
We can install a new database using Database Configuration Assistant
1. The first step is to specify what action to take. Since we do not have a database created, we'll
select the Create a Database option in Step 1.
2. This step will offer the following three options for a database template to select:
General Purpose or Transaction Processing
We are going to choose the Data Warehouse option for our purposes
3. This step of the database creation will ask for a database name.
Since we're creating this database for the data warehouse of ACME Toys and Gizmos Company, we'll
choose a name that reflects this—ACME for the company name and DW for data warehouse,
resulting in a database name of ACMEDW.
As the database name is typed in, the SID (or Oracle System Identifier) is automatically filled in to
4. This step of the database creation process asks whether we want to configure Enterprise Manager.
The box is checked by default and leave it as is.
5. On this screen (step 5) we can set the database passwords on the system accounts using a different
one for each account, or by choosing one password for all four. We're going to set a single password
on all four, but for added security in a production environment, it is a good idea to make a different
password for each. Click on the option to Use the Same Administrative Password for All Accounts
and enter a password.
6. This step is about storage. We'll leave it at the default of File System for storage management.
The other two options are for more advanced installations that have greater storage needs.
7. This step is for specifying the locations where database files are to be created. This can be left at
the default for simplicity
8. The next screen is for configuring recovery options. We're up to step 8 now. If we were installing
a production database, we would want to make sure to use the Flash Recovery option and to Enable
WE-IT TUTORILAS PHNO:8097071144/55
Archiving. Flash Recovery is a feature Oracle has implemented in its database to provide a location that is managed by the database. It stores backups and files needed to recover a database in the event of disk failure. With Flash Recovery Area specified, we can recover data that would otherwise be lost in a system failure.
9. 9. This step is where we can have the installation program create some sample schemas in the database for our reference, and specify any custom scripts to run. The text on the screen can be read to decide whether they are needed or not. We don't need either of these for this book, so it doesn't matter which option we choose.
10. The next screen is for Initialization Parameters. These are the settings that are put in place to define various options for the database such as Memory options.
11. The next screen is for security settings. For the purposes of this book and its examples, we'll check the box to Revert to pre-11g security settings since we don't need the additional features. However, for a production environment, it is a good idea to leave the default checked to use Oracle's more advanced security features.
12. This step is automatic maintenance and we'll deselect that option and move on, since we don't need that additional functionality. Automatic Maintenance Tasks are tasks that run in predefined maintenance windows of time to perform various preconfigured maintenance operations on the database.
13. The next step (step 13 of 14) is the Database Storage screen referred to earlier. Here the locations of the pre-built data and control files can be changed if needed. They should be left set to the default for simplicity since this won't be a production database. For a production environment, we would want to consider storing datafiles on separate partitions for performance reasons, and to minimize the impact of disk failures on the running database if something goes wrong.
14. The final step has the following three options, and any or all can be selected for creating the database:
Create the database directly
Save the creation options as a template for later use
Save database creation scripts that can be used later to create the database
The Next button is grayed out since this is the last screen. So click on the Finish button to begin creating the database using the selections we've just chosen. It will display a summary screen showing what options it will be using to install with.