Installation of Oracle Database Manually

There are two ways to creating an Oracle Database - either one can use the system created Database, that is created at the time of Oracle installation or can be created manually. But as for as i know the best way to practice installation of Oracle Database is Creating DB Manually.

STEPS FOR CREATION OF DATABASE MANUALLY:

1. Login as oracle user

# su – oracle

Now to get Database Configuration Assistant you need to type DBCA from Oracle User

$ dbca


Select Create Database and press NEXT



Select New Database and Press Next

Here specify your Database Name {Prod is my DB Name}
And
SID will automatically updated when we enter DB Name.

UnCheck all which are selected and press Next

Select Dedicated Server Mode and press Next

Press Next

UnCheck all And select Create Database Creation Scripts
(Path: /uo1/Prod/scripts)

And press Finish Button, All the scripts will generate in this path.

Press OK

Press NO

Create Oracle Database Init file for the database that the createdb script will Create

Example:-. If the ORACLE_SID is Prod the Init file name will be "initProd.ora"

$ vi $ORACLE_HOME/dbs/initProd.ora

Enter the parameter values, sample values are as below and a sample init file is also available in the scripts.rar

Past the init File in DBS Directory
{Path: /u01/app/oracle/product/9.2.0.4/dbs}

1. Before starting running the scripts, first modify the database name, datafile location etc.

Following are the script required to be modified:

CREATEDB.SQL -- Modify the datafile path, add the undo tablespace command to the create database statement.

UTLSPACE.SQL -- Comment the statements related to rollback and specify the path for datafiles

CREATEDB.SQL -- This script will create the database

UTLSPACE.SQL -- This script will create the pstemp & psdefault tablespace

Note : Sample modified scripts are attached herewith in file scripts.rar

Run the scripts using sqlplus as sysdba in following order:

Login as oracle user

# su – oracle

$ sqlplus /nolog

Run the remaining 2 scripts using sqlplus as sysdba

SQL>conn / as sysdba

NOW run the script CreateDB.sql

SQL>@/u01/Prod/scripts/CreateDB.sql

This script will create your Oracle DB than you need to run another script utlspace.sql.

SQL>@/u01/Prod/scripts/utlspace.sql

than Configure the LISTENER using netca wizard

Configure the TNSNAMES using netmgr

Suggestion/Troubleshooting: The tnsnames entry created by the wizard will append the network domain name with the ORACLE_SID, to remove the domain name edit the tnsnames.ora file at $ORACLE_HOME/network/admin/ and remove the domain name appended to the SID

Start the listener

$lsnrctl start

Downloading Link:

http://www.ziddu.com/download/3731987/scripts.rar.html