If you need to use a time zone that is not in the default time zone file ( timezone.dat), but that is present in the larger time zone file ( timezlrg.dat), then you must set the ORA_TZFILE environment variable to point to the larger file. Oracle Database uses one of two time zone files, located in the Oracle home directory, as the source of valid time zones. Oracle Database Globalization Support GuideĬonsider what time zones your database must support. You can also specify an alternate character set. Otherwise, character conversions may be necessary at the cost of increased overhead and potential data loss. If clients using different character sets will access the database, then choose a superset that includes all client character sets. You must specify the database character set when you create the database. "Initialization Parameters and Database Creation"Īll character data, including data in the data dictionary, is stored in the database character set. A server parameter file lets you store and manage your initialization parameters persistently in a server-side disk file. Become familiar with the concept and operation of a server parameter file. Create the global database name by setting both the DB_NAME and DB_DOMAIN initialization parameters.įamiliarize yourself with the initialization parameters will be contained in the initialization parameter file. Select the global database name, which is the name and location of the database within the network structure. Part III, " Automated File and Storage Management " Your Oracle operating system specific documentationĬonsider using Oracle-managed files and Automatic Storage Management to create and manage the operating system files that make up your database storage. And you can control data density (number of rows to a data block). You can situate datafiles to reduce contention. For example, you can place redo log files on separate disks or use striping.
ORACLE DATABASE SERVER INSTALL
You can distribute I/O in several ways when you install Oracle software and create your database. Proper distribution of files can improve database performance dramatically by distributing the I/O during file access. Plan the layout of the underlying operating system files your database will comprise. Part II, " Oracle Database Structure and Storage " Plan the database tables and indexes and estimate the amount of space they will require. Table 2-1 Planning for Database Creation Action
The remainder of this chapter discusses creating a database manually.
ORACLE DATABASE SERVER MANUAL
The Oracle Database Upgrade Guide manual contains information about upgrading an existing Oracle Database. You can upgrade your existing Oracle Database and use it with the new release of the database software.
If you are already using a earlier release of Oracle Database, database creation is required only if you want an entirely new database. See "Manually Creating an Oracle Database". Both the script and the file can be edited to suit your needs. Oracle provides a sample database creation script and a sample initialization parameter file with the Oracle Database software files. If you have existing scripts for creating your database, consider editing those scripts to take advantage of new Oracle Database features. These actions can be performed by executing prepared scripts, many of which are supplied for you. These actions include creating users and temporary tablespaces, building views of the data dictionary tables, and installing Oracle built-in packages. If you do so, you must complete additional actions before you have an operational database. You can use the CREATE DATABASE SQL statement to create a database. Please refer to Oracle Database 2 Day DBA for details information on creating a database using DBCA. You can also launch DBCA as a standalone tool at any time after Oracle Database installation to create or make a copy (clone) of a database. Use the Database Configuration Assistant (DBCA).ĭBCA can be launched by the Oracle Universal Installer, depending upon the type of install that you select, and provides a graphical user interface (GUI) that guides you through the creation of a database. You can create an Oracle Database in three ways:
ORACLE DATABASE SERVER HOW TO
Deciding How to Create an Oracle Database