To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Autonomous Database
Discussion List
-
GA ANNOUNCEMENT - Access Control Lists Honored By ADB Built-in ToolsSummary ADB's built-in tools (APEX, RESTful services and SQL Developer Web) are now subject to ACLs.Content ADB's built-in tools (APEX, RESTful services and SQL Develope… -
Why Autonomous Database Doesn't Work With Apex 19.2 ?Summary Oracle Upgrade Oracle Apex Version On Autonomous DatabaseContent I Need Oracle Upgrade Oracle Apex Version From 19.1 To 19.2 On Autonomous Database To Gain Oracl… -
NAVersion 18c -
Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot getSummary Error while connection to apex using oracle autonomous databaseContent Hi I receive this error while trying to connect to apex; this occurs today for first time.… -
ATP - receiving 503 Service Unavailable while starting sql developer or ApexSummary not able to access sql developer and ApexContent ATP Database is up and previously both sql developer and Apex were connecting to it with no problem. currently r… -
404 Not FoundSummary Getting 404 Not Found error while trying to open APEX or SQL Developer WebContent Took cloud always free and created an ATP database, went to service console > a… -
Error 404 when connecting via ORDSContent Hi, i want to connect to the ATP instance via APEX/ORDS and get the error 404 in the browser, but the Autonomous Database shows 'Available' in the state. Further… -
GA ANNOUNCEMENT - New Names For Deployment OptionsContent Note that the terms for describing the deployment options for Autonomous Data Warehouse have been updated. The new names for the deployment options are: * Shared… -
GA ANNOUNCEMENT - Updated Schema AdvisorSummary A new release of the Autonomous Database Schema Advisor has been posted.Content A new release of the Autonomous Database Schema Advisor has been posted. Here are… -
GA ANNOUNCEMENT - New PL/SQL Packages AddedContent Both UTL_HTTP and UTL_SMTP PL/SQL packages are now supported by Autonomous Database. Both packages are subject to a number of restrictions which are clearly expl… -
GA ANNOUNCEMENT - Metadata Extensions within DBMS_CLOUDContent DBMS_CLOUD has been extended with the following new subprograms: 1) LIST_FILES Function - lists the files in the specified directory. The results include the fil… -
GA ANNOUNCEMENT - Networking QuickStart WizardSummary The OCI network team has announced the general availability of a new Networking QuickStart wizard.Content The OCI network team has announced the general availabi… -
GA ANNOUNCEMENT - Partitioned External Tables now support Parquet and Avro FilesSummary CREATE_EXTERNAL_PART_TABLE procedure now supports both Parquet and Avro files formats.Content CREATE_EXTERNAL_PART_TABLE procedure now supports both Parquet and … -
GA ANNOUNCEMENT - Maintenance window now visible on consoleSummary On the Autonomous Database details page, the "Next Maintenance" field shows the date and time for the upcoming maintenance window.Content All Autonomous Database… -
Error in loading an application page in APEX Builder on ATPContent Hello! Last couple of weeks when I open APEX through OCI, ATP db, Any page of any application is not loaded in the App Builder. Error is: SyntaxError: JSON.parse… -
503 on REST and APEX services with ACL enabledSummary When ACL's are enabled on the database the REST and APEX services are unavailableContent Hi, struggling a bit with the understanding of the ACL's. According to t… -
Not able to connect to Autonomous Database using sqlplusSummary Not able to connect to Autonomous Database using sqlplus or tnsping Content I created an Autonomous Database, transaction processing workload, serverless deploym…User_2025-02-06-06-01-49-041 34 views 2 comments 0 points Most recent by User_2025-02-06-06-01-49-041 -
How can I reduce storage utilization?Content Even after I drop my table including recyclebin, storage utilization shown on Service console won't be decreased. How can I reduce storage utilization? -
Rename schema in ATP?Summary How can a schema be renamed? Content When I started using the cloud ATP system, I used what is likely the default schema of "WORKSPACE_1". How do I rename that? … -
Oracle Cloud stopping due to inactivitySummary Oracle Cloud stopping due to inactivityContent I have an Oracle Cloud Autonomous Database running in the Free Tier. Occasionally the database stops. When viewed …User_2025-02-06-06-01-37-824 53 views 8 comments 0 points Most recent by User_2025-02-06-13-16-25-165 -
Not able to access bad file created by DBMS_CLOUD.validate_external_tableSummary KUP-04040: file VALIDATE$137_320200.bad in DATA_PUMP_DIR not foundContent We are trying to validate external table using dbms_cloud.validate_external_table proce… -
How to connect standalone ORDS with ATP database?Summary How to connect standalone ORDS with ATP databaseContent Hello, I have created OC Instance with installed ORDS (run as standalone). I have created ATP Database, w…User_2025-01-31-02-31-54-062 23 views 2 comments 0 points Most recent by User_2025-01-31-02-31-54-062 -
PDF printing is disabled in APEX on autonomous databaseSummary Cannot print pdf documents from XSL-FO layoutContent Failed to read this for autonomous database: PDF, Excel, and Word printing options are disabled. You may be … -
Generating AWR Report for ADB(always-free)Summary Could you tell me how to generate AWR Report for ADB(always-free)?Content https://docs.oracle.com/en/cloud/paas/management-cloud/mcdbm/generate-awr-reports-diagn… -
Autonomous Database and timezoneSummary how to change a timezone in an Autonomous DatabaseContent i use the parameter TIME_ZONE but the value don't change Oracle Database 18c Enterprise Edition Release… -
GA Announcement: ADB ACLs Now Support OCI VCNsSummary (Serverless only) If the client machines reside in an Oracle Cloud Infrastructure Virtual Cloud Network (VCN), you can configure a Service Gateway to connect to … -
GA Announcement: New "Tools" Tab on OCI Console for quicker access to built-in toolsSummary The UI for the Oracle Cloud Infrastructure Console has been updated with the addition of a new tools tab alongside the existing tabs for information and tags.Con… -
GA Announcement: SQL Developer Web now supports data loadingSummary ADB Serverless has been updated with SQL Developer Web 19.2.1. SQL Developer Web now supports loading data into an existing table.Content ADB Serverless has been… -
Automatic Indexing enabled?Content https://cloudcustomerconnect.oracle.com/resources/ae46f0cd09/posts/create?type=6 According to the document, Automatic Indexing is enabled in ATP. By default does… -
Registering own schema to publish custom packages on Oracle database in ATPSummary ORDS, ATP databaseContent We have created ATP database. In the database, we created new schema called YOUR_APP_SCHEMA and create HR tables. We registered schema …