Category 245
Discussion List
-
My database keeps stoppingSummary: I am using Always Free tier Autonomous Database. It stops continuously. Content (required): I think that same question is below. I have the problem that my ADB …User_2025-03-07-06-14-47-860 131 views 23 comments 0 points Most recent by Sasa M. Autonomous Database -
My autonomous database won't start after period of inactivitySummary: The Autonomous Database operation failed due to an unknown error. Refer to JobId 292ca36f-bab7-40c5-9fa0-791e97599e24 and WorkRequestId f6156a76-cfa3-4c49-9ded-…
-
ORDS - Issue with OAUTH Implicit grant - Missing or Incorrect Client idSummary: An ORDS client has been created in an ATP database as following. When doing the 1st step of the schema sign-in/authentication get the 400 Bad request message On…
-
Connect to ATP Database from ExcelSummary: Want to connect to ATP Database from Excel Content (required): Hi, Found below note to connect to ATP DB from Excel, but we don't find option to download 'Add-i…
-
ATP in private subnet, how to allow access of APEX & ORDSSummary: Hi Team, We are planning to provision ATP for a client and private subnet, so it will have a private endpoint. so how to do access APEX, ORDS and database actio…
-
ORA-29003: SSL transport detected mismatched server certificateSummary: trying to connect autonomous db wihtout wallet and got error, any help ORA-29003: SSL transport detected mismatched server certificate Content (required): Versi…
-
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 …
-
I've hit an Apex bug with creating Interactive Grids after 23.1 upgradeSummary: After upgrading to Apex 23.1 I've hit a known APEX issue due to the trigger wwv_flow_ig_reports_t1 being disabled. Content (required): To enable progress this t…Martin Bocutt-Oracle 61 views 2 comments 0 points Most recent by Martin Bocutt-Oracle Autonomous Database
-
UPCOMING WEBCAST: Delivering successful Data Lakes with Autonomous Data WarehouseSummary: WEBCAST with live Q&A: Delivering successful Data Lakes with Autonomous Data Warehouse Date: Wednesday June 7 @ 11:00AM ET / 4:00 PM BST / 5:00 PM CET Registrat… -
WEBCAST - Delivering successful Data Lakes with Autonomous Data WarehouseSummary: WEBCAST with live Q&A: Delivering successful Data Lakes with Autonomous Data Warehouse Date: Wednesday June 7 @ 11:00AM ET / 4:00 PM BST / 5:00 PM CET Content (…
-
How to troubleshoot performance for Apex ApplicationSummary: Hi, We have an Apex application working perfectly on an instance. Now we created another standalone environment with Database 12.2 and Apex 21.1 installed. Appl…
-
How to backup autonomous databaseSummary: new to cloud, how to backup and manage autonomous database Content (required): Version (include the version you are using, if applicable): Code Snippet (add any…
-
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 85 views 2 comments 3 points Most recent by Jayendra G-Oracle Autonomous Database
-
Im having issue starting my database after it was inactivated when I was on holiday.Summary: Content (required): I am getting below error. Is it possible to recover this database, or do I have to work on new one? An unexpected error has occurred: Autono…Bartosz Kasprzak 61 views 6 comments 0 points Most recent by Satishbabu Gunukula Autonomous Database
-
Is it possible to use Oracle Database API for MongoDB to run rocket.chat?Summary: I am trying to connect RocketChat with Oracle-DB, but get error "MongoServerError: Invalid index specification: text index only support on wildcard" Content (re…
-
Using Custom RTF Template in Apex ReportingHi , We are trying to use custom RTF layout in Apex Reporting Queries , But getting the below report while using Native Printing option. If we need to use custom RTF lay… -
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… -
Issue while quering data in object storage using ADWSummary: Hi All, We have stored our parquet files in oracle object storage and have created logical entities in the Oracle data catalog using a file pattern. The data ca…SiddharthDang-Oracle 61 views 3 comments 0 points Most recent by Venkat Koduvayur-Oracle Autonomous Database -
Unable to access one of Oracle ADW's user apart from ADMINSummary: Content (required): Hi team, I am unable to access APEX or any Database Actions, using one of customized user's login credentials. It is displaying an error , s…Ankan Chanda 572 views 4 comments 0 points Most recent by Venkat Koduvayur-Oracle Autonomous Database
-
Failing when trying to create an Always Free Autonomous DatabaseSummary: I have logged into my OCI dashboard. I select to create an Autonomous Database. It fails. Content (required): Login to OCI Console From the menu, select Oracle …
-
Transparent Data EncryptionWe are trying to use Transparent Data Encryption for encrypting columns in Oracle ATP database. we have used the below query for creating a table with encrpted column, b…Narayanan V-Oracle 61 views 4 comments 0 points Most recent by Venkat Koduvayur-Oracle Autonomous Database -
Can DBMS_CLOUD.COPY_DATA function picks up all the columns from the target table automatically?Summary: Hi Team, I am trying to load a JSON zipped file placed in Object Storage to a ADW DB Table using the DBMS_CLOUD package. Below is the sample code - DECLARE tabl…Partha Kar-Oracle 105 views 2 comments 0 points Most recent by Partha Kar-Oracle Autonomous Database
-
APEX how to enable dev & instance admin auth via oracle identity cloud serviceSummary: Content (required): I'm running the apex instance on ADW. I can't figure the correct configuration for setting up developer and instance admin login via OICS. I…
-
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…
-
All APEX Links given by App Builder, to start an App, are suddenly wrong (400 Bad request)Summary: Wrong URL generated from the App Builder in APEX. It adds the workspace name before the /r/ Content (required): Suddenly the link to run any of my developed app…
-
Compilation error using PL/SQL Object Storage API in a program unitSummary: Setup: We are using an OCI ATP database and running APEX 22.2.1. The database user that owns the application objects has been granted the DWROLE. I can referenc…
-
Missing Oracle NoSQL Database Cloud ServiceI am trying to enable the Free Tier for Oracle NoSQL Database Cloud Service, but I am unable to find the 'always free configuration' option under reserved capacity as sh…
-
python-oracledb thin client returns DPY-6005Summary: Connection to ATP 21c and ADP 19c (free tier, both TLS enabled) using Python thin client fails with DPY-6005! Content: I'm trying to connect to a 21c ATP and 19…
-
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…
-
How to call a SOAP request in PLSQLSummary:Hello ,I have created a SOAP request which is working fine when I am using SOAP UI .But how to invoke the same SOAP request through PLSQL ?Can someone pls give s…