Oracle 11g uses bare devices

1 viewing SIDs

$ echo $ORACLE _sid

Orcl

$ echo $ORACLE _home

/u01/app/oracle/product/11g

$ echo $ORACLE _base

/u01/app/oracle

$ mkdir-p/U01/ORADATA/ORCL

$ mkdir-p/u01/app/oracle/admin/orcl/adump

$ mkdir-p/u01/app/oracle/diag/rdbms/orcl/orcl/cdump

$ mkdir-p/u01/app/oracle/diag/rdbms/orcl/orcl/trace

2 editing parameter files

$ VI $ORACLE _home/dbs/initorcl.ora

Add the following content

Audit_file_dest= '/u01/app/oracle/admin/orcl/adump '

Db_name=orcl

control_files= '/u01/oradata/orcl/control01.ctl '

db_block_size=8192

Undo_tablespace= ' UNDOTBS1 '

Compatible= ' 11.2.0.0.0 '

3 Creating a password file

$ orapwd file= $ORACLE _home/dbs/pwdorcl.orapassword=oracle

4 Launch instance to Mount

$ sqlplus/as SYSDBA

Sql> Startup Nomount

5 Creating a bare device soft connection for SPFile

$ ln-s/dev/raw/raw11$oracle_home/dbs/spfileorcl.ora

$ sqlplus/as SYSDBA

Sql> create SPFile from Pfile;

sql> startup Nomount Force

6 Creating data files soft connections for bare devices

Ln-s/dev/raw/raw1/u01/oradata/orcl/system01.dbf

Ln-s/dev/raw/raw2/u01/oradata/orcl/sysaux01.dbf

Ln-s/dev/raw/raw3/u01/oradata/orcl/temp01.dbf

Ln-s/dev/raw/raw4/u01/oradata/orcl/undotbs101.dbf

Ln-s/dev/raw/raw5/u01/oradata/orcl/users01.dbf

7 Creating a soft connection for a control file bare device

Ln-s/dev/raw/raw6/u01/oradata/orcl/control01.ctl

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

8 Creating a log file soft connection for bare devices

Ln-s/dev/raw/raw8/u01/oradata/orcl/redo01.log

Ln-s/dev/raw/raw9/u01/oradata/orcl/redo02.log

Ln-s/dev/raw/raw10/u01/oradata/orcl/redo03.log

9 Creating a data file

CREATE DATABASE ORCL

DataFile '/u01/oradata/orcl/system01.dbf ' SIZE 1023M autoextend OFF EXTENT MANAGEMENT LOCAL

Sysaux datafile '/u01/oradata/orcl/sysaux01.dbf ' SIZE 1023M

UNDO tablespace UNDOTBS1 datafile '/u01/oradata/orcl/undotbs101.dbf ' SIZE 511M

DEFAULT temporary tablespace temptbstempfile '/u01/oradata/orcl/temp01.dbf ' SIZE 511M

CHARACTER SET ZHS16GBK

National CHARACTER SET AL16UTF16

LOGFILE

GROUP 1 ('/u01/oradata/orcl/redo01.log ') SIZE 127M,

GROUP 2 ('/u01/oradata/orcl/redo02.log ') SIZE 127M,

GROUP 3 ('/u01/oradata/orcl/redo03.log ') SIZE 127M;

Execute script

This is used to create a data dictionary

@?/rdbms/admin/catalog

@?/rdbms/admin/catproc