Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

database creation in oracle 9i

643731Jun 11 2008 — edited Jun 11 2008
can any one tell me step of database creation in oracle 9i

i try many times from 2 days through script because my DBCA is not open
when i click it. DBCA created orcl during instalation but now
it is not running. will i have to install it ?

1)i add db_name=mukesh below db_name=orcl and run script but errors

2)i crete initm.ora by copy init.ora and change db_name=orcl by db_name=mukesh
in initm.ora but errors

1)when i use init.ora without adding db_name=mukesh
i also change undo_management by AUTO to manual i get

SQL> shutdown immediate;
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
SQL> startup pfile=D:\oracle\admin\orcl\pfile\init.ora nomount
ORACLE instance started.

Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
SQL> create database mukesh
2 datafile 'D:\oracle\oradata\mukesh\system01.dbf' size 325m
3 logfile
4 group 1 ('D:\oracle\oradata\mukesh\redo01.log') size 100m,
5 group 2 ('D:\oracle\oradata\mukesh\redo02.log') size 100m,
6 group 3 ('D:\oracle\oradata\mukesh\redo03.log') size 100m;
create database mukesh
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-01504: database name 'mukesh' does not match parameter db_name 'orcl'



after that i add db_name=mukesh below db_name=orcl

SQL> shutdown immediate;
ORA-01507: database not mounted

ORACLE instance shut down.
SQL> startup pfile=D:\oracle\admin\orcl\pfile\init.ora nomount
ORACLE instance started.

Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
SQL> create database mukesh
2 datafile 'D:\oracle\oradata\mukesh\system01.dbf' size 325m
3 logfile
4 group 1 ('D:\oracle\oradata\mukesh\redo01.log') size 100m,
5 group 2 ('D:\oracle\oradata\mukesh\redo02.log') size 100m,
6 group 3 ('D:\oracle\oradata\mukesh\redo03.log') size 100m;
create database mukesh
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-00200: controlfile could not be created
ORA-00202: controlfile: 'D:\oracle\oradata\orcl\CONTROL01.CTL'
ORA-27038: skgfrcre: file exists
OSD-04010: <create> option specified, file already exists
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 9 2008
Added on Jun 11 2008
12 comments
851 views