利用Vagrant安装Oracle RAC(默认为non-CDB模式),生成2台虚机,耗时约1小时。
node1: ----------------------------------------------------------------- node1: INFO: 2024-01-11 18:25:54: Make create database command node1: ----------------------------------------------------------------- node1: ----------------------------------------------------------------- node1: INFO: 2024-01-11 18:25:54: Create database node1: ----------------------------------------------------------------- node1: [WARNING] [DBT-06801] Specified Fast Recovery Area size (2,048 MB) is less than the recommended value. node1: CAUSE: Fast Recovery Area size should at least be three times the database size (692 MB). node1: ACTION: Specify Fast Recovery Area Size to be at least three times the database size. node1: [WARNING] [DBT-06208] The 'SYS' password entered does not conform to the Oracle recommended standards. node1: CAUSE: node1: a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. node1: b.The password entered is a keyword that Oracle does not recommend to be used as password node1: ACTION: Specify a strong password. If required refer Oracle documentation for guidelines. node1: [WARNING] [DBT-06208] The 'SYSTEM' password entered does not conform to the Oracle recommended standards. node1: CAUSE: node1: a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. node1: b.The password entered is a keyword that Oracle does not recommend to be used as password node1: ACTION: Specify a strong password. If required refer Oracle documentation for guidelines. node1: [WARNING] [DBT-06801] Specified Fast Recovery Area size (2,048 MB) is less than the recommended value. node1: CAUSE: Fast Recovery Area size should at least be three times the database size (2,377 MB). node1: ACTION: Specify Fast Recovery Area Size to be at least three times the database size. node1: Prepare for db operation node1: 8% complete node1: Copying database files node1: 33% complete node1: Creating and starting Oracle instance node1: 34% complete node1: 35% complete node1: 39% complete node1: 42% complete node1: 45% complete node1: 50% complete node1: Creating cluster database views node1: 52% complete node1: 67% complete node1: Completing Database Creation node1: 71% complete node1: 73% complete node1: 75% complete node1: Executing Post Configuration Actions node1: 100% complete node1: Database creation complete. For details check the logfiles at: node1: /u01/app/oracle/cfgtoollogs/dbca/DB193H1. node1: Database Information: node1: Global Database Name:DB193H1 node1: System Identifier(SID) Prefix:DB193H1 node1: Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/DB193H1/DB193H1.log" for further details. node1: ----------------------------------------------------------------- node1: INFO: 2024-01-11 18:40:27: Check database node1: ----------------------------------------------------------------- node1: ----------------------------------------------------------------- node1: INFO: 2024-01-11 18:40:27: Config database node1: ----------------------------------------------------------------- node1: Database unique name: DB193H1 node1: Database name: DB193H1 node1: Oracle home: /u01/app/oracle/product/19.3.0.0/dbhome_1 node1: Oracle user: oracle node1: Spfile: +DATA/DB193H1/PARAMETERFILE/spfile.270.1157999845 node1: Password file: +DATA/DB193H1/PASSWORD/pwddb193h1.258.1157999243 node1: Domain: node1: Start options: open node1: Stop options: immediate node1: Database role: PRIMARY node1: Management policy: AUTOMATIC node1: Server pools: node1: Disk Groups: RECO,DATA node1: Mount point paths: node1: Services: node1: Type: RAC node1: Start concurrency: node1: Stop concurrency: node1: OSDBA group: dba node1: OSOPER group: oper node1: Database instances: DB193H11,DB193H12 node1: Configured nodes: node1,node2 node1: CSS critical: no node1: CPU count: 0 node1: Memory target: 0 node1: Maximum memory: 0 node1: Default network number for database services: node1: Database is administrator managed node1: ----------------------------------------------------------------- node1: INFO: 2024-01-11 18:40:32: Database Status node1: ----------------------------------------------------------------- node1: Instance DB193H11 is running on node node1 node1: Instance DB193H12 is running on node node2 node1: ----------------------------------------------------------------------------------- node1: SUCCESS: 2024-01-11 18:40:35: Oracle RAC on Vagrant has been created successfully! node1: ----------------------------------------------------------------------------------- node1: ----------------------------------------------------------------- node1: INFO: 2024-01-11 18:40:35: Running user-defined post-setup scripts node1: ----------------------------------------------------------------- real 60m10.215s user 0m0.000s sys 0m0.031s
可以看到vagrant生成了node1和node2两台虚机:
$ vagrant status │▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│ Oracle RAC (Real Application Cluster) Vagrant box for KVM/libVirt or VirtualBox Copyright (c) 1982-2020 Oracle and/or its affiliates ---------------------------------------------------------------------------------- Author: Ruggero CittonRAC Pack, Cloud Innovation and Solution Engineering Team │▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│ -------------------- Detected virtualbox -------------------- getting Proxy Configuration from Host... Current machine states: node2 running (virtualbox) node1 running (virtualbox) This environment represents multiple VMs. The VMs are all listed above with their current state. For more information about a specific VM, run `vagrant status NAME`.
两台虚机启动后,32G的电脑内存占用由29%升至69%,消耗内存约13G。
空间方面,两台虚机刚生成时,新增空间占用为vagrant目录下的113G(共享存储)加虚机目录下的6.13G(各自的操作系统),总共约120G。
存储使用了ASM:
[grid@node1 ~]$ asmcmd ASMCMD> lsdg State Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name MOUNTED EXTERN N 512 512 4096 4194304 65520 63012 0 63012 0 Y DATA/ MOUNTED NORMAL N 512 512 4096 4194304 16368 15364 4092 5636 0 N RECO/
如果要使用SQL Developer管理此两RAC示例,则需要连接此两主机的公共IP或SCAN IP,例如192.168.56.111和192.168.56.121。他们定义在文件vagrant.yml中:
$ pwd .../vagrant-projects/OracleRAC/OL7/config $ ls setup.env vagrant.yml $ cat vagrant.yml # ----------------------------------------------- # vagrant.yml for VirtualBox # ----------------------------------------------- node1: vm_name: node1 mem_size: 8192 cpus: 2 public_ip: 192.168.56.111 vip_ip: 192.168.56.112 private_ip: 192.168.200.111 u01_disk: ./node1_u01.vdi node2: vm_name: node2 mem_size: 8192 cpus: 2 public_ip: 192.168.56.121 vip_ip: 192.168.56.122 private_ip: 192.168.200.122 u01_disk: ./node2_u01.vdi shared: prefix_name: vgtol7-rac # --------------------------------------------- domain : localdomain scan_ip1: 192.168.56.115 scan_ip2: 192.168.56.116 scan_ip3: 192.168.56.117 # --------------------------------------------- non_rotational: 'on' asm_disk_path: asm_disk_num: 4 asm_disk_size: 20 p1_ratio: 80 asm_lib_type: 'ASMLIB' # --------------------------------------------- env: provider: virtualbox # --------------------------------------------- gi_software: LINUX.X64_193000_grid_home.zip db_software: LINUX.X64_193000_db_home.zip # --------------------------------------------- root_password: welcome1 grid_password: welcome1 oracle_password: welcome1 sys_password: welcome1 pdb_password: welcome1 # --------------------------------------------- ora_languages: en,en_GB # --------------------------------------------- nomgmtdb: true orestart: false # --------------------------------------------- db_name: DB193H1 pdb_name: PDB1 db_type: RAC cdb: false # --------------------------------------------- ...
有几个地方可以表明其为RAC。见下图,RAC #1表明其为集群中的节点1:
然后就是“数据库状态”中,可以看到有2个实例,即DB193H11和DB193H12:
以及“状态”中的“Oracle主机”标签页: