Step by step to create a new db 10g manually

Step1. prepare an init file and startup nomount

startup nomount

Step2. run create database SQL

create database ALEXZENG
user sys identified by oracle
user system identified by oracle
logfile
group 1 '/oracle/ALEXZENG/data01/ALEXZENG_redo1.log'  SIZE 500M,
group 2 '/oracle/ALEXZENG/data01/ALEXZENG_redo2.log'  SIZE 500M,
group 3 '/oracle/ALEXZENG/data01/ALEXZENG_redo3.log'  SIZE 500M
maxlogfiles 5
maxlogmembers 5
maxloghistory 1
maxdatafiles 100
maxinstances 2
character set UTF8
national character set al16utf16
datafile '/oracle/ALEXZENG/data01/ALEXZENG_system_01.dbf' size 512M
extent management local
SYSAUX datafile '/oracle/ALEXZENG/data01/ALEXZENG_sysaux_01.dbf' size 2048M 
default tablespace DATA datafile '/oracle/ALEXZENG/data01/ALEXZENG_data_01.dbf' size 1024M segment space management auto
default temporary tablespace TEMP01 tempfile '/oracle/ALEXZENG/data01/ALEXZENG_temp01_01.dbf' size 1024M
undo tablespace UNDOTBS01 datafile '/oracle/ALEXZENG/data01/ALEXZENG_undotbs01_01.dbf' size 1024M 
autoextend off;

Step3. create dictionary objects

spool catalog.log
@$ORACLE_HOME/rdbms/admin/catalog.sql 
spool off
spool cataproc.log
@$ORACLE_HOME/rdbms/admin/catproc.sql 
conn system/oracle
@$ORACLE_HOME/sqlplus/admin/pupbld.sql

Step4. enable archivelog

conn / as sysdba
shutdown immediate
startup mount
alter database archivelog;
alter database open;
archive log list

Finally, check the log and db component status:

SQL> col COMP_NAME for a50 
SQL> select COMP_NAME,VERSION,STATUS from dba_registry;

COMP_NAME                                          VERSION                        STATUS
-------------------------------------------------- ------------------------------ ---------------------------------
Oracle Database Catalog Views                      10.2.0.4.0                     VALID
Oracle Database Packages and Types                 10.2.0.4.0                     VALID

The total time is about 35 minutes in my test. Sometimes it is quicker than clone a existing DB. And it is clean.

You can also using DBCA silent mode to create a DB as simple as below.

1.Make a copy of the response file [install_dir]/Disk1/response/dbca.rsp
2.Edit the response file
3.dbca -silent -responseFile [response file]

Advertisements

About Alex Zeng
I would be very happy if this blog can help you. I appreciate every honest comments. Please forgive me if I'm too busy to reply your comments in time.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: