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
-
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…
-
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…
-
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…
-
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…
-
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… -
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…
-
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…
-
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…
-
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… -
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…
-
Why are my newly created 23ai databases going straight from "Provisioning" to "Unavailable" ?Summary: I can't migrate my 21c DB to 23ai simply because I can't create and start a 23ai DB. Content (please ensure you mask any confidential information): I'm trying t…
-
ATP DB Schema RenameSummary: I am seeking your expert advice on a significant change that we are planning to take. Could you kindly share any recommendations regarding the following scenari…
-
Loading database via live feed not loading alphanumeric data on Autonomous DBSummary: When loading data via Autonomous DB the data load does not load entries that are alphanumeric even though data type is set to VarChar2 Content (please ensure yo…
-
PLS-00904: insufficient privileges to access object PUBLIC.DBMS_CLOUDHello, I have compiled a DB package with the admin user and I get a privilege error. I have modified the package and it gives me error, and it was working fine before. T…
-
Oracle Cloud is getting a new fresh look & feel - Redwood styleWhen you sign in to Oracle Cloud, the OCI home page might have a completely new look. Our cloud team is rolling out the new Redwood-style look-and-feel across all the se…
-
Linking Oracle Object Storage File as External Table in ADWHi, I work on the EPM side of things normally, but recently signed up for a free OCI account to test out ADW functionality (since this functionality is coming as a free … -
GA Announcement: Set CPU/IO Shares for Autonomous Data WarehouseSummary Autonomous Database now allows customers to change the CPU/IO shares for the consumer groups within their ADB instance (high, medium, low, tp, tpurgent).Content …
-
It is possible recover / restore from last backup AlwaysFree 21c databaseSummary: Hello everyone, I know, OCI has informed that the AlwaysFree 21c databases will be removed. But TBH, I have found in my mailbox just one e-mail about it. But ok…
-
Inporting application from an Autonmous database to another on OCIHi, I am on alway free database unsing APEX database. I wouldlike to import application from one database to another. What are the steps involved ? Best regards. -
how to connect to oracle Cloud 24c FSCM database from ExcelSummary: I would like to know the steps to connect to oracle Cloud 24c FSCM database from Excel. Content (please ensure you mask any confidential information): Version (… -
The Autonomous Database operation failed due to an unknown error.Summary: Good morning, My OCI Autonomous Database is currently in a STOPPED state and will now not restart. When trying to restart, it takes around 20 minutes and then g…
-
Unable to copy JSON data from OCI Object storage to DB tableSummary: I have a JSON payload in OCI Object Storage and is available through public URL.I am trying to copy this data to an existing table TEST_TABLE_MAIN Question1) Th…
-
Select AI With RAG - AI Profile attribiutesHello, I have a query regarding the Creating AI Profile for Oracle Select AI with Retrieval-Augmented Generation (RAG). Specifically, I am curious about the behavior whe…
-
how to create ords api to send file as a multipart attachment in requestSummary: Hi Experts How to create a ORDS REST API to send a file as a multi part form data and insert into a table column of blob type. Please help me. I do not want to …
-
How to create a read-only user in an ATP databaseSummary: Our customers request to create read-only users in the ATP databases they have, basically they want to have a user who can only inquiry tables and check databas…
-
Need to call DBMS_CLOUD but EXECUTE grant was removedSummary: One of our customers has two ATP instances with DBMS_CLOUD, they have several PL/SQL packages where they call DBMS_CLOUD without issues until last week where in…
-
Issues running Oracle Apex on ATPSummary Apex shows blank page when trying to access via tools menuContent Hi,I have an Autonomous Transaction Processing Database instance set up on the Oracle cloud. Th…