Skip to content

How to Create a 9i Database by DBCA with Graphic Interface

  • by
It seems that running DBCA with GUI will hang at some specific steps under x-window environments, therefore, we should avoid to step on the traps during creating a database.

Before you create a new database by DBCA with graphic interface, you should check the environmental variables are correct.
[oracle@oracle9i ~]$ echo $ORACLE_BASE
/u01/app/oracle
[oracle@oracle9i ~]$ echo $ORACLE_HOME
/u01/app/oracle/product/9.2.0

Since the fields of sid and db_name will prompt during creation to ask DBA to fill a valid value, so $ORACLE_SID is irrelevant to this operation.

Let's run the DBCA:
[oracle@oracle9i ~]$ dbca
The screenshots of these steps are as below:
  1. Welcome
  2. Select the operation
  3. Select a template
  4. Specify db_name and sid
  5. Select connection mode
  6. Set initialization parameters
  7. Database Storage
  8. Creation options
  9. Creating database
  10. Set sys and system password
The following is the summary generated by DBCA before doing creation:
Use this database template to create a pre-configured database optimized for general purpose usage.

Common Options

Option NameSelected
Example Schemastrue
Oracle Data Miningtrue
Oracle Intermediatrue
Oracle JVMtrue
Oracle Label Securityfalse
Oracle OLAPtrue
Oracle Spatialtrue
Oracle Texttrue
Oracle Ultra Searchtrue
Oracle XML DBtrue

Initialization Parameters

NameValue
aq_tm_processes1
background_dump_dest{ORACLE_BASE}/admin/{DB_NAME}/bdump
compatible9.2.0.0.0
control_files("{ORACLE_BASE}/oradata/{DB_NAME}/control01.ctl", "{ORACLE_BASE}/oradata/{DB_NAME}/control02.ctl", "{ORACLE_BASE}/oradata/{DB_NAME}/control03.ctl")
core_dump_dest{ORACLE_BASE}/admin/{DB_NAME}/cdump
db_block_size8192
db_cache_size174MB
db_domain
db_file_multiblock_read_count16
db_namesmalldb
dispatchers(PROTOCOL=TCP) (SERVICE={SID}XDB)
fast_start_mttr_target300
hash_join_enabledTRUE
instance_namesmalldb
java_pool_size20MB
job_queue_processes10
large_pool_size34MB
open_cursors300
pga_aggregate_target77MB
processes150
query_rewrite_enabledFALSE
remote_login_passwordfileEXCLUSIVE
shared_pool_size58MB
sort_area_size524288
star_transformation_enabledFALSE
timed_statisticsTRUE
undo_managementAUTO
undo_retention10800
undo_tablespaceUNDOTBS1
user_dump_dest{ORACLE_BASE}/admin/{DB_NAME}/udump

Character Sets

NameValue
Database Character Set AL32UTF8
National Character Set AL16UTF16

Data Files

NameTablespaceSize(M)
{ORACLE_BASE}/oradata/{DB_NAME}/cwmlite01.dbfCWMLITE20
{ORACLE_BASE}/oradata/{DB_NAME}/drsys01.dbfDRSYS20
{ORACLE_BASE}/oradata/{DB_NAME}/example01.dbfEXAMPLE148.75
{ORACLE_BASE}/oradata/{DB_NAME}/indx01.dbfINDX25
{ORACLE_BASE}/oradata/{DB_NAME}/odm01.dbfODM20
{ORACLE_BASE}/oradata/{DB_NAME}/system01.dbfSYSTEM370
{ORACLE_BASE}/oradata/{DB_NAME}/tools01.dbfTOOLS10
{ORACLE_BASE}/oradata/{DB_NAME}/undotbs01.dbfUNDOTBS1200
{ORACLE_BASE}/oradata/{DB_NAME}/users01.dbfUSERS25
{ORACLE_BASE}/oradata/{DB_NAME}/xdb01.dbfXDB45
{ORACLE_BASE}/oradata/{DB_NAME}/temp01.dbfTEMP41

Control Files

Control file
{ORACLE_BASE}/oradata/{DB_NAME}/control01.ctl
{ORACLE_BASE}/oradata/{DB_NAME}/control02.ctl
{ORACLE_BASE}/oradata/{DB_NAME}/control03.ctl

Redo Log Groups

GroupSize(K)
1250
2250
3250
4250
In which, "Redo Log Groups" has an error in "Size(K)", the actual unit should be "Size(M)".

Leave a Reply

Your email address will not be published.