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
-
Generating AWR Report for ADB(always-free)Summary Could you tell me how to generate AWR Report for ADB(always-free)?Content https://docs.oracle.com/en/cloud/paas/management-cloud/mcdbm/generate-awr-reports-diagn… -
hang on drop indexSummary never end the drop commandContent I have on the database this index SQL> select index_name from user_indexes; INDEX_NAME ----------------------------------------…
-
Migrate data from Oracle DB 11.2.0.1 to ADWSummary: How migrate data from Oracle DB 11.2.0.1 to ADW Content (required): Hi, How can migrate data from Oracle DB 11.2.0.1 to ADW in the simplest way? I try with db-l…
-
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 973 views 4 comments 0 points Most recent by User_2025-02-12-22-05-31-355 -
APEX version upgrade (22.1.1)Summary: Oracle APEX version upgrade (22.1.1) was not performed on the planned date - OCI APEX as a Service Content (required): Hi, I received an email informing me of t…
-
Oracle Autonomous Database - check used storage spaceSummary: Content (required): Hello. I recently noticed that my Autonomous Database is running out of free storage space. This is strange since I store a small amount of …
-
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:…
-
Oracle APEX 22.1 - ATP Customer managed ORDSSummary: Is there a way to determine whether or not an ATP is running Oracle ORDS OR customer manager ORDS? Our fleet is rather large and looking to determine the impact… -
Missing Information in OCI ATP Event AlertSummary: User Information is missing in ATP event alerts when a new wallet is generated Content (required): Hello , I have enabled event to trigger a notification when s… -
how to enable supplemental logging?Content how do I enable supplemental logging in an Oracle Cloud database (ATP)? ALTER DATABASE ADD SUPPLEMENTAL LOG DATA; ORA-01031: insufficient privileges 01031. 00000…
-
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…