Manually create Oracle_10g_database

Manually create Oracle_10g_database

Database name:-bsnl

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

[oracle@prasadadmin]$ mkdir bsnl
 
[oracle@prasadadmin]$ cd bsnl/
 
[oracle@prasadadmin]$ mkdir bdump

[oracle@prasadadmin]$ mkdir cdump

[oracle@prasadadmin]$ mkdir udump

[oracle@prasadadmin]$ mkdir adump

[oracle@prasad~]# cd  /10g/oracle/product/10.2.0/db_1/dbs
[prasad123@prasaddbs]$ 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@prasad~]$ cd /10g_install/app/oracle/oradata/

[oracle@prasadoradata]$ 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@prasad~]$ cd /10g_install/app/oracle/oradata/

[oracle@prasadoradata]$ mkdir bsnl

SQL> @/10g_install/app/prasad123/oradata/cr8bsnl.sql 
 
Database created.
 
SQL> @/10g_install/app/prasad123/product/10.1.0/db_1/
rdbms/admin/catlog.sql
 
SQL> @/10g_install/app/prasad123/product/10.1.0/db_1/
rdbms/admin/catproc.sql
 
SQL> conn system/manager;
Connected.
 
SQL> @/10g_install/app/prasad123/product/10.1.0/db_1/
sqlplus/admin/pupbld.sql
 
SQL> select username from dba_users;