Set Up an Oracle Cloud Database

Oracle Analytics Server needs access to a database deployed on Oracle Cloud in which it can install various required database schemas. The database must be deployed in the same region as Oracle Analytics Server and accessible from the VCN where you plan to deploy Oracle Analytics Server.

Database Editions and Versions

The database must be a pluggable database (PDB) on an Oracle Cloud virtual machine DB system. See Overview for Bare Metal and Virtual Machine DB Systems.

Oracle Analytics Server supports the following database versions and editions:

  • Oracle Analytics Server 2025
    • Oracle Database Standard Edition (version 19+ or 23ai)
    • Oracle Autonomous Transaction Processing (ATP) (version 19+)
  • Oracle Analytics Server 2024
    • Oracle Database Standard Edition (version 12.1, 12.2, 18+, or 19+)
    • Oracle Autonomous Transaction Processing (ATP) (version 19+) *

Database Connection String Format

When you deploy Oracle Analytics Server on Oracle Cloud using Oracle Cloud Marketplace, you're asked to provide the database connection string and database administrator credentials for the database you want to use.

Tip:

To ensure Oracle Analytics Server deployment goes smoothly, test the database connection and database administrator credentials before you start.
The database connection string format depends on the type of database you plan to use and the Oracle Analytics Server version you deploy (2025 or 2024).
  • Oracle Database - Oracle Analytics Server 2025 and 2024

    Database connection string format:<hostname or IP address>:<port>:<PDB_name>.<DB_domain>

    For example: oasdb.sub12345678901.oasvcn.oraclevcn.com:1512:OASDB1213_pdb1.sub12345678901.oasvcn.oraclevcn.com

  • Oracle Autonomous Transaction Processing (ATP) - Oracle Analytics Server 2025

    Database connection string format:jdbc:oracle:thin:@(description=(retry_count=<count>)(retry_delay=<delay>)(address=(protocol=tcps)(port=<port>)(host=<your_hostname_or_ip_address>))(connect_data=(service_name=<your_ATP_service_name>)(security=(ssl_server_dn_match=<yes_or_no>))

    For example: jdbc:oracle:thin:@(description=(retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=1521)(host=adb.us-ashburn-1.oraclecloud.com))(connect_data=(service_name=myoasdb_medium.adb.oraclecloud.com))(security=(ssl_server_dn_match=yes)))

    You can obtain the connection string from the ATP wallet. See Prerequisites for an Oracle Autonomous Transaction Processing Database.

  • Oracle Autonomous Transaction Processing (ATP) - Oracle Analytics Server 2024

    If you want to use Oracle Analytics Server 2024, you can use Oracle Cloud Marketplace to deploy Oracle Analytics Server but you must manually create the Oracle Analytics Server domain with Oracle ATP. In this case, follow these steps to manually create the domain using the Oracle ATP connection string format described here: Configuring the Oracle Analytics Server Domain with the Configuration Assistant.

Product Schemas

Oracle Analytics Server installs several schemas on the Oracle Cloud Database and uses them to store various product metadata.

  • <YourSchemaPrefix>_BIPLATFORM - Oracle Analytics
  • <YourSchemaPrefix>_IAU - Audit Service
  • <YourSchemaPrefix>_IAU_APPEND- Audit Service Append
  • <YourSchemaPrefix>_IAU_VIEWER- Audit Service Viewer
  • <YourSchemaPrefix>_MDS - Metadata Services
  • <YourSchemaPrefix>_OPSS - Oracle Platform Security Services
  • <YourSchemaPrefix>_STB - Service Table
  • <YourSchemaPrefix>_WLS - WebLogic services

When you deploy Oracle Analytics Server on Oracle Cloud using Oracle Cloud Marketplace, you're asked to provide a prefix for these database schemas and a suitable password to access them.

  • Database Schema Prefix - Prefix added to the name of each database schema created for Oracle Analytics Server. For example, MyOAS.
  • Database Schema Password - Password to access the database schemas used by Oracle Analytics Server. This is a new password so you can enter any suitable value that satisfies the password policy of database you want to use.

    For example, a pluggable database (PDB) on an Oracle Cloud virtual machine DB system has the following password policy:

    • A minimum of 9 and a maximum of 30 characters.
    • At least two uppercase characters.
    • At least two lowercase characters.
    • At least two special characters. The valid special characters are: underscore ( _ ), dollar ($), or a pound or hash sign (#). You can use two of the same characters or any combination of two of the same characters.
    • At least two numeric characters (0 - 9).