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…
-
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…
-
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 …