Oracle 11g 使用裸设备
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/diag/rdbms/orcl/orcl/cdump
$ mkdir -p /u01/app/oracle/diag/rdbms/orcl/orcl/trace
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'>
DEFAULT TEMPORARY TABLESPACE TEMPTBSTEMPFILE '/u01/oradata/orcl/temp01.dbf'> 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
页:
[1]