This chapter introduces major components of Oracle9i. The objectives important to this chapter are:
The text offers a list of steps for creating an Oracle database from scratch. Each step has several parts:
Requirements to perform a database creation:
The initial settings for your database are broken into three groups: DBA authentication, file management, and initial parameters.
Database Administrator (DBA) Authentication refers to two methods that can prove to the system that a user has the rights needed to manage the database. The text refers to two roles that have theses rights: SYSDBA and SYSOPER. Both roles are defined on the system when it is installed. Both may be used to start and stop the database, back it up, and modify components. The SYSDBA role also has the rights needed to create an instance, recover an instance, and create or maintain tables and data. Typically, the SYSDBA role is granted the ADMIN option, giving it the right to grant any of its rights to other users.
The methods of actually authenticating to the system are Operating System (OS) authentication and password authentication.
You can set up groups in your operating system that are granted rights to the database, which allows your users to log on to the operating system of the server, instead of logging on to the database. Separate groups are used to represent the SYSDBA role (OSDBA group in UNIX, ORA_DBA group in Windows) and the SYSOPER role (OSOPER group, must be manually set up in UNIX or Windows).
The text recommends using a password file when your admins need to access the system over web links or other non-secure channels. A password file of this sort is just for the admin users. It will be named pwdora92.ora if you are using Oracle 9i revision 2. To use this option, set the REMOTE_LOGIN_PASSWORDFILE initialization parameter to EXCLUSIVE and create a password file using the orapwd utility. The syntax to create this file from the command line requires you to know the path to where it should be stored (in your database directory), the password you want to use for your admin users, and the maximum number of admin users you will allow to log on simultaneously with this file. Use the command like this:
orapwd file=drive_letter:path_to_file\filename password=admin_password entries=number_of_admins
The text gives some general advice and some specific choices about file management. Generally, it recommends that you multiplex control files and redo log files, because of their importance to the functions of your system. Multiplexing means to store multiple copies of these files on separate hard drives, and to update all changes to those files in real time.
Without coming out and saying so, the text informs us that the DBA will do a lot of work if he decides to implement User Managed Files, as opposed to Oracle Managed Files (the default). One reason is that Oracle will require that space be allocated for the files, and that space must change as data files outgrow their current space allowances. Another reason is that the Oracle Managed files option will allow Oracle to create new files, including related control files, on the fly as needed. The recommendation is to use Oracle Managed files.
Initialization parameters are settings that affect how the system runs. They are stored in a file whose name starts with init, ends with .ora, and has your system identifier in between. There are over 200 initialization parameters. If you don't set one in your initialization file, it is set to its default value by Oracle. The parameters are classified as:
Two parameters are listed that are Static (permanent):
Three other parameters are listed as examples whose values should not be changed after setting:
When creating a database, you have two choices: the CREATE DATABASE command, or the Database Configuration Assistant. As stated in the text, the CREATE DATABASE command is more flexible, but the Database Configuration Assistant will provide an interface that prevents leaving out any steps. On the other hand, when you use the manual method you can allow larger tablespaces and larger files than the choice offered by Database Configuration Assistant. A disadvantage to this method on a Windows system is you have to modify the Windows Registry by hand to make the database available.
After creating a database, it will be necessary to create a Net Service that will use it. This includes creating a Database Service Name, and changing port settings if necessary. After making this connection, you can use Instance Manager to start, stop, and restart the database.
You can also perform a manual start or stop for a database. Neither procedure is very intuitive.
Stopping a database manually:
Starting a database manually: