Create an Active GridLink Data Source for a RAC Database
Use the model Yaml templates to create an Active GridLink (AGL) data source for an Oracle Real Application Cluster (RAC) database with WebLogic Suite Edition.
Following is an example of model Yaml template for app deployment with AGL datasource (RAC as infra DB with WebLogic Enterprise Edition) properties:
Note:
The template files are located at/u01/shared/scripts/pipeline/templates
on the administration host.
resources:
JDBCSystemResource:
'hellods':
Target: '@@ENV:RESOURCE_PREFIX@@-cluster'
JdbcResource:
DatasourceType: AGL
JDBCConnectionPoolParams:
StatementCacheSize: 0
TestTableName: SQL ISVALID
JDBCDataSourceParams:
GlobalTransactionsProtocol: None
JNDIName: [ jdbc/hellods ]
JDBCDriverParams:
DriverName: oracle.jdbc.replay.OracleDataSourceImpl
URL: '@@SECRET:@@ENV:DOMAIN_UID@@-datasource-secret:url@@'
PasswordEncrypted: '@@SECRET:@@ENV:DOMAIN_UID@@-datasource-secret:password@@'
Properties:
user:
Value:
JDBCOracleParams:
FanEnabled: true
ActiveGridlink: true
OnsNodeList:
You must set up the database to create a schema user before you create the data source. See Prerequisites to Create a Data Source.
- Update the
Properties
section in the model Yaml template to setOnsNodeList
. - Create the data source secrets in the model YAML file as follows: