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
-
Production Live with Free Tier ATPSummary: Hi Team, Has anyone gone LIVE in production with Free Tier ATP. Do you see any challenge with that. Our data volume is less and 20 GB is enough. So just looking… -
All APEX Links given by App Builder, to start an App, are suddenly wrong (400 Bad request)Summary: Wrong URL generated from the App Builder in APEX. It adds the workspace name before the /r/ Content (required): Suddenly the link to run any of my developed app… -
Compilation error using PL/SQL Object Storage API in a program unitSummary: Setup: We are using an OCI ATP database and running APEX 22.2.1. The database user that owns the application objects has been granted the DWROLE. I can referenc…
-
Missing Oracle NoSQL Database Cloud ServiceI am trying to enable the Free Tier for Oracle NoSQL Database Cloud Service, but I am unable to find the 'always free configuration' option under reserved capacity as sh…
-
python-oracledb thin client returns DPY-6005Summary: Connection to ATP 21c and ADP 19c (free tier, both TLS enabled) using Python thin client fails with DPY-6005! Content: I'm trying to connect to a 21c ATP and 19…
-
How to dump data from one ATP database to other ATP databaseSummary: How to dump/Clone data from one ATP database to other ATP database Content (required): We have production ATP database and we want to clone/dump the data from A…
-
How to call a SOAP request in PLSQLSummary:Hello ,I have created a SOAP request which is working fine when I am using SOAP UI .But how to invoke the same SOAP request through PLSQL ?Can someone pls give s… -
Star TransformationIn a shared ADW instance, does the Star Transformation works? If yes, then how can we make sure that the same can be enable for the SELECT statements. Is it by setting v… -
Connecting to autonomous database using Jupyter oracledb, getting SSL: SSLV3_ALERT_HANDSHAKE_FAILURESummary: I am attempting to connect to my oracle cloud autonomous database using Jupyter notebook. I downloaded the wallet from Oracle Autonomous page. However, using or…
-
Cannot create table clusters on ADB shared infrastructureSummary: Cannot create table clusters on ADB shared infrastructure Content (required): Is it intended that u cannot assign tables to clusters on adb? Instead Oracle is c…
-
Cannot access Database Actions at Marseille RegionSummary: I get an error message when I press the "Database Actions" button The error message is: "Launch DB actions Failed to auto sign-in. Close this dialog and log-in …
-
Why does my database always free keep stopping every timeI was have new account on OCI, after my Free Tier accounts finished IN the database stop automatically ,and when I start it it's stop within 1 Minute again, and I can't …
-
ATP database - database actions, apex, sql commands screen all brokenI haven't used my FREE tier ATP database for a while and when I started it up again APEX, database actions and the SQL commands features were all broken and give an orac…
-
Connect Private ATP database to SQL Developer using Cloud WalletSummary: Connect Private ATP database to SQL Developer using Cloud Wallet Content (required): We have configured ATP database in a Private Subnet and RDP in a Public sub…
-
Unable to launch Data Transforms tool inside Database Actions of Oracle ADW after deploying ODI Web.Summary: Content (required): Hi team, After successful provision of Oracle Data Transforms instance, I am able to access the Data transforms from the web browser and aft…
-
Why does my ADB keep stopping?Summary: I am using an Always Free tier Autonomous Database with workload type Data Warehouse. It keeps stopping and every time I start it again it will stay up for 1-5 …
-
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… -
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…
-
Free accounts provided by OracleSummary: Is anyone aware if Oracle provides any free OCI accounts to help support applications which have been built to support Oracle's volunteer programs? We would onl… -
Inactive TenancySummary: Unable to create any VM or ATP due to inactive tenancy Content (required): Suddenly, I'm no longer able to create VMs or ATPs or any other thing. Checked the ac…User_2025-02-12-20-00-58-430 151 views 4 comments 0 points Most recent by User_2025-02-12-20-00-58-430
-
How to check memory component sizes (like SGA and PGA)Summary How to check memory component sizes (like SGA and PGA)Content Hi guys, In Autonomous databases, how can I check the memory component sizes (like SGA and PGA) bei…
-
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…
-
You do not get what they promiseContent Hi, Oracle offers 2 Always free 2 Autonomous Databases (Autonomous Data Warehouse or Autonomous Transaction Processing), each with 1 OCPU and 20 GB storage. But …
-
How to prettify Autonomous Database(ATP) event notification emailSummary: Hello , the default email we receive for ATP events are not well formatted including email header. Is there any option we have in OCI to customize email subject… -
NAVersion 18c
-
Invalid Package in SYS schemaSummary PACKAGE BODY DBMS_XSTREAM_GG_ADM in SYS SCHEMA IS INVALIDContent PLEASE COMPILE PACKAGE BODY SYS.DBMS_XSTREAM_GG_ADM in my ATP INSTANCE. My instance_name is : es…
-
How to enable supplemental logging on Autonomous ATP or ADW on Shared InfrastructureSummary: Per the latest documentation, it shows that Goldengate should be able to extract from ATP or ADW. In order for GoldenGate to do this we need to add supplemental…
-
ATP database failure to stop or restartSummary: ATP db does not stop or restart (work request failures). Can't access the DB from application or sqldeveloper. First time happening today, the 12th of June 2022…
-
Automatic Indexing enabled?Content https://cloudcustomerconnect.oracle.com/resources/ae46f0cd09/posts/create?type=6 According to the document, Automatic Indexing is enabled in ATP. By default does…
-
New Workshop - Learn About The Analytical Benefits Of A Converged Database For Your Data WarehouseContent We are pleased to announce a fantastic new workshop in Oracle LiveLabs Action! MovieStream Analytics Produces The Best Picture with Oracle Cloud MovieStream is a…