Assumption:

ORACLE_SID=viper
ORACLE_HOME=/oracle/OraHome1

Database Server

• init.ora

Listener

• $ORACLE_HOME/network/admin/listener.ora

Client

• $ORACLE_HOME/network/admin/tnsnames.ora
• $ORACLE_HOME/network/admin/sqlnet.ora

Sample Script for Create new Database on Unix Platform

$ cd viper
$ ls -al
total 24
drwxr-xr-x 2 orasys dba 8192 Feb 21 01:51 .
drwxr-xr-x 5 orasys dba 8192 Feb 21 01:49 ..
-rwxr-xr-x 1 orasys dba 369 Feb 25 00:04 myviper.sh
-rwxr-xr-x 1 orasys dba 200 Feb 21 01:51 viperalterTablespace.sh
-rwxr-xr-x 1 orasys dba 599 Feb 24 22:13 viperrun.sh
-rwxr-xr-x 1 orasys dba 2252 Feb 21 01:51 viperrun1.sh
-rwxr-xr-x 1 orasys dba 374 Feb 21 01:51 viperrun2.sh
-rwxr-xr-x 1 orasys dba 158 Feb 21 01:51 vipersqlplus.sh
$