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;
 
 

No comments:

ORA-01552: cannot use system rollback segment for non-system tablespace 'TEMP'

 ORA-01552: cannot use system rollback segment for non-system tablespace "string" Cause: Used the system rollback segment for non...