Transaction Processing
Discussion List
-
IO Error: Mismatch with the server cert DNHello, I am using Oracle Cloud Autonomous Database free tier Summary: When I try to connect using SqlDeveloper I get this error: An error was encountered performing the … -
ANNOUNCEMENT: February's newsletter covering all the latest new features in Autonomous DatabaseList of all the new features recently added to Autonomous Database (too many to list) in our regular "What's New" newsletter - https://blogs.oracle.com/datawarehousing/p…Keith Laker-Oracle 21 views 2 comments 0 points Most recent by Jayendra G-Oracle Autonomous Database -
Hi I am facing issue while passing rec array as input parameter in ORDS exposed package procedureSummary: I am facing an issue and not sure about doing it correctly I created a package and created a record type and CREATE OR REPLACE PACKAGE my_test_package AS TYPE t… -
Production Live with Free Tier ATPSummary: Hi Team, Has anyone gone LIVE in production with Free Tier ATP. Do you see any challenge with that. Our data volume is less and 20 GB is enough. So just looking… -
How to dump data from one ATP database to other ATP databaseSummary: How to dump/Clone data from one ATP database to other ATP database Content (required): We have production ATP database and we want to clone/dump the data from A…
-
Cannot SSH to instance & How to connect to the ATP from linuxContent Problem: I am getting error when I try to SSH to the instance from Mac computer. IP address and the user id that I am using were provided on the Instan…
-
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…
-
You do not get what they promiseContent Hi, Oracle offers 2 Always free 2 Autonomous Databases (Autonomous Data Warehouse or Autonomous Transaction Processing), each with 1 OCPU and 20 GB storage. But …
-
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…
-
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…
-
cloning a database is failing at 18%Summary Trying to create a autonomous database clone and is constantly stuck at 18% and then fails.Content I'm trying to create a clone of my autonomous database (via da…
-
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:…
-
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 …
-
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…
-
.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 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 …
-
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…User_GEUPH 12 views 2 comments 0 points Most recent by Kuljeet Singh - Oracle-Oracle Autonomous Database
-
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…
-
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…
-
Oracle Apex in Cloud ATP is unavailable. Says HTTP ERROR 503 Service UnavailableSummary HTTP ERROR 503 Service Unavailable error message is displayed whenever tried to connect to Oracle Apex Workspace LoginContent Hello, I have a free ATP account in…
-
Relocation of DB to different hardware, will IP address change?Summary: We received a notification saying our ATP-Shared DB (us-ashburn-1) will be relocated to different hardware on Sunday, Oct 3rd 2021, 00:00 - 04:00 UTC Content (r…
-
ERR-7620 Could not determine workspace for application ().Summary: Unable to save Apex page on my always free ATP Content (required): Hello Experts, Since this morning I am trying to save an Apex Page, every now and then I am g…
-
Unable to connect to ATP database using SQL DeveloperSummary Network adapter could not establish the connectionContent Hi experts, Am facing issue while connecting to ATP database. * Connected to VPN using cisco client. * …Shradhashree-Oracle 4 views 1 comment 0 points Most recent by Kuljeet Singh - Oracle-Oracle Autonomous Database
-
Always Free ATP Database stuck in starting for 24 hours (Phoenix West)Summary I tried to start the ATP database and it is saying starting for long timeContent All options under action are grayed out and the database is not starting any one…
-
Issue on JSON data insertion in ATP tableContent Hi Experts, I am trying to insert JSON file data into ATP table through OIC JSON file is in Master child data form so I am inserting master data "PENN_DREQ_Parts…
-
Unable to connect to ATP from Linux Compute NodeSummary Connectiong to ATP from Linux Compute Node-ORA-12162: TNS:net service name is incorrectly specified.Content Hello, When trying to connect to ATP using Linux Comp… -
I haven't developed any apps and my storage is already at almost 50% of the limitSummary Storage consumption grows daily even without any application developmentContent Hi, My 2 ATP databases grow daily I realized using SQL DEVELOPER that these are S…
-
ATP DB Cloud Storage Consumption IssueSummary ATP DB Cloud Storage Consumption IssueContent All, I have free trail Database with APEX application running for more than 3 months. But recently I have noticed D…
-
ORDS - 500 Internal Server Error when using Ressource limitsSummary Setting a Ressource Query time limit for "Low" and ORDS will stop working (500 Internal Server Error)Content Steps to reproduce (on free tier cloud) 1. Create an…