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
-
Exadata Fleet Update OCI CLI command to perform the Patching/Update at ExaC@CSummary: Need assistance for Exadata Fleet Update OCI CLI command to perform the Patching/Update at ExaC@C As we are planning to Intergrate the Exadata Fleet Update with… -
MySQL dbas giving too many cconnections errorWe have a node.js microservices based application running against MySQL DBAS service in OCI cloud. MySQlL version is 8.0.41 and we upgraded to this version 2 weeks ago. …
-
Creating DB system with Custom Grid Infrastructure ImageHi Team, We are trying to create a DB system using the custom Grid Infrastructure image: Navigate to DB Systems: From the navigation menu, select Oracle Database and the…
-
403 - Forbidden Post APIHi Team, We are using OCI load balancer. We have created 2 listeners, one for handling application users traffic and the other for API traffic. Created a rule set within…
-
ORDS - Bad gatewayHi Experts, we have installed ORDS(23.4) in server in private subnet and currently accessible with ipadress with http://172.******:8080/ords We have created OCI load bal…
-
need advice on switching off oci dev database outside working hoursSummary: have oracle database service on oracle OCI; need to save costs by installing automated process to shutdown database system outside weekday working hours and of …
-
DBCS restoreHi Experts, We have DBCS VM with 19.23 version. From OCI console, we are unable to initiate the restore, due to some html error. Can we do it manually from rman using be…
-
dataguardHi Team, We are using DBCS VM - Oracle Base Database Service. We are enabling datagaurd to the primary database from OCI console. We are getting failed to fetch error me…
-
TCPS Sql Developer and OCI Base database - unable to connect TCPSI just set the Oracle base database using TLS by following this article - Authenticate Oracle Database 23ai with Microsoft Entra ID and Brad's Blog: Entra ID Integration…
-
Unable to download wallet file of autonomous database in OCISummary: Created a new Autonomous database. Under Autonomouse Database > Database Connection, the Download Client Credentials > Download Wallet is disabled. Need this to…
-
How to enable ORDS service on a database hosted on private subnet of a VCN?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Question raised by mistakeQuestion raised by mistake — please remove
-
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… -
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…
-
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 …
-
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… -
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…
-
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…
-
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…
-
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…
-
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 …
-
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…
-
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 … -
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…
-
oracleasmlib package unable to downloadHello Experts, Able to download oracleasm-support package in Redhat Linux 9 platform, but oracleasmlib package was not able download. Checked below downloads portal, it …Sridhar Suresh-Oracle 182 views 1 comment 0 points Most recent by Shanmugam Vellore Thyagarajan-Oracle
-
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 do I configure DbVisualizer to connect to Oracle Fusion by URL?Summary: I am trying to install DBVisualizer to help analyze some SQL coding and need to configure the driver. Does anyone have experience in this and how to successfull… -
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… -
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…
-
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…