Category 245
Discussion List
-
Connect Private ATP database to SQL Developer using Cloud WalletSummary: Connect Private ATP database to SQL Developer using Cloud Wallet Content (required): We have configured ATP database in a Private Subnet and RDP in a Public sub…MadhuMullangi 131 views 2 comments 0 points Most recent by Kuljeet Singh - Oracle-Oracle Autonomous Database -
Unable to launch Data Transforms tool inside Database Actions of Oracle ADW after deploying ODI Web.Summary: Content (required): Hi team, After successful provision of Oracle Data Transforms instance, I am able to access the Data transforms from the web browser and aft…
-
Why does my ADB keep stopping?Summary: I am using an Always Free tier Autonomous Database with workload type Data Warehouse. It keeps stopping and every time I start it again it will stay up for 1-5 …
-
503 Service Unavailable - ATP Keeps shutting downContent 503 Service Unavailable - ATP Keeps shutting down503 Service Unavailable - ATP Keeps shutting down Have restarted atleast 10 times and it keeps shutting down. Ea…User_2025-02-11-09-37-17-226 37 views 3 comments 0 points Most recent by Sanchit Rastogi Autonomous Database -
503 Service Unavailable: Cant access my Oracle Cloud ATP databaseSummary Cant find my Oracle Cloud ATP databaseContent Hi Everyone. I have been using the ATP database free-tier and I suddenly couldn't access it on 16-Apr-2021 around 1…User_2025-02-11-09-34-58-280 135 views 8 comments 0 points Most recent by Sanchit Rastogi Autonomous Database
-
Free accounts provided by OracleSummary: Is anyone aware if Oracle provides any free OCI accounts to help support applications which have been built to support Oracle's volunteer programs? We would onl…Amrita Gupta-Oracle 31 views 2 comments 0 points Most recent by Amrita Gupta-Oracle Autonomous Database -
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 151 views 4 comments 0 points Most recent by User_2025-02-12-20-00-58-430 Autonomous Database
-
How to prettify Autonomous Database(ATP) event notification emailSummary: Hello , the default email we receive for ATP events are not well formatted including email header. Is there any option we have in OCI to customize email subject… -
NAVersion 18c
-
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…User_2025-02-12-21-26-29-663 402 views 4 comments 0 points Most recent by Masiuddin Ahmed-Oracle Autonomous Database
-
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…User_2025-02-12-22-05-31-355 984 views 4 comments 0 points Most recent by User_2025-02-12-22-05-31-355 Autonomous Database
-
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…User_2025-02-12-05-56-53-681 31 views 0 comments 0 points Started by User_2025-02-12-05-56-53-681 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 31 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 2.8K 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 21 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…