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
-
REMINDER: ADB OCPU billing metric has been retired and replaced by the ECPU billing metricREMINDER: The Autonomous Database OCPU billing metric has been retired and replaced by the ECPU billing metric. OCPUs will no longer be available for new databases start… -
Introducing Oracle Cloud Infrastructure (OCI) Data Retention Platform for Oracle E-Business SuiteIntroducing the Oracle Cloud Infrastructure (OCI) Data Retention Platform for Oracle E-Business Suite (EBS)! Enterprises are going through a tremendous transformation wi… -
All Always Free 21c instances have been decommissionedPlease note that all Always Free 21c instances have now been decommissioned and are no longer available. Some instances may still be visible on your OCI console but you …
-
Blog Post - Overview of observability and management cloud services for Autonomous DatabaseJust published a set of blog posts on the various Autonomous Database Serverless. Although Autonomous Database is a highly automated service, it does provide cloud and f…
-
Announcing new advanced monitoring for Autonomous Databases with OCI Database ManagementWe are excited to announce that OCI Database Management service now has new, easy-to-use tools that enable advanced monitoring and management of ADB resources. These too…
-
A quick and easy way to migrate your Always Free 21c instances to 23aiSummary: With the introduction and availability of Oracle’s latest database version, Oracle Database 23ai, in our Always Free tier, you can now migrate your Always Free …
-
[URGENT] Please move all Always Free 21c instances to 23ai as soon as possible!With the introduction and availability of Oracle’s latest database version, Oracle Database 23ai, in our Always Free tier, you can now migrate your Always Free 21c datab…
-
A quick recap of ADB announcements at CloudWorld Las VegasA quick recap of ADB+GenAI announcements from CloudWorld Las VegasA couple of weeks ago we held our annual customer conference in Las Vegas. During the event, there were…
-
Your Free Guide to Everything Autonomous at Cloudworld 2024To get you ready for CloudWorld 2024 in Las Vegas, I have put together a quick must-see guide covering all the important sessions, workshops, and tutorials by the Autono…
-
May's latest new feature announcements for Autonomous DatabaseSummary: As May comes to a close, here is information about the new features released during the last 2 weeks along with some customer success stories. Don't forget to s…
-
Cannot SSH to instance & How to connect to the ATP from linuxContent Problem: I am getting error when I try to SSH to the instance from Mac computer. IP address and the user id that I am using were provided on the Instance Detail …
-
ANNOUNCEMENT: February's newsletter covering all the latest new features in Autonomous DatabaseList of all the new features recently added to Autonomous Database (too many to list) in our regular "What's New" newsletter - https://blogs.oracle.com/datawarehousing/p…
-
Oracle ATP database shows column - cloud_maintained what does it mean?Oracle ATP database shows column - cloud_maintained What does this column mean? This column is visible when running query against a Oracle ATP database in oci: select * …
-
service gatewayquestion very interesting and urgent!! The Service Gateway allows private traffic between resources in a VCN and public services of OCI but of other tenancies? The Servi… -
Ajax call returned server error ORA-01840: input value not long enough for date formatSummary: today i am getting the following error when passing a page item value (date picker) from one page to another page. It has never happened before. It is a strange…
-
ORA-20401: Authorization failed for URI using dbms_cloud access to object storageSummary: Getting authorization failed error connecting to the object storage from oci base 23 ai db. ORA-20401: Authorization failed for URI - https://objectstorage.us-c…
-
TEST performance of an APEX aplicationWe need to observe the performance of an ORACLE APEX application. Metrics like: • Largest Contentful Paint (LCP) • First Contentful Paint (FCP) • Cumulative Layout Shift… -
Oracle Learning Lounge Webcast: Oracle Database 23ai - JSON-Relational DualityDATE: March 18, 2025 TIME: 9:00 AM - 10:00 AM US/Pacific Join Oracle’s renowned Julian Dontcheff (Distinguished Product Manager, PL/SQL and JSON) for an exclusive Learni…
-
Issue connecting to 23ai autonomous data warehouse "Always Free" instance - ORDS HTTP Status 571Summary: Due to 21c "Always Free" instances being imminently decommissioned, I rebuilt a database in 23ai. The original 21c database was an APEX instance, and I decided …
-
Modification/Manual Allocation of Default Consumer Group Concurrency and DOP in ADW?Summary: Is it possible to modify the default concurrency and DOP provided within the pre-set consumer groups in ADW? For example, if you do not need as much concurrency…
-
cant start a stopped autonomous db, when I want to see the details I got an errori cant start a stopped autonomous db, when i want to see the details i click its name and i got an error: "An unexpected error has occurred: Authorization failed or requ…
-
Space Usage in container is too high on ATP DBSummary: Hi, I'm having an issue with my (Always Free) Autonomous Data (Transaction Processing workload type) where for some reason it thinks that it is full but I haven…
-
When is APEX 24.2 getting released for Oracle Cloud ATB Database.24.2 has the Bug Patch for 37117164 Can anyone say when it's getting released
-
Create DB LINK between ADW and ATP DBSummary: Hello Experts, For our use case, we need the data stored in ATP DB to be available in ADW DB for another team. For this we are planning to use the DB LINK conce…
-
Hi, I am facing issue with oracle live labs OCI loginSummary: Hi, I am facing issue while logging into OCI console. I have used oracle live labs Run on Live Sandbox option to use OCI. I have used the username and password …
-
DPY-6005: cannot connect to database (CONNECTION_ID=qkBuaD1Uq1JopfePKo/5rA==) pythonanywhere.com ATPPython connectivity with ATP DB is working fine on local machine using the below code import oracledb Define connection detailsconnection = oracledb.connect( user="admin…
-
How we can convert big data file into single vector chunkIs there any way to convert complete CLOB data into single vector chunk. if yes which function we can use to convert. Currently i am using TO_VECTOR(VECTOR_EMBEDDING(doc…
-
ATP: dbms_cloud.put_object returns ORA-28862: SSL connection failedSummary: We are in the process of uploading a significant dmp file from the database directory (DATA_PUMP_DIR) to an AWS S3 bucket using the dbms_cloud.put_objectAPI. Us…
-
autonomous database stopped not getting startedThe Autonomous Database operation failed due to an unknown error.Refer to JobId 4e38655a-a43d-473b-be51-8fbc8ce0ad4d and WorkRequestId a6a903e7-ff6e-442a-983f-5891873139… -
Is the OCI in Johannesburg down? I get this Apex errorSummary: I have a issue that all my Apex apps dont work on the Johannesburg South Africa cluster If you click on this link you will see that Apex has an issue. Oracle AP…
-
How we can query to dba_object table in ATP?Hello. Is there any way to query dba_objects, dba_sources, dba_tables table in ATP dabase?. According we check with the ADMIN user we don't have granto query this tables…
-
APEX_MAILSummary: Hi, Trying to use apex_mail from Apex running on ATP in the Free tier of the Oracle Cloud and I think I got all the setup done correctly : Note: There was the n…
-
how to do loadjava in ATP- Java stored procedure in ADB ?-Summary: Hi Could someone please guide how to use the loadjava tool as per the documentation to create the java files as stored procedure into ADB. I have the java sourc…
-
Service limit for ORDS in ATP DatabaseHello Everyone, Can you please let us know service limits for ORDS services in ATP database ? I found the documentation regarding the OIC but no luck with ORDS(APEX). Th…
-
How can I apply dynamic filters based on user roles and departments in Select AI?How can I apply dynamic filters based on user roles and departments in Select AI? When we create profile on the data (like Sales Data) so it contain all data from differ…
-
403 Error when Uploading ZIP Files in Oracle APEX on OCI Integrated with Oracle ERPI'm experiencing an issue with my Oracle APEX application, which is integrated with Oracle ERP and deployed on OCI (Oracle Cloud Infrastructure). It’s important to note … -
dbms_cloud.copy_data Issue : ORA-20000: ORA-29283: invalid file operation: nonexistent file or pathWe are calling the dbms_cloud.copy_data procedure to download the file data in ATP db. It was working fine until couple of days back.Suddenly it has started throwing bel…
-
Apex not working after update, invalid packagesSummary: Apex is not working after its update . I cant even see Apex instance, i can use database. I see 2 invalid packages bodies APEX_240100.WWV_FLOW_CGI APEX_240100.W…
-
Uncommited Multipart Uploads - Storage BucketHi Team, We have uploaded files from onpremise linux server to OCI object storage bucket using below commands. sample :. oci os object bulk-upload --namespace-name axqui…
-
Is there an up-to-date Product Roadmap available for ADB/ADW?Summary: My organization would like to understand the product/feature roadmap for Autonomous Database, in particular the ADW flavor of it. I've looked but couldn't find …
-
not able to set ai profile using EXEC DBMS_CLOUD_AI.SET_PROFILESummary: Created an AI profile using command DBMS_CLOUD_AI.CREATE_PROFILE and set with command EXEC DBMS_CLOUD_AI.SET_PROFILE But, after running above scripts, when vali…
-
How Do I Access Files Created In Autonomous Database DATA_PUMP_DIR DirectorySummary: My OCI account is using an Autonomous Database and it came with an Oracle directory object called 'DATA_PUMP_DIR' which points to a specific file system directo…