Category 245
Discussion List
-
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 … -
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…
-
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 Autonomous Database -
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…
-
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… -
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…
-
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…
-
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…
-
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:…
-
Getting 404 error when trying to access SQL Developer Web from Autonomous Database Service ConsoleContent Hi, I have been using an Autonomous ATP Database since the end of last year. I had connected to this database via SQL Developer Web from the service console as r…Michael Farren-257976 8 views 0 comments 0 points Most recent by Michael Farren-257976 Autonomous Database
-
Clone Apex SessionSummary I clone Apex Session in local Database 18c XE and work fine, but on the Cloud not Work.Content Hi, I need to clone the Apex session to the Oracle Cloud Free Tier…Roberto Antonio Párraga Zambrano 19 views 3 comments 0 points Most recent by Joel Kallman Autonomous Database -
Is it possible to use apex_web_service.make_rest_request in Oracle Apex in Oracle Cloud Always Free?Summary Trying to make an external call to a REST web service from Oracle Apex in Oracle cloud and getting ORA-20987Content I am making a REST request to an External API…
-
How can I setup and use loadjava utility without installing oracle database?Summary How can I setup and use loadjava utility without installing oracle database?Content Is there a way at all and if yes, then how to enable java code calling/execut…
-
Autonomous Data Guard Standby URL, IP Address, CertificateSummary Questions on what the Standby database looks like when using Autonomous Data GuardContent Hi I've been reading about Autonomous Data Guard and it looks like a ni…
-
ATP Object Deployments - Hub and Spoke configurationSummary Looking to have an ATP database (hub) control one or more other ATP or ADW databases (spokes) with regard to object deployments for things like views\MVs and pro…User_2025-02-08-03-47-01-847 15 views 2 comments 0 points Most recent by User_2025-02-08-03-47-01-847 Autonomous Database
-
GA ANNOUNCEMENT - Change ADB Mode to Read/Write or Read-OnlyContent It is now possible to select an Autonomous Database operation mode - the default mode is Read/Write. If you select Read-Only mode users can only run queries. In … -
How to delete a manual backup in ATP databaseSummary How to delete a manual backup in ATP databaseContent Hi, I have successfully configured an object storage to make it target for my autonomous database. My questi…User_2025-02-01-05-36-16-781 18 views 0 comments 0 points Most recent by User_2025-02-01-05-36-16-781 Autonomous Database
-
Unable to start the db after recoveryContent Hi guys, I tried to restore my ATP database in specific point of time, but it failed and reported the following error: The Autonomous Database operation failed d…User_2025-02-01-05-36-16-781 24 views 0 comments 0 points Most recent by User_2025-02-01-05-36-16-781 Autonomous Database
-
Oracle Cloud ATP database missing under ATP section in Oracle CloudSummary ATP database stopped for unknown reasons and unable to startContent when i tried accessing one of my APEX applications I developed on oracle cloud. I get this er…Toufiq Mohammed 80 views 8 comments 0 points Most recent by User_2025-02-10-23-56-29-308 Autonomous Database
-
A working example of UTL_HTTP.REQUEST, please!Summary Please provide with a complete example of UTL_HTTP.REQUEST, which works on ATPContent I am totally stuck with my inability to make an API call from PL/SQL runnin…
-
Oracle APEX is not updgraded to 20.1Summary Oracle APEX is not updgraded to 20.1Content Now, its been 45 days and my always free tier instance has not been upgraded to latest version 20.1 even after 45 day…
-
Free cloud trials link, does not workSummary I try to enter on the free cloud trials link and i get and error page does not existsContent I try to enter on the free cloud trials link and i get and error pag…Angel Flores T. 15 views 1 comment 0 points Most recent by Anilkumar Bhagavatula-Oracle Autonomous Database -
Unable to Login into Oracle APEX from my ATP DBSummary Unable to login into workspace in Oracle APEXContent I am unable to login into Oracle APEX after recent upgrade to 20.1. I get invalid credentials. I am able to …
-
APEX suddenly 404s with "The request could not be mapped to any database"Summary I have a free ATP instance and sudden neither the APEX nor the SQL Developer link workContent I have a free instance of Autonomous Transaction Processing. I have…User_2025-02-08-10-46-44-890 68 views 10 comments 1 point Most recent by User_2025-02-08-10-46-44-890 Autonomous Database
-
ORDS not working at Frankfurt siteSummary ORDS not working at Frankfurt siteContent Hi, have somebody an idea why ORDS / APEX isn't working at Frankfurt site? I get the error 404 when calling the URL of …User_2025-01-31-15-52-56-576 17 views 0 comments 0 points Most recent by User_2025-01-31-15-52-56-576 Autonomous Database