Oracle® Database Administrator's Guide 11g Release 1 (11.1) Part Number B28310-04 |
|
|
View PDF |
After you plan your database using some of the guidelines presented in this section, you can create the database with a graphical tool or a SQL command. You typically create a database during Oracle Database software installation. However, you can also create a database after installation. Reasons to create a database after installation are as follows:
You used Oracle Universal Installer (OUI) to install software only, and did not create a database.
You want to create another database (and database instance) on the same host computer as an existing Oracle database. In this case, this chapter assumes that the new database uses the same Oracle home as the existing database. You can also create the database in a new Oracle home by running OUI again.
You want to make a copy of (clone) a database.
The specific methods for creating a database are:
With Database Configuration Assistant (DBCA), a graphical tool.
With the CREATE
DATABASE
SQL statement.
See "Creating a Database with the CREATE DATABASE Statement"
Database creation prepares several operating system files to work together as an Oracle Database. You need only create a database once, regardless of how many datafiles it has or how many instances access it. You can create a database to erase information in an existing database and create a new database with the same name and physical structure.
The following topics can help prepare you for database creation.
Prepare to create the database by research and careful planning. Table 2-1 lists some recommended actions:
Table 2-1 Database Planning Tasks
Action | Additional Information |
---|---|
Plan the database tables and indexes and estimate the amount of space they will require. |
Part II, "Oracle Database Structure and Storage" |
Plan the layout of the underlying operating system files your database will comprise. Proper distribution of files can improve database performance dramatically by distributing the I/O during file access. You can distribute I/O in several ways when you install Oracle software and create your database. For example, you can place redo log files on separate disks or use striping. You can situate datafiles to reduce contention. And you can control data density (number of rows to a data block). If you create a Flash Recovery Area, Oracle recommends that you place it on a storage device that is different from that of the datafiles. |
Oracle Database Performance Tuning Guide Oracle Database Backup and Recovery User's Guide Your Oracle operating system–specific documentation, including the appropriate Oracle Database installation guide. |
Consider using Oracle-managed files and Automatic Storage Management to create and manage the operating system files that make up your database storage. |
Chapter 15, "Using Oracle-Managed Files" Oracle Database Storage Administrator's Guide |
Select the global database name, which is the name and location of the database within the network structure. Create the global database name by setting both the |
"Determining the Global Database Name" |
Familiarize yourself with the initialization parameters contained in the initialization parameter file. Become familiar with the concept and operation of a server parameter file. A server parameter file lets you store and manage your initialization parameters persistently in a server-side disk file. |
"About Initialization Parameters and Initialization Parameter Files" "What Is a Server Parameter File?" |
Select the database character set. All character data, including data in the data dictionary, is stored in the database character set. You must specify the database character set when you create the database. If clients using different character sets will access the database, then choose a superset that includes all client character sets. Otherwise, character conversions may be necessary at the cost of increased overhead and potential data loss. You can also specify an alternate character set. Caution: Do not confuse Oracle Database database character set Using database character set |
Oracle Database Globalization Support Guide |
Consider what time zones your database must support. Oracle Database uses one of two time zone files as the source of valid time zones. The default time zone file is |
"Specifying the Database Time Zone File" |
Select the standard database block size. This is specified at database creation by the The |
"Specifying Database Block Sizes" |
Determine the appropriate initial sizing for the |
|
Plan to use a default tablespace for non- |
"Creating a Default Permanent Tablespace" |
Plan to use an undo tablespace to manage your undo data. |
|
Develop a backup and recovery strategy to protect the database from failure. It is important to protect the control file by multiplexing, to choose the appropriate backup mode, and to manage the online and archived redo logs. |
Chapter 10, "Managing the Redo Log" Chapter 11, "Managing Archived Redo Logs" Chapter 9, "Managing Control Files" Oracle Database Backup and Recovery User's Guide |
Familiarize yourself with the principles and options of starting up and shutting down an instance and mounting and opening a database. |
Chapter 3, "Starting Up and Shutting Down" |
Before you can create a new database, the following prerequisites must be met:
The desired Oracle software must be installed. This includes setting various environment variables unique to your operating system and establishing the directory structure for software and database files.
Sufficient memory must be available to start the Oracle Database instance.
Sufficient disk storage space must be available for the planned database on the computer that runs Oracle Database.
All of these are discussed in the Oracle Database Installation Guide specific to your operating system. If you use the Oracle Universal Installer, it will guide you through your installation and provide help in setting environment variables and establishing directory structure and authorizations.