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
-
Disable ACL on Autonomous DatabaseHi, I'm trying to disable ACL on my Autonomous Database, or more specifically, I'm trying to allow access to my APEX Workspace from everywhere, not just from the range o… -
can administrative user accounts be alteredSummary: I'm advising our internal Audit team about activities in ATP. They see administrative accounts like SYS and ADMIN. I'm trying to find documentation that states …
-
Using Apex with ATP for Building Web AppHi Team, We are assessing Oracle Apex(comes with ATP DB) as a platform to build Web App/extension to Oracle Cloud ERP. There would be around 10 extensions to be built an…
-
Role Assignment not working for ATP Custom UserHi Team, We provisioned a new ATP and using web console created new DB user and assigned unlimited quota, connect, resource and DWRole. We are able to connect from SQL d…
-
Oracle APEX 503 service unavailableSummary: Service Unavailable HTTP Status Code: 503 Request ID: 0ee5370a491db4c7f7674c355fbd8502 Request Timestamp: 2024-01-12T13:59:18.785698Z The connection pool named:…
-
AutoREST POST End-point loses all dataSummary: When using AutoREST on 23C for a specific table, if I POST to it, it loses all data that is sent along with it. This is only for this specific table, but anothe…
-
When will 23C be available on ATP?Summary: When will Oracle Database Version 23C be available on ATP?
-
Unable to import APEX Application including backup filesSummary: I have a newly created OCI account for our school and I cannot import an APEX application from a different workspace. Content (please ensure you mask any confid…
-
Create DBLINK from ATP to onprem on port different than 1522Hello, I tried to create a dblink from an ATP instance to a onprem db, and it works fine (mTLS) on port 1522. However if I try to change the port (eg: 6666) the connecti…
-
Data Transform: in the Create Data Flow Popup Window, the save button is disableSummary: I try to follow the livelab: Data Studio - Self-service tools for everyone using Oracle Autonomous Database In the Lab 7, Step 3. After I choose the connection …
-
Account has reached maximum limit for Always Free Autonomous Database instancesSummary: Hi to all, we are not able to create an Autonomous Database even though we have only 1 ADW. The error we get is: "Account has reached maximum limit for Always F…
-
ORA-20000: No Oracle File System mounted (DATA_PUMP_DIR)Summary: We are facing the same issue with, p3consulting - https://community.oracle.com/customerconnect/discussion/722932/no-oracle-file-system-mounted for both our free…
-
Difference between provisioned, allocated and used storageSummary: We provisioned an ADW instance with 1 TB storage and imported some data. Now, the allocated storage = 626 GB, while used storage = 547 GB, which indicates that … -
ANNOUNCEMENT - FREE 1-DAY AI WORKSHOP FOR ARCHITECTS AND PRACTITIONERSSign up for our free 1-day workshop to learn more about Oracle's self-service modern data platform architecture. The Oracle Autonomous Database Product Management team i… -
No Oracle File System mountedSummary: Can't backup one of my free ATP database (21c) since today and when executing SELECT * FROM DBMS_CLOUD.LIST_FILES('DATA_PUMP_DIR'); I got the error: ERROR at li…
-
Connect MYSQL Database in APEXSummary: I have a requirement to connect with external MYSQL database and bring the data to Oracle Database Cloud. Content (please ensure you mask any confidential infor…
-
dbms_cloud.list_objects not returning data as other user than ADMINSummary: As ADMIN dbms_cloud.list_objects returns a list of objetcs; As other DB user with same credentials not returning data and not returning errors. Content (please …
-
SQL developer web with Multiple TabsSummary: When using SQL developer WEB upon a ADB, only one tab of SQL code is allowed; my organization needs possibility to have multiple tabs to launch queries in paral… -
MongoDB API access disable for Always Free Cloud?Summary: Can't re-enable MongoDB API in Oracle Cloud -> AD -> Autonomous Database details -> Tool configuration tab. It was working for more than year prior todays patch…
-
retrieving old version of code ( database package)Summary: how can I retrieve the old version of the code ( database package)? Content (required): I have compiled the wrong version of a database package and lost the rig…
-
Trouble with Build Analytic Applications using APEX and Analytic Views Live LabSummary: Content (required): When trying to login as MOVIESTREAM user, I get this error. This is under Lab 3 Task 1 of the "Build Analytic Applications using APEX and An… -
Backup Retention blocking Clone?I have a single Apex database on the free tier (about a gig in size) and I'm trying to make a clone. Based on all the documentation I've read, I should be allowed two fr…
-
Storage limit allocated x storage used.Hello. I am a user of the Autonomous Database with APEX for just over 1 year in the Always Free layer, and I realized that the allocated storage increases significantly …
-
Unable to clone a databaseSummary: I'm working with an autonomous database (Apex type) in the Free Tier. I only have one database and I'm trying to clone to a new DB for testing. On the clone pag…
-
How to access DBMS_CLOUD package on Autonomous DB free tier?Summary: I'm on Always free Autonomous DB. The DB version is 19c. However I cannot find / use the DBMS_CLOUD package Content (required): The DBMS_CLOUD package seems mis…
-
Unable to stop or restart free tier ATP databaseI am unable to restart an ATP database. The work request has the following error message: The Autonomous Database operation failed due to an unknown error. Refer to JobI…
-
Cannot login to Autonomous JSON database - Login page doesn't allow to press submitSummary: When trying to login to my AJD on my "Always Free" account, I'm not able to sign in. I am trying to login to access "All Database Actions", but not successful. …
-
How to solve this error of Oracle apex- 1403-no data found - rest data sourceSummary: Hi Experts, we are trying to upload file into OCI Object storage from Apex, so we created web credentials, rest data source and pages for uploading file. when u…
-
Continuous Autonomous Database Stopping Issue (Always Free Tier)Hello Oracle community, I'm facing an issue with my Autonomous Database using the Always Free tier. The database keeps stopping continuously, and I'm unable to restart i…
-
Is there any way to leverage Oracle Fusion Workflow for transactions from oracle ATP+APEX?We want to use Oracle BPM in Fusion Application to implement approvals for transactions in our ATP DB and APEX. And found a documentation about 'Implement Approvals for …