Linux 安装 Oracle 11g——手工建库(RAC)

时间:2020-12-10 08:28:03

  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
    • 创建spfile路径
      [grid@node1 ~]$ asmcmd
      ASMCMD> cd DATADG
      ASMCMD> mkdir ORCL
      Linux 安装 Oracle 11g——手工建库(RAC)
    • 开启第一个节点
      [grid@node1 ~]$ sqlplus / as sysdba 
      SQL> create spfile='+DATADG/ORCL/spfileorcl.ora' from pfile='/tmp/1.txt';
      Linux 安装 Oracle 11g——手工建库(RAC)
    • 创建init文件
      • 节点1
        vi initorcl1.ora
        SPFILE='+DATADG/ORCL/spfileorcl.ora'
      • 节点2
        vi initorcl2.ora
        SPFILE='+DATADG/ORCL/spfileorcl.ora'
  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
    • 添加rac 参数 
      *.cluster_database=true
      orcl1.instance_number=1
      orcl2.instance_number=2
      orcl2.thread=2
      orcl1.thread=1
      orcl1.undo_tablespace='UNDOTBS1'
      orcl2.undo_tablespace='UNDOTBS2'
    • 启动第一节点
      startup
      Linux 安装 Oracle 11g——手工建库(RAC)
      ALTER DATABASE ENABLE PUBLIC THREAD 2;
      Linux 安装 Oracle 11g——手工建库(RAC)
    • 启动第二节点数据库
      startup
      Linux 安装 Oracle 11g——手工建库(RAC)
    • 验证
      select instance_name from gv$instance;
      Linux 安装 Oracle 11g——手工建库(RAC)
  8. 执行创建数据字典脚本
    @?/rdbms/admin/catalog.sql
    @?/rdbms/admin/catproc.sql
    @?/rdbms/admin/catclust.sql
    @?/rdbms/admin/utlrp.sql
  9. 注册数据库到Clusterware
    • 注册
      srvctl add database -d orcl -o $ORACLE_HOME
      srvctl add instance -d orcl -i orcl1 -n node1
      srvctl add instance -d orcl -i orcl2 -n node2
      srvctl enable database -d orcl
      srvctl start database -d orcl
      Linux 安装 Oracle 11g——手工建库(RAC)
    • 验证
      crsctl stat res -t
      Linux 安装 Oracle 11g——手工建库(RAC)