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.
  • Oracle Autonomous Transaction Processing (ATP)

    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 Database

    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

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).
  • URL for the ATP Wallet in Object Storage (ATP databases only) - Pre-authenticated request URL with access to the Autonomous Transaction Processing (ATP) wallet that you uploaded to Object Storage. Use the format: https://<object storage location>/<wallet zip filename>

    For example: https://objectstorage.us-phoenix-1.oraclecloud.com/p/par_ID/n/namespace_ID/b/mybucket/o/myATPwallet.zip

    See Prerequisites for an Oracle Autonomous Transaction Processing Database.