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
-
ORA-29261: bad argumentSummary Loging in to any workspace results in a ORA-29261: bad argumentContent When I try to login to my Oracle Free Cloud Apex, it always results in a "ORA-29261: bad a… -
503 Service Unavailable java.sql.SQLRecoverableException: No more data to read from socketSummary Cannot access Oracle Apex on ATP Always Free LicenseContent Hi! My Oracle ATP on Autonomous suddenly stopped running. Facing ORDS error 503 Service Unavailable. … -
ORA-02002: error while writing to audit trailSummary Not able to connect to free OTPContent I am getting: ORDS was unable to make a connection to the database. This can occur if the database is unavailable, the max… -
Newsletter for Autonomous Database on Shared Infrastructure (June 24-2020) is now availableContent Latest edition of the newsletter for Autonomous Database on Shared Infrastructure (June 24-2020) is now available here: https://blogs.oracle.com/datawarehousing/… -
GA ANNOUNCEMENT - Reference Architecture Patterns and Solution Playbooks Now AvailableContent The Architecture Center has been u[dated to include a new series of data warehouse patterns: Each reference architecture pattern will come with the following: be… -
GA ANNOUNCEMENT - Procedures For Using Database Real Application Security With ADBContent Real Application Security works the same on Autonomous Database as on an on-premise database except you need to perform some additional administrator tasks befor… -
GA ANNOUNCEMENT - Maximum File Size Increased For Transfer Object StoreContent The maximum file size limit for DBMS_CLOUD.PUT_OBJECT procedure when transferring files to OCI Object Storage has been increased to 50 GB. Note - there are diffe… -
GA ANNOUNCEMENT - Download AWR Reports From Performance HubContent Automatic Workload Repository (AWR) report is a vital tool to collect historical performance statistics of an Oracle Database by DBAs and System Performance engi… -
GA ANNOUNCEMENT - ADW now supports ORC filesContent ADB has expanded object storage support in two important ways: it can now query ORC files as well as complex data types found in Parquet, ORC and Avro files. ORC… -
No Primary Key item has been defined for form regionSummary Clicking button to new page causes internal APEX errorContent Hi Gurus, I'm getting an error when clicking a button to go to a new page for a simple registration… -
Error: SyntaxError: Unexpected end of JSON inputSummary Unable to view or edit Apex page in Page designerContent When clicking on a page in the page designer to edit the page the error occurs. The error also occurs wh… -
ADW API deprecationSummary How to find the ADW API's in my environment - Deprecated Autonomous Data Warehouse APIsContent We got a notification from Oracle regarding 'Autonomous Database A… -
APEX in ATP - Private EndpointSummary Trying to use APEX with ATP workload type autonomous databaseContent Hello everyone, we have a use case where we want to use APEX in an autonomous database, howe… -
SMTP transient error after trial expiredSummary SMTP transient error in ATPContent I can send email from my free ATP until today. I got this error after my free trial is expired. Does it mean I won't get email… -
REST web service request errorSummary REST web service request error in ATPContent when I run this query in Oracle cloud ATP ( free tier), i got this error but it works ok in ADW. select apex_web_ser… -
503 Service Unavailable: ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilegeSummary Apex not starting anymore after upgrade to 19cContent I've seen more people having this issue, some of them have already been helped. But I can't seem to find th… -
Certification - Oracle Application Express on CloudSummary Certification - Oracle Application Express on CloudContent Dear APEX Experts, Currently we have Oracle Application Express 18: Developer Certified Professional u… -
DBMS_CLOUD.VALIDATE_EXTERNAL_TABLE unable to see validation errorsSummary Unable to see validation errors in either VALIDATE$21_LOG or VALIDATE$21_BAD tablesContent I have successfully created an external table in my schema, but when I…User_2025-02-08-03-47-01-847 38 views 9 comments 1 point Most recent by User_2025-02-08-03-47-01-847 -
GA ANNOUNCEMENT - SQL access to tenancy details for ADBContent When you file a service request for Autonomous Database, you need to provide the tenancy details for your instance. Tenancy details for the instance are availabl… -
GA ANNOUNCEMENT - Latency Metrics Now Available in Service MetricsContent The Database Service Metrics information help Cloud Admins measure useful quantitative data about their Autonomous Databases. This list of available metrics now … -
GA ANNOUNCEMENT - Performance Hub Now Has a Timezone SelectorContent A time zone control has been added to Performance Hub. This will allow users to view data using an alternate time zone to UTC. They will have the choice of viewi… -
GA ANNOUNCEMENT - Workload Metrics on Performance HubSummary Performance Hub has been expanded to include a new tab, "Workload". This can be used to monitor the workload in the database and helps the user identify performa… -
GA ANNOUNCEMENT - Support For Customer Managed Oracle REST Data ServicesSummary You can now use a customer managed environment if you want manual control of the configuration and management of Oracle REST Data Services.Content NEW - ADB now … -
ATP Database keeps stoppingSummary Database stops by itselfContent I have had this problem for the past few days: my ATP database stops by itself shortly (about 10 minutes!) after starting. Someti… -
utl_http.request on 19c getting Certificate Failure. works on 18cSummary utl_http.request on 19c getting Certificate Failure. works on 18cContent Using Always Free ATP I currently can only provision 18c DB. Two weeks ago I provisioned… -
ATP DB Running but not able to connect - ORDS 404 500 errorSummary ATP DB Running but not able to connect - ORDS 404 500 error Content Hello, in the Oracle Autonomous Database Cloud Service (Free Tier), I am facing the issue, th… -
Getting ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilegeSummary Not able to access Free ATP services after upgrade to 19c....Content Hi All, I've been trying to access my free autonomous database after upgrade to 19c, however…User_2025-02-08-01-55-16-032 1.1K views 18 comments 2 points Most recent by User_2025-02-08-02-44-49-767 -
Can I replace my free ATP?Summary Can I end the free ATP in my tenant and start a new one?Content HI, The storage my current free ATP used seems to be 97%. I have no clue how that happened, but f… -
How to clone ATP when stuck in "Restarting"Summary I would like to create an another ATP database from a backup while my primary is stuckContent I would like to create an another ATP database from a backup while … -
Enabling REST Data Services on ATP is failingSummary ORA-06508: PL/SQL: could not find program unit being called: "ORDS_METADATA.ORDS"Content After months of development utilizing the REST data services on our Auto…User_2025-02-05-14-51-55-798 37 views 2 comments 0 points Most recent by User_2025-02-05-14-51-55-798