You can also create an environment script that will set all variables necessary for oracle. Example of UNIX command creating a file .env with vi editor:

vi ~/RCVCAT.env

Create new password file

Example of UNIX command which creates new password file:

orapwd FILE=$ORACLE_HOME/dbs/orapwRCVCAT PASSWORD=********

Create new parameter files

Create pfile

You can create a new file on your own or you can copy and edit sample file provided by oracle. Sample file name is init.ora and it should be located in directory $ORACLE_HOME/dbs. Example of UNIX commands:

Execute postcreation scripts

Once database is create you need to execute two final sql scripts provided by oracle. First script “catalog.sql” creates the views of the data dictionary tables, the dynamic performance views, and public synonyms for many of the views and grants PUBLIC access to the synonyms. Example of SQL command:

@?/rdbms/admin/catalog.sql

Second script “catproc.sql” runs all scripts required for or used with PL/SQL. Example of SQL command: