User`s guide

Creating a Database
4-6 Oracle Database Installation and Administration Guide
Database block size given in the init.ora parameter DB_BLOCK_SIZE , refer to
Appendix C, "Initialization Parameters and the Parameter File".
For example, if you want to create a 2 MB
database file, then you must specify 1024
plus 1 PAM pages extra Oracle Database block as the value of file size in the
FILE
command.
device specifies the device to be used to store the file.
volser specifies the volume to be used to store the file.
The names used in the preceding examples are the default database and log file names.
If you want to use
other names, then remember to use these names in the SQL
CREATE
DATABASE
statement, when creating the database.
4.1.3.2.2 Modifying the Initialization File Determine what changes, if any, you want to
make
to parameters in the distributed initialization file,
sid.DBS.INIT.ORA (where sid
is the database ID for the database). The SGA parameters may need to be adjusted to
reflect memory limitations and the maximum number of users who can access the
Oracle Database system at one time. Make the modifications using a BS2000 editor.
See Also: Refer to Oracle Database Reference for an explanation of
initialization parameters
4.1.3.2.3 Modifying the ORAENV File Modify the environment definition file,
sid.P.ORAENV
, according to the specific requirements. Remember that a number of
variables are evaluated during startup only. If you modify the
ORAENV file later on, then
you may have to wait for the next startup for the changes to become effective.
The character set in the
ORAENV variable NLS_LANG , however, must not be changed
when you run some delivered SQL scripts.
4.1.3.2.4 Using SQL*Plus to Create the Database Remember that you must call the
appl
icable
sid.P.ORAENV procedure before calling SQL*Plus. To execute SQL*Plus,
enter the following command:
/START-PROGRAM $ORAC1120.SQLPLUS
* /NOLOG
SQL> CONNECT / AS SYSDBA
SQL> STARTUP NOMOUNT [PFILE=file
name]
/NOLOG omits being prompted for user name/password. CONNECT gives you a
connection to an idle instance. The last statement starts the Oracle Database instance. If
you want to use your own copy of the initialization file (
sid.DBS.INIT.ORA ), then use
the
PFILE=filename option, as illustrated in the previous command.
SQL> CREATE DATABASE...;
This statement creates database and log files.
Note: If you get an error before the first SQL> prompt, then it may be
caused by either a missing
ORAENV file (or ORASID not set in the
ORAENV ), or sometimes by an address space conflict. For example, the
address range you assigned to the kernel memory pool (
KNL_BASE )
could be occupied by a subsystem.