Transaction Processing
Discussion List
-
Space Usage in container is too high on ATP DBSummary: Hi, I'm having an issue with my (Always Free) Autonomous Data (Transaction Processing workload type) where for some reason it thinks that it is full but I haven… -
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…
-
ATP auto indexing consumes more than 16GB in SYSAUXDear valued Oracle DBA community, after enabling Oracle Autonomous auto indexing feature some months ago for testing purposes, I recently realized that since this time S…
-
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 Instance Detail …User_H95GN 103 views 7 comments 1 point Most recent by Kuljeet Singh - Oracle-Oracle Autonomous Database
-
Cannot create Autonomous DB (ATP)Summary: I am trying to create a Autonomous DB as a part of the course. However, when I'm trying to create it, its not letting me create. The create button doesn't do an…
-
Unable to write file on OCI bucket with Header row from DBMS_CLOUD.EXPORT_DATASummary: Hi, I am writing a file from ATP (table) to the bucket in the OCI object storage it's working fine but the header row is not inserted. Please help to export the… -
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…
-
Authorization failed while exporting to Object storage from ATPSummary: Hi I am getting authorize failed error while exporting data from ATP to bucket using dbsm_cloud.export_data package. ORA-20401: Authorization failed for URI - h…
-
Advantage of ORDS service call in vbcs and cons of OIC call in vbcsHi experts advantage of ORDS api over OIC calls in vbcs . suppose ORDS being called in OIC for VBCS services what is the disadvantage its better approach or not? what is…
-
503 service unavailable errors after creating ATPSummary After creating a new ATP, I try and go to SqlDeveloper for Web or Apex I get a 593 service unavailable error.Content This is the error details after I have creat…
-
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 61 views 2 comments 2 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…
-
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…
-
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 …
-
.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 92 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…