Autonomous Database
Discussion List
-
ORA-01031: insufficient privileges when attempting to SFTP to OIC File serverSummary: Unable to FTP to OIC SFTP server from ATP Database Content (required): I am trying to connect to the OIC SFTP Server from ATP databse, something like below. But… -
How do I get around the ORA-30094 error in Autonomous Database?Summary: Receiving ORA-30094 error when building OML Model on Autonomous Database Content (required): Trying to begin using OML4SQL but when following the example below,… -
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…
-
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 …
-
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…
-
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…
-
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…