https://blog.csdn.net/brj880719/article/details/51925801

1.创建目录

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

2.编辑参数文件

*.memory_target=512m

*.audit_file_dest='/u01/app/oracle/admin/orcl/adump'

*.audit_trail='db'

*.control_files=’+DATADG/ORCL/controlfile/control01.ctl’, ‘+DATADG/ORCL/controlfile/control02.ctl’                                           

*.db_block_size=8192

*.db_create_file_dest='+DATADG'

*.db_domain=''

*.db_name='orcl'

*.db_recovery_file_dest='+DATADG'

*.db_recovery_file_dest_size=1G

*.diagnostic_dest='/u01/app/oracle'

*.open_cursors=300

*.processes=150

*.remote_listener='nodescan:1521'

*.remote_login_passwordfile='exclusive'

3.创建ASM目录和创建spfile

4.创建密码文件

cd $ORACLE_HOME/dbs

节点1：orapwd file=orapwORCL1 password=oracle

节点2：orapwd file=orapwORCL2 password=oracle

5.创建DB

CREATE DATABASE orcl

   USER SYS IDENTIFIED BY oracle

   USER SYSTEM IDENTIFIED BY oracle

   LOGFILE GROUP 1 ('+DATADG') SIZE 100M,

           GROUP 2 ('+DATADG') SIZE 100M,

           GROUP 3 ('+DATADG') SIZE 100M

   MAXLOGFILES 5

   MAXLOGMEMBERS 5

   MAXLOGHISTORY 1

   MAXDATAFILES 100

   CHARACTER SET US7ASCII

   NATIONAL CHARACTER SET AL16UTF16

   EXTENT MANAGEMENT LOCAL

   DATAFILE '+DATADG' SIZE 325M

   SYSAUX DATAFILE '+DATADG' SIZE 325M

   DEFAULT TABLESPACE users

      DATAFILE '+DATADG'

      SIZE 500M  AUTOEXTEND ON MAXSIZE UNLIMITED

   DEFAULT TEMPORARY TABLESPACE tempts1

      TEMPFILE '+DATADG'

      SIZE 20M

   UNDO TABLESPACE undotbs1

      DATAFILE '+DATADG'

      SIZE 200M  AUTOEXTEND ON MAXSIZE UNLIMITED;

6.创建undo 和添加redo

UNDO

CREATE UNDO TABLESPACE UNDOTBS2 DATAFILE '+DATADG' SIZE 200M;

REDO

ALTER DATABASE ADD LOGFILE THREAD 2 GROUP 4 '+DATADG' SIZE 100M; 

ALTER DATABASE ADD LOGFILE THREAD 2 GROUP 5 '+DATADG' SIZE 100M;

ALTER DATABASE ADD LOGFILE THREAD 2 GROUP 6 '+DATADG' SIZE 100M; 

7.以下转单实例db到RAC DB

8.执行创建数据字典脚本

@?/rdbms/admin/catalog.sql

@?/rdbms/admin/catproc.sql

@?/rdbms/admin/catclust.sql

@?/rdbms/admin/utlrp.sql

9.注册数据库到Clusterware