Category 245
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… -
Automatic Indexing enabled?Content https://cloudcustomerconnect.oracle.com/resources/ae46f0cd09/posts/create?type=6 According to the document, Automatic Indexing is enabled in ATP. By default does…
-
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…
-
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…Jorge Andres Gonzalez Uribe 35 views 0 comments 0 points Started by Jorge Andres Gonzalez Uribe Autonomous Database
-
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 …
-
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… -
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) …Cijo M Jose-Oracle 33 views 4 comments 0 points Most recent by Cijo M Jose-Oracle Autonomous Database
-
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…User9152064-Oracle 1.6K views 1 comment 0 points Most recent by Kuljeet Singh - Oracle-Oracle Autonomous Database
-
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…
-
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):Bheeshma 11 views 2 comments 0 points Most recent by Kuljeet Singh - Oracle-Oracle Autonomous Database
-
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…User_303W0 11 views 1 comment 0 points Most recent by Kuljeet Singh - Oracle-Oracle Autonomous Database
-
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…Venkat Koduvayur-Oracle 79 views 3 comments 0 points Most recent by Venkat Koduvayur-Oracle Autonomous Database
-
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…Frank Sorich-Oracle 438 views 2 comments 0 points Most recent by Frank Sorich-Oracle Autonomous Database
-
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…User_GISZA 25 views 3 comments 0 points Most recent by Kuljeet Singh - Oracle-Oracle Autonomous Database
-
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):User_I67Q7 12 views 1 comment 0 points Most recent by Kuljeet Singh - Oracle-Oracle Autonomous Database
-
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…
-
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…