Database Reference
In-Depth Information
Our recommendation is with letting the OS to authenticate the
database administrator and not to create a separate external
password file. The utility used to create password file is
ORAPWD.
Manual Database Design: Step 4
Create Initialization Parameter File
In ORACLE_HOME/dbs directory you can find generic
initialization files templates e.g. one for data warehouse
database, one for Online Transactional Processing (OLTP)
database and one for combination database. Select the one that
suits your needs and change its contents or add new parameters.
Finally save it with the name shown below.
init<SID>.ora
Where <SID> would be name you decided on in the beginning
and which is also your environment variable ORACLE_SID.
Edit this file and change the following parameters according to
your needs.
DB_NAME
It will be your database name and it should not be eight
characters in length e.g.,
DB_NAME=mydb
DB_DOMAIN
It will be text string which identifies the network domain where
the database is hosted e.g.,
DB_DOMAIN=takveen.com
CONTROL_FILES
This parameter defines the control file names and location to be
used to create the new database. If you fail to specify the
Search WWH ::
Custom Search