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
-
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…
-
503 Service Unavailable - ATP Keeps shutting downContent 503 Service Unavailable - ATP Keeps shutting down503 Service Unavailable - ATP Keeps shutting down Have restarted atleast 10 times and it keeps shutting down. Ea…
-
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…
-
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…
-
503 Service Unavailable: Cant access my Oracle Cloud ATP databaseSummary Cant find my Oracle Cloud ATP databaseContent Hi Everyone. I have been using the ATP database free-tier and I suddenly couldn't access it on 16-Apr-2021 around 1…
-
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
-
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 …
-
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… -
ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilegeSummary Trying to access my ADW today but getting ORA-01035 when trying to connect as any user other than ADMINContent Hi, I hope you can help. When I try and log into m…
-
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… -
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 connect Oracle ADW with JDBC url in data management using EPM Agent?Content Hi Team, We had the data and metadata integration with DBCS (Database cloud services) using EPM Agent. But, now we have opt for Oracle ADW (Oracle Autonomous Dat… -
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…
-
Accessing ADW without using APEX or SQL Dev tool to create REST APIsContent Hi team, Can we access Oracle ADW through some other tools and by not using its own components like Oracle APEX or Oracle SQL Web Developer tool to make REST API…
-
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:…
-
How install Sample Schemas?Summary Old instructions for installing Sample Schemas don't apply to ATPContent Can the Sample Schemas be installed on an ATP database? The documentation shows a proces… -
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…
-
Oracle DataSafe Product Enhancement IdeasSummary Oracle DataSafe Product Enhancement IdeasContent Hi Team, We have been using Oracle DataSafe on ADW for sometime now. We use Data Masking functionality extensive…User_2025-02-10-16-52-46-302 25 views 2 comments 0 points Most recent by User_2025-02-10-16-52-46-302
-
SM/ADVISOR Occupies almost all Storage on Always Free ATP DBContent I have created a free tier ATP database some time ago. Recently, I note that almost all space (out of the 20GB available) were occupied by Oracle automated jobs,…
-
ORA-01652 on Shared ATP - is there an upper limit on TEMP tablespace allocation?Summary Curious what the upper limit is (if known)Content Update - will move to an internal forum - my apologies. We are technically a cloud customer (albeit internal) a…
-
To extract hostname, port name, service name from Oracle Autonomous Data WarehouseContent How can we extract hostname, portname , service name of Oracle ADW cloud as we are trying to connect a database using Python scripts and the Python script is dem…
-
to integrate MS SQL Server dB with ADWContent Can we integrate SQL Server dB with Oracle ADW using Oracle Application Integration where operations like POST,GET,PUT can take place between ADW and SQL Server …
-
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…
-
To generate each rows with unique IDs (primary key) in ascending orderContent I am inserting values inside ADW in Oracle Apex through REST API parameters. I am able to get unique values but the order is getting random after inserting two r…