Autonomous Database
Discussion List
-
Session doesn't die with ALTER SYSTEM KILL SESSIONSummary: I'm trying to kill a session with ALTER SYSTEM KILL SESSION ','; as the Administrator user. When execute the ALTER SYSTEM KILL SESSION, I see: System KILL alter…
-
Cannot figure out Why the Update Statement is not working for PUT APISummary: I am using the Update Statement produced by dragging my table into the sql worksheet as described on page https://docs.oracle.com/en/database/oracle/sql-develop…
-
WARNING - Wallet Expiry Notification for Your Oracle Autonomous Database!Summary: I received an email as notification from OCI ADW team sharing the below message Content (required): Hello, You are receiving this email because you have clients…
-
APEX Update to 21.1 unsuccessfullSummary: Paid ATP Instance - APEX Update unsuccessfull Content (required): Yesterday i started the update to apex 21.1 manually. For a very short time in the administrat…
-
My Autonomous Database in tenancy located in the Jeddah cloud region become not availableSummary: Autonomous Database located in the Jeddah cloud region is not available, plz help me Content (required): Version (include the version you are using, if applicab…
-
How can we obtain the cluster info for an ATP DB running on shared Exadata InfraSummary: How can we obtain the cluster info for an ATP DB running on shared Exadata Infra? There is nothing in v$parameter. Any idea how we can get the info or who we ca…
-
Why do I keep getting a "Wallet Expiry Notification" warning message from the ADW?Summary: We have already downloaded the wallet twice for the DBSANFORDTEST instance and updated the password, we do not understand why we keep getting a warning message.…
-
ATP-S cross region backupSummary: Q: is it possible to create full backups for ATP-S on a different region? This is one of the compliance standards requirement for OCI Native services. Is this s…
-
autoscalingSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
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…
-
I am charged for Oracle Analytic; eventhough I did not use the service.Summary I am charged for Oracle Analytic; eventhough I did not use the service.Content I used Oracle Analytic during the rial period. Then I left the database down. Orac…
-
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…
-
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…
-
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…
-
Autonomous Database Now Supports SQL Tracing To Cloud Object StoreContent If you are an experience Oracle developer or DBA then you will know all about the benefits of using SQL tracing and how it can help identify the source of an exc…
-
ATP Always Free Storage Filling UpContent Hi, I am having the same Always Free ATP storage issues that have been mentioned numerous times on this forum - ie, the 20gb space filling up outside of any user…
-
Unable to connect to ATP database using SQL DeveloperSummary Network adapter could not establish the connectionContent Hi experts, Am facing issue while connecting to ATP database. * Connected to VPN using cisco client. * …
-
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 …
-
Issue on JSON data insertion in ATP tableContent Hi Experts, I am trying to insert JSON file data into ATP table through OIC JSON file is in Master child data form so I am inserting master data "PENN_DREQ_Parts…
-
OML Notebooks: "Application error. Please contact support."Summary "Application error. Please contact support." error received when attempting to open or create new notebooks in OMLContent When using Oracle machine learning note…
-
ORA-00018: maximum number of sessions exceededSummary Getting ORA-00018 when trying to connect to ADWContent Hi all, I was wondering if you could help/point me in the right direction. I have been getting the "ORA-00…
-
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…
-
Thanks and AppreciationContent Just writing this message to say Thank You and show my appreciation for the support received on this forum when I thought I had lost a vital DB (due to my oversi…