 |
|
Oracle Tips by Burleson |
Describe Instance Creation
Process
After reading all of the reading assignments
for this tutorial, your task is to prepare a short management summary
(less than 500 words) that describes the process of creating a new
Oracle database instance.
Assume that the reader of your summary knows
nothing about relational databases, but wants to know why it takes
many hours to create a new instance. You paper should include:
- Sizing considerations for the data
dictionary
- Sizing for the data buffers
- Sizing of the undo logs
- Sizing the shared pool
- Creation of the OFA directories
- Creation of the init.ora file
The main points of this tutorial include:
* The Oracle 10g install wizard hides a huge
amount of complexity. The Oracle database professional must
understand the steps to manually create an Oracle database.
* Database creation begins by creating the OS
directory structure to hold the data files, init.ora file, dumps,
control files and the alert log.
* An init.ora file is required for the Oracle
database creation to tell Oracle the block size, the location of
important files and the configuration of the instance.
* Instance creation is complex because of the
almost infinite flexibility of Oracle.
* Oracle instance creation varies greatly
between server platforms, and Oracle’s Metalink should be consulted
for the OS-specific documents before creating a new database instance.
We are now ready to move on to the next
tutorial.
For more details, see the "Easy
Oracle Series" a set of books especially designed by Oracle
experts to get you started fast with Oracle database technology.
|
