WDT template for JDBCSystemResource

WDT-JDBCSystemResource.yaml

resources:
  JDBCSystemResource:

    'opss-data-source':
        Target: 'elhoam_cluster,AdminServer'
        JdbcResource:
            JDBCConnectionPoolParams:
                MaxCapacity: 25
                ShrinkFrequencySeconds: 900
                MinCapacity: 2
                StatementCacheSize: 10
                TestTableName: SQL SELECT 1 FROM DUAL
                InitialCapacity: 2
                TestFrequencySeconds: 0
                TestConnectionsOnReserve: true
                SecondsToTrustAnIdlePoolConnection: 10
                ConnectionCreationRetryFrequencySeconds: 0
            JDBCDataSourceParams:
                GlobalTransactionsProtocol: None
                JNDIName: jdbc/OpssDataSource
            JDBCDriverParams:
                URL: 'jdbc:oracle:thin:...'
                PasswordEncrypted: '...'
                DriverName: oracle.jdbc.OracleDriver
                Properties:
                    user:
                        Value: ELHOAM_OPSS
                    databasename:
                        Value: 'opss-data-source'
                    servername:
                        Value: '...'

    'opss-audit-viewDS':
        Target: 'elhoam_cluster,AdminServer'
        JdbcResource:
            JDBCConnectionPoolParams:
                MaxCapacity: 15
                ShrinkFrequencySeconds: 900
                MinCapacity: 2
                StatementCacheSize: 10
                TestTableName: SQL SELECT 1 FROM DUAL
                InitialCapacity: 2
                TestFrequencySeconds: 0
                TestConnectionsOnReserve: true
                SecondsToTrustAnIdlePoolConnection: 10
                ConnectionCreationRetryFrequencySeconds: 0
            JDBCDataSourceParams:
                GlobalTransactionsProtocol: None
                JNDIName: jdbc/AuditViewDataSource
            JDBCDriverParams:
                URL: 'jdbc:oracle:thin:...'
                PasswordEncrypted: '...'
                DriverName: oracle.jdbc.OracleDriver
                Properties:
                    user:
                        Value: ELHOAM_IAU_VIEWER
                    databasename:
                        Value: 'opss-audit-viewDS'
                    servername:
                        Value: '...'

    'opss-audit-DBDS':
        Target: 'elhoam_cluster,AdminServer'
        JdbcResource:
            JDBCConnectionPoolParams:
                MaxCapacity: 15
                ShrinkFrequencySeconds: 900
                MinCapacity: 2
                StatementCacheSize: 10
                TestTableName: SQL SELECT 1 FROM DUAL
                InitialCapacity: 2
                TestFrequencySeconds: 0
                TestConnectionsOnReserve: true
                SecondsToTrustAnIdlePoolConnection: 10
                ConnectionCreationRetryFrequencySeconds: 0
            JDBCDataSourceParams:
                GlobalTransactionsProtocol: None
                JNDIName: jdbc/AuditAppendDataSource
            JDBCDriverParams:
                URL: 'jdbc:oracle:thin:...'
                PasswordEncrypted: '...'
                DriverName: oracle.jdbc.OracleDriver
                Properties:
                    user:
                        Value: ELHOAM_IAU_APPEND
                    databasename:
                        Value: 'opss-audit-DBDS'
                    servername:
                        Value: '...'

    oamDS:
      Target: 'elhoam_cluster,AdminServer'
      JdbcResource:
        JDBCConnectionPoolParams:
          MaxCapacity: 400
          InactiveConnectionTimeoutSeconds: 300
          ShrinkFrequencySeconds: 0
          MinCapacity: 50
          StatementCacheSize: 0
          InitialCapacity: 20
          TestTableName: SQL SELECT 1 FROM DUAL
          TestFrequencySeconds: 0
          TestConnectionsOnReserve: true
          SecondsToTrustAnIdlePoolConnection: 0
          ConnectionCreationRetryFrequencySeconds: 10
        JDBCDataSourceParams:
          JNDIName: jdbc/oamds
        JDBCDriverParams:
          PasswordEncrypted: '...'
          DriverName: oracle.jdbc.OracleDriver
          URL: 'jdbc:oracle:thin:...'
          Properties:
            databasename:
              Value: oamDS
            oracle.net.CONNECT_TIMEOUT:
              Value: 10000
            servername:
              Value: '...'
            user:
              Value: 'ELHOAM_OAM'

    'mds-owsm':
        Target: 'elhoam_cluster,AdminServer'
        JdbcResource:
            JDBCConnectionPoolParams:
                MaxCapacity: 30
                ShrinkFrequencySeconds: 900
                MinCapacity: 2
                StatementCacheSize: 10
                TestTableName: SQL SELECT 1 FROM DUAL
                InitialCapacity: 2
                TestFrequencySeconds: 0
                TestConnectionsOnReserve: true
                SecondsToTrustAnIdlePoolConnection: 0
                ConnectionCreationRetryFrequencySeconds: 10
            JDBCDataSourceParams:
                GlobalTransactionsProtocol: None
                JNDIName: jdbc/mds/owsm
            JDBCDriverParams:
                URL: 'jdbc:oracle:thin:...'
                PasswordEncrypted: '...'
                DriverName: oracle.jdbc.OracleDriver
                Properties:
                    user:
                        Value: ELHOAM_MDS
                    oracle.net.CONNECT_TIMEOUT:
                        Value: 120000
                    SendStreamAsBlob:
                        Value: true
                    databasename:
                        Value: 'mds-owsm'
                    servername:
                        Value: 'jdbc:oracle:thin:...'


    WLSSchemaDataSource:
      JdbcResource:
        JDBCConnectionPoolParams:
          TestTableName: SQL ISVALID
          MaxCapacity: 75
        JDBCDataSourceParams:
          GlobalTransactionsProtocol: None
          JNDIName: jdbc/WLSSchemaDataSource
        JDBCDriverParams:
          URL: 'jdbc:oracle:thin:...'
          PasswordEncrypted: "..."
          DriverName: oracle.jdbc.OracleDriver
          Properties:
            user:
              Value: ELHOAM_WLS_RUNTIME
            oracle.net.CONNECT_TIMEOUT:
              Value: 10000
            SendStreamAsBlob:
              Value: true
            servername:
              Value: '...'
        JDBCOracleParams:
          ActiveGridlink: true
          FanEnabled: true

    LocalSvcTblDataSource:
        Target: 'AdminServer'
        JdbcResource:
            JDBCConnectionPoolParams:
                MaxCapacity: 200
                ShrinkFrequencySeconds: 900
                MinCapacity: 2
                StatementCacheSize: 10
                TestTableName: SQL SELECT 1 FROM DUAL
                CapacityIncrement: 1
                InitialCapacity: 2
                TestFrequencySeconds: 0
                TestConnectionsOnReserve: true
                SecondsToTrustAnIdlePoolConnection: 0
                ConnectionCreationRetryFrequencySeconds: 10
            JDBCDataSourceParams:
                GlobalTransactionsProtocol: None
                JNDIName: jdbc/LocalSvcTblDataSource
            JDBCDriverParams:
                URL: 'jdbc:oracle:thin:...'
                PasswordEncrypted: '...'
                DriverName: oracle.jdbc.OracleDriver
                Properties:
                    user:
                        Value: ELHOAM_STB
                    oracle.net.CONNECT_TIMEOUT:
                        Value: 10000
                    SendStreamAsBlob:
                        Value: true
                    databasename:
                        Value: LocalSvcTblDataSource
                    servername:
                        Value: '...'
 
 

Can you attach the output of the run and the createDomain.log ?

i just created a secret gist and send link as emailto you @jshum2479