Oracle 11g 使用裸设备

435rwe

1  查看SID$ 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/admin/orcl/bdump
$ mkdir -p /u01/app/oracle/admin/orcl/cdump
$ mkdir -p /u01/app/oracle/admin/orcl/udump


2  编辑参数文件$ vi $ORACLE_HOME/dbs/initorcl.ora
添加下面的内容

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  建立口令文件$ orapwd file=$ORACLE_HOME/dbs/pwdorcl.orapassword=oracle

4  启动实例到mount$ sqlplus / as sysdba
SQL> startup nomount

5  创建spfile的裸设备软连接$ ln -s /dev/raw/raw11$ORACLE_HOME/dbs/spfileorcl.ora
$ sqlplus / as sysdba
SQL> create spfile from pfile;
SQL> startup nomount force

6  创建数据文件裸设备的软连接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  创建控制文件裸设备的软连接ln -s /dev/raw/raw6/u01/oradata/orcl/control01.ctl
ln -s/dev/raw/raw7/u01/oradata/orcl/control02ctl

8  创建日志文件裸设备的软连接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  创建数据文件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;

10  执行脚本这个用来创建数据字典

@?/rdbms/admin/catalog
@?/rdbms/admin/catproc