DBCA to bare devices in 9i environments

sometimes need to install a 9i environment to do the test, the following describes how to DBCA in 9 to the bare device.

1creating a logical volume

Lvcreate-n spfile_8m-l 1 vg00

Lvcreate-n control1_16m-l 2 vg00

Lvcreate-n control2_16m-l 2 vg00

Lvcreate-n redo1_104m-l vg00

Lvcreate-n redo2_104m-l vg00

Lvcreate-n redo3_104m-l vg00

Lvcreate-n system_512m-l vg00

Lvcreate-n temp_512m-l vg00

Lvcreate-n undotbs1_512m-l vg00

Lvcreate-n users_16m-l 2 vg00

2Create a bare device (character device)

vi/etc/sysconfig/raw*

Add the following content

/dev/raw/raw1/dev/mapper/vg00-control1_16m

/dev/raw/raw2/dev/mapper/vg00-control2_16m

/dev/raw/raw3/dev/mapper/vg00-redo1_104m

/dev/raw/raw4/dev/mapper/vg00-redo2_104m

/dev/raw/raw5/dev/mapper/vg00-redo3_104m

/dev/raw/raw6/dev/mapper/vg00-spfile_8m

/dev/raw/raw7/dev/mapper/vg00-system_512m

/dev/raw/raw8/dev/mapper/vg00-temp_512m

/dev/raw/raw9/dev/mapper/vg00-undotbs1_512m

/dev/raw/raw10/dev/mapper/vg00-users_16m

#/etc/init.d/rawdevices Restart

3Licensing for character devices

The character device is the ls-l when the device type is C .

# chown oracle:oinstall/dev/raw/raw*

Vi/etc/rc.d

Add the following content

Chown oracle:oinstall/dev/raw/raw*

The block device has been turned into a character device through the steps above.

# ls-l/dev/raw/

Total 0

CRW-RW----1 Oracle Oinstall 162, 1 Jul 5 16:30 RAW1

CRW-RW----1 Oracle Oinstall 162, 5 16:30 RAW10

CRW-RW----1 Oracle Oinstall 162, 2 Jul 5 16:30 raw2

CRW-RW----1 Oracle Oinstall 162, 3 Jul 5 16:30 raw3

CRW-RW----1 Oracle Oinstall 162, 4 Jul 5 16:30 raw4

CRW-RW----1 Oracle Oinstall 162, 5 Jul 5 16:30 raw5

CRW-RW----1 Oracle Oinstall 162, 6 Jul 5 16:30 raw6

CRW-RW----1 Oracle Oinstall 162, 7 Jul 5 16:30 raw7

CRW-RW----1 Oracle Oinstall 162, 8 Jul 5 16:30 raw8

CRW-RW----1 Oracle Oinstall 162, 9 Jul 5 16:30 Raw9

4creating a soft connection

Su-oracle

rm-rf/u01/oradata/orcl/*

RM-RF $ORACLE _home/dbs/spfile_8m

Ln-s/dev/raw/raw1/u01/oradata/orcl/control1_16m

Ln-s/dev/raw/raw2/u01/oradata/orcl/control2_16m

Ln-s/dev/raw/raw3/u01/oradata/orcl/redo1_104m

Ln-s/dev/raw/raw4/u01/oradata/orcl/redo2_104m

Ln-s/dev/raw/raw5/u01/oradata/orcl/redo3_104m

Ln-s/dev/raw/raw6$oracle_home/dbs/spfile_8m

Ln-s/dev/raw/raw7/u01/oradata/orcl/system_512m

Ln-s/dev/raw/raw8/u01/oradata/orcl/temp_512m

Ln-s/dev/raw/raw9/u01/oradata/orcl/undotbs1_512m

Ln-s/dev/raw/raw10/u01/oradata/orcl/users_16m

5 Add a map file

VI Raw.map

Add the following content

control1=/u01/oradata/orcl/control1_16m

control2=/u01/oradata/orcl/control2_16m

redo1=/u01/oradata/orcl/redo1_104m

redo2=/u01/oradata/orcl/redo2_104m

redo3=/u01/oradata/orcl/redo3_104m

spfile= $ORACLE _home/dbs/spfile_8m

system=/u01/oradata/orcl/system_512m

temp=/u01/oradata/orcl/temp_512m

undotbs1=/u01/oradata/orcl/undotbs1_512m

users=/u01/oradata/orcl/users_16m

6 Environment Variables for adding map Files

$ cat. Bash_profile | grep RAW

Export Dbca_raw_config=~/raw.map

7DBCA

Create a database Next

New Database Next

Global_db_name,sid Next

Remove all the tick Next

Lower right corner Standard Database features Next

Remove all the tick OK Next

Use raw Device

Dedicated Server Mode Next

Memory

Shared Pool 110m

Buffer Cache 300m

Java Pool 110m

Large pool 50m

PGA 100m

All initialization parameter

Character Sets

Choose from the list of character sets

Zhs16gbk

Archive

Archive Log Mode Next

Datafiles

Remove indx01.dbf tools01.dbf xdb01.dbf

Tablespaces

Remove INDX TOOLS XDB