Manually create Oracle_10g_database

Database name:-bsnl

[oracle@sujeet ~]# cd /10g/oracle/product/10.2.0/db_1/admin

[oracle@sujeet admin]$ mkdir bsnl

[oracle@sujeet admin]$ cd bsnl/

[oracle@sujeet admin]$ mkdir bdump

[oracle@sujeet admin]$ mkdir cdump

[oracle@sujeet admin]$ mkdir udump

[oracle@sujeet admin]$ mkdir adump

[oracle@sujeet ~]# cd  /10g/oracle/product/10.2.0/db_1/dbs

[sonujha@sujeet dbs]$ vi initbsnl.ora

initbsnl.ora file contain:-

db_name=bsnl

instance_name=bsnl

compatible=10.2.0

control_files='/10g/oracle/product/10.2.0/oradata/bsnl/

control01.ctl'

background_dump_dest='/10g/oracle/product/10.2.0/db_1/

admin/bsnl/bdump'

core_dump_dest='/10g/oracle/product/10.2.0/db_1/admin/

bsnl/cdump'

user_dump_dest='/10g/oracle/product/10.2.0/db_1/admin/

bsnl/udump'

shared_pool_size=60m

undo_tablespace=undotbs

undo_management=auto

[oracle@sujeet ~]$ cd /10g_install/app/oracle/oradata/

[oracle@sujeet oradata]$ vi cr8bsnl.sql

cr8bsnl.sql file contains:-

create database bsnl

datafile '/10g/oracle/product/10.2.0/oradata/bsnl/

system01.dbf' size 170m autoextend on

sysaux datafile '/10g/oracle/product/10.2.0/oradata/bsnl/

sysaux.dbf' size 150m autoextend on

default temporary tablespace temp tempfile '/10g/oracle/

product/10.2.0/oradata/bsnl/temp01.dbf' size 20m

default tablespace userdata datafile '/10g/oracle/

product/10.2.0/oradata/bsnl/undotbs01.dbf' size 30m

undo tablespace undotbs datafile '/10g/oracle/

product/10.2.0/oradata/bsnl/undotbs.dbf' size 30m

logfile

group1('/10g/oracle/product/10.2.0/oradata/bsnl/redo01.log') size 4m,

group2('/10g/oracle/product/10.2.0/oradata/bsnl/redo02.log') size 4m

controlfile reuse;

[oracle@sujeet ~]$ cd /10g_install/app/oracle/oradata/

[oracle@sujeet oradata]$ mkdir bsnl

SQL> @/10g_install/app/sonujha/oradata/cr8bsnl.sql 

Database created.

SQL> @/10g_install/app/sonujha/product/10.1.0/db_1/

rdbms/admin/catlog.sql

SQL> @/10g_install/app/sonujha/product/10.1.0/db_1/

rdbms/admin/catproc.sql

SQL> conn system/manager;

Connected.

SQL> @/10g_install/app/sonujha/product/10.1.0/db_1/

sqlplus/admin/pupbld.sql

SQL> select username from dba_users;