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
-
Cross-Region Autonomous Data Guard Is Now GAContent Each region has one or a few nearby "paired regions" in which a remote standby may be created. Make sure your tenancy is subscribed to the remote region in which… -
Unable to connect to ATP database using SQL DeveloperSummary Network adapter could not establish the connectionContent Hi experts, Am facing issue while connecting to ATP database. * Connected to VPN using cisco client. * … -
ATP Always Free Storage Filling UpContent Hi, I am having the same Always Free ATP storage issues that have been mentioned numerous times on this forum - ie, the 20gb space filling up outside of any user…User_2025-02-11-19-14-59-107 146 views 8 comments 0 points Most recent by Kuljeet Singh - Oracle-Oracle -
Issue on JSON data insertion in ATP tableContent Hi Experts, I am trying to insert JSON file data into ATP table through OIC JSON file is in Master child data form so I am inserting master data "PENN_DREQ_Parts… -
ADW not showing sysdate correctly as per timezoneContent Hi Team, We have deployed ADW in a shared infra and currently facing issues to show "sysdate" correctly as per the customer defined timezone. Our DB timezone par…
-
ORA-00018: maximum number of sessions exceededSummary Getting ORA-00018 when trying to connect to ADWContent Hi all, I was wondering if you could help/point me in the right direction. I have been getting the "ORA-00…
-
OML Notebooks: "Application error. Please contact support."Summary "Application error. Please contact support." error received when attempting to open or create new notebooks in OMLContent When using Oracle machine learning note…
-
Unable to access any of the tools on my allways FREE ATPContent Unable to access any of the tools on my allways FREE ATP, for instance trying to access APEX results 404 Not Found. Same goes for Database Actions.
-
ORDS on ATP how to enable Basic AuthSummary ORDS on ATP using Postman, how to enable Basic AuthContent I have an ATP database with a REST enabled table. I can successfully run a GET and POST (Insert) from …
-
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…
-
Always Free Autonomous Databases (APEX)- Shared Infrastructure: Missing/UnavailableSummary In the databases overview I can see that I have 1 Database but when I select APEX - Shared Infrastructure I cannot see any Database instancesContent In OCI > Dat…
-
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
-
Always Free ATP Database stuck in starting for 24 hours (Phoenix West)Summary I tried to start the ATP database and it is saying starting for long timeContent All options under action are grayed out and the database is not starting any one…
-
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 …
-
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…
-
Upgrade always free to (always) payContent Hi, In my tenant, I run 2 always free databases (ATP and ADW), a free compute, free object storage, free block volumes.So the whole free tier I run an APEX app o…
-
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… -
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…
-
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…
-
I am charged for Oracle Analytic; eventhough I did not use the service.Summary I am charged for Oracle Analytic; eventhough I did not use the service.Content I used Oracle Analytic during the rial period. Then I left the database down. Orac…
-
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…
-
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…
-
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,… -
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…
-
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…
-
To insert values from one table to anotherContent Hi team, So there is this table having 4-5 columns in which we will insert the ID and another column name, (say names) , values , into the child table where the …
-
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…