Prerequisites for an Oracle Autonomous Transaction Processing Database

If you want to deploy Oracle Analytics Server product schemas in an Oracle Autonomous Transaction Processing (ATP) database, you must download the ATP wallet, upload it to Oracle Cloud Infrastructure (OCI) Object Storage, and obtain a pre-authenticated URL for the wallet so Oracle Analytics Server can access it in Object Storage. You also need to obtain the connection string for the ATP database from the tnsnames.ora file in the ATP wallet zip file.

  1. Obtain the wallet for your ATP database and download it to your local machine.
    1. In OCI Console, navigate to the details page for the ATP database, click Database Connection.
    2. Click Download Wallet.
    3. Enter a password to protect the wallet.
    4. Click Download to save the client credentials zip file (wallet) to a safe place on your local machine.

    For details, see Download Client Credentials.

  2. Upload the ATP wallet zip file to Object Storage.
    1. In OCI Console, go to the Object Storage page and navigate to the bucket where you want to upload the file.
    2. Click Upload, then upload the ATP wallet zip file you just downloaded.

    For details, see Uploading an Object Storage Object to a Bucket.

  3. Create a pre-authenticated request for the ATP wallet zip file and record the pre-authenticated URL for later.
    1. Go to the bucket where you uploaded the ATP wallet zip file.
    2. Click the Actions menu for the wallet, and select Create Pre-Authenticated Request.
    3. In the Create Pre-Authenticated Request panel, specify the following values:
      • Name: Enter a descriptive name for the request.
      • Pre-Authenticated Request Target: Select Object.
      • Access Type: Select Permit object reads.
      • Expiration: Oracle recommends that you set the date such that the pre-authenticated URL expires immediately after you complete Oracle Analytics Server deployment.
    4. Click Create Pre-Authenticated Request.
    5. Click the Copy icon to copy the URL. You must copy and record the URL before you close the dialog. You can’t retrieve the URL again.

    For details, see Creating a Pre-Authenticated Request in Object Storage.

  4. Copy the connection string for your ATP database service from tsnames.ora and record it for later.
    1. On your local machine, navigate to the wallet zip file that you downloaded earlier and extract the zip file.
    2. Open the tnsnames.ora file in a text editor.
      A typical tnsnames.ora file contains several entries:
      # TNS entries..
demo_high =   (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_high)(security=(ssl_server_dn_match=<yes_or_no>))
demo_medium = (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_medium)(security=(ssl_server_dn_match=<yes_or_no>))
demo_low =    (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_low)(security=(ssl_server_dn_match=<yes_or_no>))
...
    3. Copy and record the entire connect descriptor (description=…) (shown in bold) for the service you want to use. For example, copy the string:
      (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_medium)(security=(ssl_server_dn_match=<yes_or_no>))