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
-
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 do I configure application continuity for ADW-S (Serverless)?Summary: We are running the Oracle Integration PaaS Service. It connects (via the default ADW wallet) to an ADW-S DBaaS Sevice. When the ADW service is patched (weekly o…
-
Cannot start Oracle Autonomous Database because its resource plan does not existSummary: Hello! I'm not sure if this is the right place to ask (never asked a question on Oracle Community before), but this seems to be where my OCI interface leads me …
-
How to setup notifications for planned maintenance on Autonomous Database Serverless Services?Hi Everyone! We have several DBaaS Autonomous Database services (ADW-S). Each week, these services are updated, by Oracle, on a regular schedule. Within OCI, on the Auto…
-
How to insert comma delimited values in one column using DBMS_CLOUD?Summary: Hi Team, We are trying to insert the bulk data using DBMS_CLOUD_COPY_DATA/DBMS_CLOUD.CREATE_EXTERNAL_TABLE. In source file, We have few columns like tags/additi…
-
Can a consumed data share be subsequently shared out?For example: If I'm consuming a databricks datashare, that results in a external table/view in ADW, can I then configure that external table/view to be a part of a ADW d…
-
DBMS_SHARE.CREATE_SHARE_LINK_VIEW failing with ora-20863Summary: I've set up a share link to a share provide that I've confirmed can be authenticated to by running: SELECT *FROM DBMS_SHARE.DISCOVER_AVAILABLE_TABLES(share_prov…
-
Time Zone Date in APEX ApplicationSummary: when query about current time zone in SQL Workshope of oracle Apex by : select CURRENT_TIMESTAMP from dual; Apex Application Setting when set default value by :…
-
how can you download apex patch images folderSummary: If you are using APEX in OCI free autonomous database with cutomer maintained ORDS vm frontend. How do you get a copy of the apex images folder for the point re…
-
The clock time on my autonomous database is wrongSummary: The clock time on my autonomous database on OCI free in LONDON is 2 minute slow. I have a friend who has an instance in Cardiff data centre and if we issue the …
-
URGENT: Database Connection Error HTTP Status Code: 571Sorry for the duplication —> https://community.oracle.com/customerconnect/discussion/871055/database-connection-error-http-status-code-571 Summary:Oracle ATP - Free Tier…
-
Need to shrink tablespaces after datapump: ORA-65114 (Always Free APEX)Summary: I have basically the same issue as this other thread: I created schemas with my tables and data from datapump exports (using object storage and dbms_cloud). A t…
-
Serial APEX WorkflowSummary: How to build serial approval in Apex workflow Specially if there is near 6 to 7 levels of approvers Content (please ensure you mask any confidential information…
-
Add attachement when create task definationSummary: Is it possible to add attachement when create task defination in oracle apex work flow Content (please ensure you mask any confidential information): Version (i…
-
powerbi desktop connecting to Oracle Autonomous DatabaseSummary: I need to get data in Microsoft PowerBI from Oracle Autonomous Database. And I got this error. Does not look like I can establish the Oracle Autonomouse Databas…
-
DPY-6000: Listener refused connectionSummary: Unable to connect to ATP DB via Python code DPY-6005: cannot connect to database (CONNECTION_ID=""). DPY-6000: Listener refused connection. (Similar to ORA-1250…
-
Oracle EPM as Data Source for APEXHas anyone successfully configured an Oracle EPM application as a REST Data Source for APEX? Any tips or advice would be much appreciated… I see SaaS as a data source ty…
-
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…