Category 245
Discussion List
-
Receiving 500 Internal Server Error after passing one row of values through a POST APISummary: Content (required): Hi team, I have been receiving a 500 internal server error after passing a row of values through a POST REST API (through POSTMAN) in Oracle… -
Oracle Apex in Cloud ATP is unavailable. Says HTTP ERROR 503 Service UnavailableSummary HTTP ERROR 503 Service Unavailable error message is displayed whenever tried to connect to Oracle Apex Workspace LoginContent Hello, I have a free ATP account in…
-
Relocation of DB to different hardware, will IP address change?Summary: We received a notification saying our ATP-Shared DB (us-ashburn-1) will be relocated to different hardware on Sunday, Oct 3rd 2021, 00:00 - 04:00 UTC Content (r…
-
Is OLAP available on Oracle ADW?Exploring a migration from SQL Server to ADW and need to know if OLAP or similar functionality is available Content (required): Hello, We're exploring a migration from S…Brian Watkins-Oracle 131 views 4 comments 0 points Most recent by Bud Endress - Oracle-Oracle Autonomous Database
-
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…Keith Laker-Oracle 23 views 2 comments 0 points Most recent by Nick_CloudEngineer-Oracle Autonomous Database -
How do we form a connection between PowerApps and ADW?Summary: We are receiving TNS connection errors when forming a connection to ADW Content (required): We have a requirement to create a connection between Azure PowerApps… -
ERR-7620 Could not determine workspace for application ().Summary: Unable to save Apex page on my always free ATP Content (required): Hello Experts, Since this morning I am trying to save an Apex Page, every now and then I am g…
-
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…
-
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 …
-
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 …
-
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…
-
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 9 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…