Wildfly配置RAC数据库
数据库信息
-
漂移地址
可用于PL/SQL连接RAC数据库;
- 192.168.64.35/hlw1db
-
物理地址/虚拟地址
-
物理地址1:192.168.64.31 --> 虚拟地址:192.168.64.33
-
物理地址2:192.168.64.32 --> 虚拟地址:192.168.64.34
-
RAC数据库配置
-
修改
standalone.xml
文件配置地址为两台物理机对应的虚拟机地址
<connection-url> jdbc:oracle:thin:@( DESCRIPTION=( ADDRESS_LIST=( ADDRESS=(PROTOCOL=TCP)(HOST=192.168.64.33)(PORT=1521) )( ADDRESS=(PROTOCOL=TCP)(HOST=192.168.64.34)(PORT=1521) )( LOAD_BALANCE=yes )( FAILOVER=on ) )( CONNECT_DATA=(SERVICE_NAME=hlw1db) ) ) </connection-url>
PS:为更容易阅读,对格式做了修改。
-
创建表空间
SQL语句:
Create Tablespace cms Datafile '+DATA/hlw1db/datafile/cms01.dbf' Size 100M Autoextend On Maxsize 20G;
-
创建用户(注意不赋予DBA权限)
SQL语句:
CREATE USER hlbyj_themis PROFILE "DEFAULT" IDENTIFIED BY themis_ds DEFAULT TABLESPACE themis_ds TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK; GRANT CONNECT TO hlbyj_themis WITH ADMIN OPTION; GRANT RESOURCE TO hlbyj_themis WITH ADMIN OPTION;