To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Autonomous Database
Discussion List
-
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… -
Encountering an error of insufficient privileges when attempting to execute DBMS_CLOUD.COPY_DATASummary: I am encountering an error of insufficient privileges when attempting to execute DBMS_CLOUD.COPY_DATA in a PROCEDURE. Content (required): I'm working on creatin…
-
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… -
Autonomous Database Now Lets You Export Data as JSON to Cloud Object StoreContent The DBMS_CLOUD package has been enhanced to allow exporting of data (by specifying a query) to a cloud object store as JSON. It supports all the Cloud Object Sto… -
How to Export and Import a Table/Schema from one DB to other DB in the same tenancySummary: How to Export and Import a Table/Schema from one DB to other DB in the same tenancy Content (required): How to Export and Import a Table/Schema from one Autonom…
-
The Automatic Backups in Autonomous Database in OCI is of RMAN ?Summary: The Automatic Backups in Autonomous Database in OCI is of RMAN ? If yes, how to confirm it? I tried to check under V$RMAN_BACKUP_JOB_DETAILS table but didn't fi…
-
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…
-
Autonomous database is automatically stoppingSummary: Oracle autonomous database automatically stops with no apparent reason - it was not commanded to stop Content (required): Today I saw Oracle cloud database auto…
-
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 …
-
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…
-
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…
-
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…
-
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… -
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…
-
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… -
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…
-
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…