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
-
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… -
Launch APEX button results in 400 Bad Request Error on newly provisioned Autonomous DatabaseSummary: Can't launch APEX on a newly created Autonomous Database on OCI Free Tier. Content (required): I am following the tutorial here: https://docs.oracle.com/en/lear…User_2025-02-12-22-05-31-355 933 views 4 comments 0 points Most recent by User_2025-02-12-22-05-31-355
-
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) … -
Creation of ATP database failsSummary: Creation of database fails Content (required): Trying to create an ATP database in Oracle Cloud FREE. Fails each time, have tried 3 times. Same error each time:…
-
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 …
-
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…
-
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… -
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 152 views 4 comments 0 points Most recent by User_2025-02-12-20-00-58-430
-
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…
-
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…
-
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…
-
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 … -
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…
-
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… -
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…
-
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…
-
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 …
-
.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…
-
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…
-
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…