To use the DBMS_CLOUD and other packages in the DBMS_CLOUD family of packages, you must complete certain tasks.

Starting with Oracle Database 23ai (23.7), you can install DBMS_CLOUD and other packages of the DBMS_CLOUD family with installation scripts deployed with Oracle Database. These packages are not preinstalled. You must manually install these packages, and also configure users or roles to use these packages.

• Using the DBMS_CLOUD Family of Packages
  Learn about the requirements for deploying and using the DBMS_CLOUD family of packages.
• Installing DBMS_CLOUD
  To use the DBMS_CLOUD family of packages on a customer-managed Oracle Database, you must create a new user and install DBMS_CLOUD packages as that user.
• Create SSL Wallet with Certificates
  To access HTTP URIs and Object Stores safely from within your database, you must create a wallet with the appropriate certificates.
• Configure Your Environment to Use the New SSL Wallet
  To have your SSL wallet take effect on your Oracle Database environment, you must point to the newly created SSL wallet.
• Configure the Database with ACEs for DBMS_CLOUD
  Create Access Control Entries (ACEs) to enable communication with Object Stores and other trusted https endpoints (URIs).
• Verify Configuration of DBMS_CLOUD
  After you verify that the DBMS_CLOUD code is correctly installed, verify the proper setup of the SSL Wallet and the Access Control Entities (ACEs).
• Configuring Users or Roles to use DBMS_CLOUD
  After successfully installing DBMS_CLOUD, you must configure users or roles to be able to use all of its supported functionality.