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.
Database
Discussion List
-
Enable AD Login to Base Database VMSummary: Hi, We are migrating our on prem database to OCI Base Database Service. One of the challenge is that Base Database Service Linux Machine login is allowed only v… -
NFS PermissionsHi Team, We are using OCI DBCS VM which is Base Database Service. We have a requirement to place application files daily in some location in DB server. But as per note i…
-
Back up post termination of Oracle FusionHi all, Please guide me in relation to obtaining data back up from Oracle Fusion once the license gets expired. Queries How to get back up for the accounting data from O…
-
Standby database creation while Migrating Primary Database using RMAN XTTS (Cross PlatformMigration)Summary: Is it feasible to concurrently build a standby database for the new target database while performing XTTS migration and activate Data Guard on OCI Content (requ…
-
DCS-10326:Failed to perform database upgrade prechecks for DBHi Team, During the database upgrade for OCI DBaaS (12c to 19c), we encountered a failure in the database upgrade job, as indicated by the error in the trace log file. U…
-
Scaling up CPU/memory & Storage - Oracle Base Database ServiceHi Experts, We are using OCI paas DBCS. We have a query. We have Database on VM version 19.22 ASM as storage later Single node. We have Intel X9 flexible shape. Do we ne…
-
ORA-20401: Authorization failed for URI using dbms_cloud access to object storageSummary: Getting authorization failed error connecting to the object storage from oci base 23 ai db. ORA-20401: Authorization failed for URI - https://objectstorage.us-c…
-
Unable to provision 2-Node DBCS using custom DNS domainSummary: Hello Team, I am facing an issue while trying to create a 2-Node DB system (DBCS) using an on-premise custom DNS. However, within the same subnet (configured wi…
-
Increasing space in Base Database Service - DBCSHi Team, We are using OCI DBCS VM which is Base Database Service. We have a requirement to place files daily in some location in DB server. But as per note id 2704132.1 …
-
DBCS - Base DBHi Team, Our DB version is 19.23 Multi-tenant having single CDB with single PDB. New DB system version will be 19.25. We have few queries and need your expertise answers…
-
Unifier API Line Item Number LimitationWe have an issue an issue we've encountered while updating/creating line items via API call. We attempted to update/create 4916 line items, but 16 were missed in the int… -
APEX - ORDS - OAuth - Client CredentialSummary APEX - ORDS - OAuth - Client CredentialContent Hi Experts, I have created DBaaS Instance and using the ORDS feature in Application Express. I can able to use GET… -
Storing application files in dbcs systemHello experts, We are using OCI DBCS VM which is Base Database Service. We have a requirement to place application files daily in some location in DB server. But as per …
-
403 Error when trying to create REST Data Source - Oracle Cloud Applications (Saas) REST ServiceSummary: Trying to get Fusion (SaaS) Invoice data into Apex by way of REST failing with 403 / Discovery error: Oracle APEX cannot compute a data profile from the respons…
-
Can we create a new 12.2.0.1 oracle base database service in existing tenancy ?Summary: My organisation already set up tenancy in OCI 3 years ago: in which we have created a 12.2.0.1 testing oracle base database service we are exploring whether we …
-
For OCI 2-node DBCS can we manually assign private IP address?Summary: For an Oracle cloud Infrastructure 2-node DBCS, is it possible to manually assign a private IP address during provisioning? Alternatively, is there an option to…
-
How to manage versions in Oracle APEX with Bitbucket within the Oracle ecosystem?Hello everyone, We use Bitbucket for version control. We want to implement an efficient strategy to manage version control in Oracle APEX. What is the best way to versio… -
Automating SQL script version control in SQL Developer, Visual Studio Code and BitbucketHi, we are currently looking for a way to integrate Oracle SQL Developer, Visual Studio Code and Bitbucket to automate version control of our SQL scripts. Our team works…
-
Data Safe/Data Discovery/Sensitive Data Model/Sensitive Data Creation is hanging at 65%As a pre-req for Data Masking, I am creating Sensitive Data Creation. It is hanging at 65% Content (please ensure you mask any confidential information): Version (includ…
-
I need to clone an SE2 PDB from OCI to on-premSummary: OCI requires that all tablespaces are TDE encrypted, even SE2 DBs. On-prem, you can't use TDE. Well, in fact, you can: all the ADMINISTER KEY MANAGEMENT command…
-
Not all data is in memory on an in memory tableSummary How to get 100% of content into an in memory tableContent I have a table WC_LEAVE_LIAB_F defined as In memory I believe it was 100% in memory as graphs were gene… -
Error: Internal Server Error apexWhile saving a request in the apex ui using form button getting internal server error I have configured a page with interactive grid where i have configured a col to as … -
ASM in Cloud at CustomerNew Cloud at Customer X10, we want to monitor the ASM created by Oracle and we do not have the password for "asmsnmp". Is it possible to change the "asmsnmp" password in…
-
How to find amount of space used up in cloudSummary: For audit purposes need to find the size of data stored on oracle cloud SaaS Content (please ensure you mask any confidential information): Version (include the…
-
apex_zip.add_file failed zipping 6.7 GB fileWe have plsql program using apex_zip.add_file utility to zip CSV file. It is working fine in production where the single CSV file size in 3.5 GB around. But it failed in…
-
How can I change an OTBI report deeplink to open the 'Holds and Approvals' tab?Summary: I have an OTBI report titled "All Invoices Details For Payment Approvals" where the invoice number column includes a deep link to the Fusion Test Invoice Detail… -
How to Connect Power BI Desktop to Oracle Fusion Cloud 24c FSCM databaseSummary: I would like to know the steps to Connect Power BI Desktop to Oracle Fusion Cloud 24c FSCM database. Content (please ensure you mask any confidential informatio… -
Inquire about increasing data storage in MySQL MDSSummary mysql,mdsContent HI When creating MDS, a MySQL service of Oracle Cloud The default data storage size is set to 50 GB. What if the data is full up to 50GB? Does i…
-
MySQL DB Systems HA - connect to secondary instances for backupSummary Would like to know if it is possible to run backups using the secundary instances of an HA MySQL DB System in OCIContent Hi! I've setup a HA MySQL Database Servi…
-
APEX Page URL Parameter vanishes when called from Oracle FusionSummary: When called APEX page URL along with parameters is called from third party, the URL parameters are not sent to the calling page. Content (please ensure you mask…