...
Reference Database for Oracle 11g
An Oracle Reference Database is essentially one or more schemas in an Oracle instance. Datical connects to Oracle databases Reference Databases using user that are also names of schemas in the database.
In a pipeline that consists of DEV, QA and PROD environments, the schema name (e.g., "appSchema") would be consistent across each environment. As such, there could would be multiple Oracle instances configured for each environment and each instance would have "appSchema" defined.
Because schema names have to be unique within an Oracle instance, this creates the need to setup new Oracle instances for each numbered Reference Databases.
Each Datical project could have one or more pipelines. This allows application teams to have multiple concurrent release streams. Datical requires that each pipelines has a dedicated Reference Database in the following manner. The table below shows sample pipelines for one Datical project
| Environments in the pipeline | ||
|---|---|---|
| Pipeline 1 | REF1 → DEV1 → QA1 → UAT → PROD | Reference Databases (numbered) for each pipeline. DEV1-5, QA1-5, UAT and PROD are existing databases in pipelines. |
| Pipeline 2 | REF2 → DEV2 → QA2 → UAT → PROD | |
| Pipeilne 3 | REF3 → DEV3 → QA3 → UAT → PROD | |
| Pipeline 4 | REF4 → DEV4 → QA4 → UAT → PROD | |
| Pipeline 5 | REF5 → DEV5 → QA5 → UAT → PROD |
Each Datical project will have similar pipelines as shown in the table above where they will require one or more numbered Reference Databases. Each of the numbered Reference Databases will be houses in their designated Oracle 11g instance. For example, all REF1 databases from all Datical projects could be housed in a single Oracle 11g instance. Similarly, all REF2 databases from all Datical projects could be housed in the second Oracle 11g instance.
| Numbered Reference Databases | Oracle 11g instance |
|---|---|
| REF1 databases for all Datical projects | Instance #1 |
| REF2 databases for all Datical projects | Instance #2 |
| REF3 databases for all Datical projects | Instance #3 |
| REF4 databases for all Datical projects | Instance #4 |
| REF5 databases for all Datical projects | Instance #5 |
Shared services team who own centralized infrastructure will need to figure out how many numbered Reference Databases are going to be used and from there decide how many Oracle 11g instances will be needed.
The best practice, for scaling out Oracle 11g based Reference Databases would be to setup one Oracle 11g instance per server and have separate servers for each Oracle 11g instance. In the example above, you would setup 5 servers, each with a single Oracle 11g instance.
Reference Databases for Oracle 12c
...