User`s guide
Startup and Parameter Files
5-4 Oracle Database Installation and Administration Guide
■ The Server Parameter File SPFILE
■ Using the Correct Initialization File
5.2.1 The Environment Definition File ORAENV
The
ORAENV
file is identified by
sid.P.ORAENV
, where
SID
is the database identifier. The
same
ORAENV
file must be used by SQL*Plus in BS2000 and by all background jobs. This
is ensured by the installation procedures, which create the basic
ORAENV
file. Refer to
Appendix B, "Oracle Environment Variables", for details of required and optional
ORAENV
variables.
If you use SQL*Plus in the POSIX shell, then the requested BS2000 parameters set in
the
ORAENV
file must be specified. You can set the variables in the POSIX environment
or use the facility to access the BS2000
ORAENV
file. When specifying the
SID
in the
POSIX
ORAENV
filename, ensure that the
SID
in the filename and the
ORACLE_SID
variable use exactly the same case. For example, if you create a POSIX
ORAENV
file with
the
SID
in the filename in uppercase, then you must set the
ORACLE_SID
using exactly
the same
SID
.
$ echo '$ORADATA.ORCL.P.ORAENV' > $ORACLE_HOME/dbs/oraenvORCL
$ ORACLE_SID=ORCL
$ export ORACLE_SID
$ sqlplus /nolog
$ SQL> connect / as sysdba
Refer to "Starting Oracle Utilities in the POSIX environment" in Oracle Database User's
Guide for Fujitsu BS2000/OSD, for more information about how to set POSIX
environment variables.
5.2.2 The Initialization File INIT.ORA
Startup requires the
INIT.ORA
parameter file, which contains a list of specifications for
the Oracle database. These generic, that is, platform independent parameters, are used
to setup the instance. Refer to Oracle Database Administrator's Guide and Oracle Database
Reference for full descriptions of these parameters.
5.2.3 The Server Parameter File SPFILE
You can choose to maintain initialization parameters in a binary server parameter file.
A server parameter file is initially built from a traditional text initialization parameter
file using the
CREATE SPFILE
command. If you enter the following command:
CREATE SPFILE FROM PFILE;
where neither
SPFILE
name nor
PFILE
name is specified, then Oracle looks for a text
initialization file
sid.DBS.INIT.ORA
and creates a server parameter file
sid.DBS.SPFILE.ORA
.
5.2.4 Using the Correct Initialization File
A default initialization file, called
$ORAC1120.DEMO.DBS.INIT.ORA
, is distributed with
Oracle Database. During the database creation procedure, this file is copied to the
DBA
User ID
and renamed,
sid.DBS.INIT.ORA
, where
sid
is the 1 to 4 character database
ID you specified at the beginning of the database creation procedure.
Oracle determines the value of
SID
by retrieving the
ORASID
environment variable
defined in the
ORAENV
file for the database. When you issue the
STARTUP
command