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
-
One of my autonomous DB is not listed in the OCISummary: Content (required): I had an 'Always free' autonomous DB (ocid1.autonomousdatabase.oc1.ap-seoul-1.anuwgljrvqohgdyaod27ibh52gzviktqeaaghwl5eq3ywh4757sk7p57xfja) … -
apex_web_service.make_rest_request always gives error insufficient privilegesSummary: I am trying to set up a small API with my home automation and the Oracle cloud. To do this, I want to send an HTTP request from the autonomous data warehouse to…
-
Connect Microsoft Excel to an ADW databaseSummary: Do we have option to connect excel to an ADW database? Content (required): Ability to connect Microsoft Excel to ADW Database Version (include the version you a… -
Bug? Apex service: page event metrics in OCI look inaccurateSummary: so i load tested my apex app today. The test ran from 20:55 UTC to 21:06 UTC. I don't understand the graphs below from OCI.. how can APEX Page Events continue t…
-
Does ATP on shared infrastructure support shared server architecture?Summary: Content (required): ATP on dedicated infrastructure supports shared server infrastructure. Check https://docs.oracle.com/en/cloud/paas/autonomous-database/adbcc…
-
How do I deal with an ORA-01924 error on my Oracle Autonomous DB?Summary: Error starting at line : 10 in command - GRANT "DBA" TO "ADBSNMP" Error report - ORA-01924: role 'DBA' not granted or does not exist 01924. 00000 - "role '%s' n…
-
Why do my ATP instances sometimes go from "provisioning" to "unavailable"?Summary: We've been using the OCI DatabaseClient Python API to call create_autonomous_database. This works very well, but occasionally a newly created ATP's lifecycle_st…
-
Need JDBC thin connection string to connect to my autonomous databaseSummary: HI Team, In our UGBU we will apply blue prints to our database using JDBC:thin connection string, Example : java com.oracle.ouaf.oem.install.OraDBI -d jdbc:orac…
-
Do I need to update Wallet after service disruption?Summary: Oracle Cloud Toronto area has been disrupted for more than 24hr. My application still cannot connect to Oracle DB even https://ocistatus.oraclecloud.com/ says A…
-
Hi I am facing issue while fetching ORDS records limit more than 1000Summary: Hi , I am trying to fetch all tables records from ATP database using ORDS service but I am only getting 1000 records after setting ?limit=1001&offset=25 when I … -
InstantClient ODBC throws "Oracle Cloud: ORA-00018 maximum number of sessions exceeded" in ExcelContent (required): I have a Always-Free instance of Oralce Autonomous Database. I've installed Oralce InstantClient ODBC. I have been using Excel to connect to Oracle D…
-
Any one enabled auditing on select on a specific table? How to enable it? Where to find the results?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
Steps to implement VPD for controlling data access in a BI report.Summary: VPD for controlling data access in BI report. Content (required): Is anyone aware of any guidance notes on how to implement VPD for BI reporting. I came across … -
How to parse json array of strings.Summary: I've been working JSON tables and querying them. I've just run across a data structure that I cannot figure out how to parse. Content (required): The json array… -
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…
-
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.…