Category 245-2
Discussion List
-
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…
-
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 81 views 2 comments 3 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…User_2025-02-11-09-34-58-280 138 views 8 comments 0 points Most recent by Sanchit Rastogi Autonomous Database -
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…User_2025-02-12-21-26-29-663 396 views 4 comments 0 points Most recent by Masiuddin Ahmed-Oracle Autonomous Database
-
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…
-
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
-
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 215 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 26 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…