5 Frequently Asked Questions

This reference provides answers to common questions asked by administrators creating and managing services for Oracle Analytics Cloud.

Top FAQs for Administration and Configuration

The top FAQs for Oracle Analytics Cloud administration and configuration are identified in this topic.

What do I use the Service Console in My Services for? Is this the same as the Console I see in the service?

  • Service Console — You use the Service Console in My Services to manage lifecycle tasks such as create, delete, patch, and scale services.

    To access the Service Console, sign in to My Services, open the Dashboard, and locate the Analytics tile. If you can’t see Analytics, click Customize Dashboard, find Analytics and select Show.

  • Console — When you sign in to a particular service, you see a different administrative console where you manage the environment for that service only.

    To access the Console for a service, sign in to the service, open the Navigator, and then click Console.

What is an OCPU?  

An OCPU provides CPU capacity equivalent of one physical core of an Intel Xeon processor with hyper-threading enabled. Each OCPU corresponds to two hardware execution threads, known as vCPU.

How can I determine the right compute size for my initial deployment?

A good starting point is to pick a size that closely matches your on-premises hardware for business intelligence.

For more sizing guidelines, see  http://support.oracle.com.

How do I access my service once it is created?

It’s accessible from My Services. Open the Service Console for Oracle Analytics Cloud and click the name of the service you want to access. Click the Manage this service menu, and then click Oracle Analytics Cloud URL.

How do I patch or upgrade my service?

You can patch or upgrade your service from My Services.

Do I need to patch the service on a specific schedule?

No. Patches are delivered through the My Services and you can patch within your organization’s preferred schedule.

I want to connect to the database where my organization’s analytics data is stored? Do I do this from the Service Console in My Services?

No. You connect to the data you want to analyze within a given service that you created. See How do I access my service once it is created?.

How do I configure VPN connectivity for my service to my network?

VPN is a separate feature from your service and is available to use with some Oracle Cloud services. Contact your Oracle representative for more information.

How do I get support for Oracle Analytics Cloud?

You create a service request in the same way as for on-premises software.

Is there a charge for Oracle Support in addition to my subscription fee?

No. Support is included in your subscription fee.

Do I have direct access to the file system associated with my service?

Yes. You can use the SSH keys, generated at the time of provisioning, to access your service’s file system. However, modifications that you make to the file system might not be saved after you perform routine lifecycle operations, such as patching, and might even prevent you from performing lifecycle operations.

My service currently uses the embedded LDAP server for identity management. What’s the maximum number of users?

The performance of the embedded LDAP server is best with fewer than 10,000 users. If you have more users, use Oracle Identity Cloud Service. See Migrate LDAP-Based Services to Oracle Identity Cloud Service.

Are initialization blocks supported in Oracle Analytics Cloud?

You can use initialization blocks (init blocks) to set session variables but you can’t use them to set users, roles, or groups. If you subscribe to Oracle Analytics Cloud through Universal Credits, USER and ROLE (GROUP) session variables are set in Oracle Identity Cloud Service.

What do I need to back up?

To ensure you can restore Oracle Analytics Cloud if something goes wrong, you must back up your service and the database associated with your service. If you deployed Oracle Analytics Cloud with the data visualization or business intelligence service, then you can also back up the content that users create.

  • Oracle Analytics Cloud: You can back up your service from My Services or using the Command Line Interface. See Back Up a Service and psm analytics backup.

    To restore your service, see Restore a Service or psm analytics restore.

  • Oracle Analytics Cloud user content: (Data visualization and business intelligence services only) You can back up just the content that users create to a separate file, called a snapshot. User content includes data models and catalog items such as reports, dashboards, data visualization projects, data sets, data flows, and security roles. If something goes wrong with your content, then you can revert to the content you saved in a snapshot. Snapshots are also useful if you want to move or share content from one service to another.

    Snapshots don’t include the actual data associated with a particular data set.

    To back up user content, see Take a Snapshot.

    To restore user content, see Restore from a Snapshot.


    For Essbase services, you back up the entire service; you can't back up only the content.
  • Oracle Database Cloud Service: Oracle Analytics Cloud stores various schemas and information in a cloud database that you select when you set up Oracle Analytics Cloud. You can back up this database from My Services.

    To back up the database instance, see Create an On-Demand Backup.

    To schedule a database instance backup, see Disable and Re-enable Scheduled Backups.

    To restore from a database backup, see Recover to Most Recent Backup and Recover to Specific Backup.

What can I use the various backups for?

  • Oracle Analytics Cloud service backup: Use to recover your service if the virtual machine crashes or your service is corrupted.

  • Oracle Analytics Cloud user content snapshot: Use to revert to a prior snapshot that you may have taken as a checkpoint. You can also use snapshots to migrate user content from one Oracle Analytics Cloud service to another.

  • Oracle Database Cloud Service backup: Use to recover from a database failure or crash. If the database is entirely dedicated to a single Oracle Analytics Cloud service, then you can use this backup to recover the content users create in that service.

How often should I back up?

  • Oracle Analytics Cloud service backup: Schedule weekly full backups and daily incremental backups. In addition, take a full, on-demand backup before you patch your service or before you make any significant changes to your service, for example, if you scale up, scale down, and add storage.

  • Oracle Analytics Cloud user content snapshot: Take Oracle Analytics Cloud snapshots before making major changes to the business intelligence content. You can take regular weekly snapshots or at your defined frequency based on the rate of change of the business intelligence environment and rollback requirements.

  • Oracle Database Cloud Service backup: Schedule weekly full backups and daily incremental backups. In addition, take a full backup before you patch.

How do I find the version of a service instance backup?

In My Services, backups are listed by the timestamp when the backup was created. If you compare the timestamp of a particular backup with your service’s patch history, you can determine the version of the service in that backup.

For example, you create a service on 4/14/2018 with Oracle Analytics Cloud version 18.2.1 and take backups on 4/16/2018 and 4/18/2018. On 5/14/2018, you apply patch version 18.2.3 and take a backup on 5/16/2018. In this case, backups taken on 4/16/2018 and 4/18/2018 are from service version 18.2.1, whereas the backup taken on 5/16/2018 is from service version 18.2.3.

Do I need to back up and restore the actual data associated with my data sets separately?

If you import a snapshot to a different environment, then you must upload or import the data from data sets again after restoring from a backup.

Where are backups stored?

Backups for Oracle Analytics Cloud and Oracle Database Cloud Service are stored on Oracle Cloud Infrastructure Object Storage, in two, separate storage containers.

  • Oracle Analytics Cloud service backups: When you create a service with Oracle Analytics Cloud, you select the container you want to use for backups.

  • Oracle Analytics Cloud user content snapshots: Snapshots are stored in the same container as your Oracle Analytics Cloud service backups.

  • Oracle Database Cloud Service backups: When you create a database with Oracle Database Cloud Service, you select the container you want to use for backups. You can’t store database backups in the same container as you store theOracle Analytics Cloud service backups.

Can I use my database backup to restore user content instead of my Oracle Analytics Cloud snapshot?

Yes, but only if the database is dedicated to a single Oracle Analytics Cloud service. If you share the database across multiple services or use the database to store other data, you must use snapshots to recover user content for individual services.

Before you restore from a database backup, verify that the version of Oracle Analytics Cloud you’re currently using and the version in the backup are the same.

Is there a specific order that I must follow while restoring?

In the unlikely event you need to restore everything, restore the database first, and then restore Oracle Analytics Cloud. If you have user content that you must restore from a snapshot, then restore that content last.