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
-
Thanks and AppreciationContent Just writing this message to say Thank You and show my appreciation for the support received on this forum when I thought I had lost a vital DB (due to my oversi…
-
ADW ArchitectureContent Hi team, Are there any resources regarding architecture of ADW, whether the architecture of ADW comprises of any 2-tier or 3-tier layer? Thanks and Regards Ankan
-
Unable to access Apex application on Free OCISummary Internal Server Error 500Content Hello Support Team, Since last week I am continuously getting Internal server error on my Apex instance on Free Oracle Cloud. I …
-
Advice on reducing SYSAUX size in ATP/ADWSummary Database / SYSAUX tablespace consumes 14+ GB (of 20GB)Content In Always Free ATP/ADW, Oracle provides 20 GB of storage. I am unclear what counts towards this lim…
-
Unable to connect to ATP from Linux Compute NodeSummary Connectiong to ATP from Linux Compute Node-ORA-12162: TNS:net service name is incorrectly specified.Content Hello, When trying to connect to ATP using Linux Comp…
-
Documentation on Flows for APEX- Create/Start and Complete Step plug-insContent Hi team, As per the latest documentation on Flows for APEX in Github , there isn't detailed information on Flows for APEX- CREATE/START , Complete Step processes…
-
change LOB_SIGNATURE_ENABLE parameter on ATP database 19cSummary ADMIN user cant do this?Content Hello, I have one ATP always free DB version 19c with small APEX application. This Cloud ATP database gets data from onpremise da…
-
Getting ORA-01403:no data foundContent Hi Team I am trying to use flows for apex with my current apex application . I have created a simple flow with Approval Hierarchy with an User task to create a p…
-
Oracle Learning Library - Getting Started Workshop for Autonomous Data Warehouse - 404 errorsSummary If try to follow any of the links to Labs, I get 404Content https://apexapps.oracle.com/pls/apex/f?p=44785:50:6294496264109:::50:P50_COURSE_ID,P50_EVENT_ID:251,5…
-
Always free databases; can someone PLEASE tell us how to determine available storageContent Hi, In this forum, there are many questions about available storage on ATP/ADW, why it seems to reduce by the day, even without any developer activity, so what i…
-
DBLink to be created from ADW to a OCI DBContent WE are trying to create a DBLink from ADW to OCI DB but failed. We followed the following two documents: 1. Create and Configure Database Link in Autonomous Data…
-
Both Free OTP and Datawarehouse constantly going down. Unable to create technical support ticket. WhSummary Both Free OTP and Datawarehouse constantly going down. Unable to create technical support ticket. What to do?Content Both free ATP and Datawarehouse going down w…
-
Unable to delete Old Version Apex Schema from ATP DatabaseSummary Unable to delete Old Version Apex Schema from ATP DatabaseContent Hi, I found that every time APEX is upgraded in ATP Database, the old apex schema is not delete…User_2025-02-08-09-03-28-606 35 views 4 comments 0 points Most recent by User_2025-02-08-09-03-28-606
-
Scheduler CPU usage counts towards OCPU costs?Summary My aplication uses very little cpu. But Oracle itself uses a lot e.g. internal scheduled jobs.Content I am trying to figure out whether CPU consumed by Oracle da…
-
I haven't developed any apps and my storage is already at almost 50% of the limitSummary Storage consumption grows daily even without any application developmentContent Hi, My 2 ATP databases grow daily I realized using SQL DEVELOPER that these are S…
-
ATP DB Cloud Storage Consumption IssueSummary ATP DB Cloud Storage Consumption IssueContent All, I have free trail Database with APEX application running for more than 3 months. But recently I have noticed D…
-
JSON Database Action - options in Create Collection greyed outContent Created Always Free Autonomous JSON Database, created new user, granted SODA_APP When creating new JSON collection using Database Action JSON, Create Collection,…
-
ORDS - 500 Internal Server Error when using Ressource limitsSummary Setting a Ressource Query time limit for "Low" and ORDS will stop working (500 Internal Server Error)Content Steps to reproduce (on free tier cloud) 1. Create an…
-
Cannot find my always free database in my tenant - could anyone help pleaseContent I cannot find my always free database in my tenant which I had created in 2019 and had been using it more than a year via my simple APEX application to administe…
-
Can an APEX page generate a URL link?Content Hi team, I just want to know, can an APEX page generate a URL link so that an external application can redirect to that particular APEX page? So there is this mi…
-
How to restrict user to service (low/medium)Summary If I have 2+ database services, and 2+ users, how can I ensure/restrict userA to db_low, and userB to db_mediumContent Is there a way to do this without resortin…
-
ORDS on ATP basic Postman GET and PUTContent I am trying to perform a basic PUT from Postman to insert a record. I cannot figure out the proper syntax. I am just learning about ORDS and ATP. We have an ATP …
-
Can an APEX page generate a URL link?Content Hi team, I just want to know, can an APEX page generate a URL link so that an external application can redirect to that particular APEX page? So there is this mi…
-
ORDS not working on ADWSummary 500 Internal Server Error - An unexpected error with the following message occurred: nullContent Hi, I hope you can point me in the right direction as I haven't …User_2025-02-08-03-47-01-847 33 views 6 comments 0 points Most recent by User_2025-02-08-03-47-01-847
-
PDF printing is disabled in APEX on autonomous databaseSummary How to get a printout in APEX without AOPContent APEX is just great and gets better all the time. Just created my autonomous database, transferred all the APEX a…
-
How to remove old backups from always free database serviceContent I have an Autonomous Transaction Processing instance on an Always Free OCI instance. My database version is 19c. The database has been automatically set to be ba…
-
GA ANNOUNCEMENT: New Database Actions Tools - Self-Service Data Warehousing for EveryoneContent Autonomous Database Tools Are Now Fully Available Autonomous Database now includes tools for quickly and easily loading data, building zero-code data transformat…
-
API made inside APEX fetching limited rowsContent Hi team, As I have created a table and an API whose operation is to get all the rows, the API is made using Restful Services inside APEX and the SQL query put is…
-
how to write a file using a query in atp databaseSummary how to write a file using a query in atp databaseContent how to write a file using a query in atp database and have that file stored in object storage area. rega…
-
Get 503 Service Unavailable when trying to access APEX or SQL Dev WebContent Created two new ATP databases Always Free today. One works fine the other fails when trying to access APEX or SQL Dev Web: 503 Service Unavailable 2021-03-03T01:…