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;
No comments:
Post a Comment