Autonomous Database
Discussion List
-
failed to connect to adbSummary: failed to connect to adb Content (required): Listener refused the connection with the following error: ORA-12529, TNS:connect request rejected based on current … -
Are there issues with Autonomous Database in Frankfurt region ?Summary: Since this afternoon (CET) the free tier instance in the Frankfurt region is having issues. Content (required): We're experiencing disconnections and slowness s…
-
ORA-30094: failed to find the time zone data file for version 36 in $ORACLE_HOME/oracore/zoneinfoSummary: Getting error while running select statement Content (required):ORA-30094: failed to find the time zone data file for version 36 in $ORACLE_HOME/oracore/zoneinf…
-
How do we install external python packages in OML4Py?Summary: Currently user installed packages are not supported in ADW OML4Py. This will be a very nice feature to have to take the advantage of large collection of open so…
-
Set ATP DB password not to expire.Summary: We need to set the ATP DB password not to expire and when we attempt it we do not have the correct privileges and its states we must be sys but we do not have t…
-
How do I create an object storage to be used during data importsSummary: I only have Database Actions but have no access on the storage so I can't upload my data export from my DBaas database. Content (required): Version (include the…
-
.dmp file is not getting generated after giving syntax suggested in oracle docs.Summary: I want to use data pump access driver to store the .dmp file in atp directory so that i can use it to send it to object cloud storage by using PUT. Content (req…
-
How to connect Autonomous Database from a OCI server which is inside the oracle n/w using sqlplus??Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
How to connect with Autonomous Database using Oracle Wallet from sql developer?Summary: Hi team, please help me in connecting to ADB using SQL developer. I am very new to ADB. Thanks, Vishnu Content (required): Version (include the version you are …
-
Would it be possible to restore APEX application of always free service once it was reclaimedSummary: My ATP DB is not getting listed . It would have been reclaimed because of inactivity. I would like to restore my APEX applications which were there. Content (re…
-
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 Lets You Export Data as JSON to Cloud Object StoreContent The DBMS_CLOUD package has been enhanced to allow exporting of data (by specifying a query) to a cloud object store as JSON. It supports all the Cloud Object Sto…
-
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…