Skip to content

Latest commit

 

History

History

sag-db-oracle-103-and-lower

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
README.md
README.md
 
 
docker-compose.yml
docker-compose.yml
 
 
template.yaml
template.yaml
 
 
test.sh
test.sh
 
 

README.md

Creating webMethods database on Oracle

With this template you can create user, storage tablespaces and webMethods database components on an Oracle database server.

Requirements

Supported Software AG releases

  • Command Central 10.1 and 10.3
  • Database Component Configurator 9.10 to 10.3
  • webMethods database components for products 9.8 to 10.3

Supported platforms

  • All supported Windows and UNIX platforms
  • All supported versions of Oracle database
  • Docker Engine 17.09 or higher

Running as a standalone Composite Template

To install Database Component Configurator 10.1 on the Command Central node with alias local, create a database named webm and a database user named webm with password webm, and create database storage and database components for Integration Server 10.1 and My webMethods Server 10.1 with user system and password oracle:

sagcc exec templates composite apply sag-db-oracle-103-and-lower
  db.version=10.1.0.0 repo.product=products-10.1 repo.fix=fixes-10.1 nodes=local
  db.host=oracle db.admin.username=system db.admin.password=oracle
  db.name=webm db.username=webm db.password=webm
  db.products=[IS,MWS]
  --sync-job --wait 360

Using for local development and testing on Docker platforms

  1. Launch the Command Central container from the root folder of the following project:
docker-compose up -d cc
  1. Launch the Oracle Database Express Edition 11g Release 2 container:
docker-compose -f templates/sag-db-oracle-103-and-lower/docker-compose.yml up -d oracle
  1. Provision the sag-db-oracle-103-and-lower template to create a user, storage, and Integration Server, My webMethods Server and BPM database components for the 10.3 release:
CC_ENV=oracle ./provisionw sag-db-oracle-103-and-lower

If the test is successful, the test ouptut contains TEST SUCCESSFUL.

You can now use this database for creating instances of webMethods products (for example, Integration Server and My webMethods Server) with the following database connection properties:

db.url=jdbc:wm:oracle://oracle:1521;SID=XE
db.username=webm
db.password=webm
db.type=oracle

The properties are pre-set in the environments/oracle/env.properties file and you can use them by pointing to the environment name, for example:

CC_ENV=oracle ./provisionw sag-optimize-analysis