Category 245
Discussion List
-
Cannot create Data Share on Autonomous Data WarehouseSummary: I am trying to create a Data Share in ADW but when I try to select the Cloud Location the dropdown list button does not work. I tried creating different Cloud S…User_2025-03-10-20-05-25-201 33 views 2 comments 1 point Most recent by RMJ-kpmg Autonomous Database -
I can't find my database and apex applications anymore. How can I recover Cloud error?Summary: I search for my database in my tenant but I get an error from the cloud. Content (required): After login I try to click to open my database on cloud from cloud …
-
How export schema tables if DB has an APEX workload type?Summary: If DB has an APEX workload type datapump can't be used. Content (required): I read several documents about datapump that is the main way to export data from a s…
-
How can I prevent or further debug this ORA-00600?Summary: ORA-00600: internal error code, arguments: [cvwtynmBasic1], [cannot find datatype entry in internal table], [252], [], [], [], [], [], [], [], [], [] Content (r…
-
ADB Excel add-in : Installer issueSummary: I am facing issues with installing the Autonomous Database Excel add-in on my Windows machine. As you can see in the attached screenshot, the install.cmd when r…
-
ADB URL for Oracle Autonomous Database Excel add-inSummary: Please can someone provide steps on how to get the specific ADB URL from the admin console. A video of the entire connection setup process with an example would…
-
Query on data storage/performanceSummary: Due to excess data (5M records) causing performance issues and a heavy load on the application, we have decided to migrate the aged data to the Oracle database.…
-
Is it possible to get Autonomous DB to automatically switch to Daylight Saving Time (such as BST)?Summary: Is it possible to get Autonomous DB to automatically switch to Daylight Saving Time (such as BST)? Content (required): Is it possible to get Autonomous DB to au…
-
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… -
Getting Create session priveledge error through sql developerSummary: Getting Create session priveledge error through SQL developer Content (required): Hi All, I have Provisioned an ATP db. instance and when i tried to connect to …
-
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…
-
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…Srikanth Muramreddy-Oracle 52 views 6 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
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…Srikanth Muramreddy-Oracle 21 views 1 comment 0 points Most recent by Masiuddin Ahmed-Oracle Autonomous Database
-
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 …User_2025-03-07-06-14-47-860 132 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 64 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 81 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 62 views 6 comments 0 points Most recent by Satishbabu Gunukula Autonomous Database