DBaaS
Discussion List
-
19c Database Patching with Primary/DR Data Guard Environment - DBCSHi Team, We Request for Oracle Guidance on 19c Database Patching with Primary/DR Data Guard Environment We are using Oracle Database 19c in OCI Base Database Service. Ou… -
Query performanceHi Team, We are currently investigating CPU spike issues and have reviewed the AWR report. Based on the report, the attached graph is ordered by CPU Time, and we would a…
-
Performance issueHi Team, Hi Team, We are using oracle database 19.17 version. We identified performance issue with attached query, consuming 100% CPU. At the same time we have seen mult…
-
Query ending with spilling huge temp spaceHi Team, We have a procedure running in DEV instance that is failing within 5 minutes with the error: "Unable to extend temp space", despite having 20 GB of TEMP space a…
-
Upgrade from 19.28 to 26aiHi Team, We are currently evaluating an upgrade of our Oracle Database environment from Oracle Database 19c to Oracle Database 26ai. Our team has experience administerin…
-
Memory Interpretation Graph - DB SystemHi Team, Does the OCI DB System "Memory Utilization" metric represent total host memory consumption including Oracle SGA, PGA, Oracle processes, OS cache, and other oper…
-
Metrics in DB system for CDB instance - OCI consoleHi Team, Current Logons,Parse count (total),Block Changes,Execute Count shown in DB system for CDB instance ---> Are these aggregated across the entire instance, which i…
-
Enable Diagnostics & ManagementHi Team, We are using oci base database service 19c version. We are trying to set basic database management for our base DB, Enable Diagnostics & Management. We are usin…
-
Database Management for OCI Base Database ServiceHi Team, Could you please confirm whether Database Management for OCI Base Database Service is a free feature? Specifically, we are planning to use Database Monitoring M…
-
Availability of 19.30 Database RU in OCI (DBCS/ExaCS)Summary: Hello Team, The JAN 2026 RU is released on MOS, however it is not yet visible in the OCI Console for our DB system or EXACS . Could you please confirm when it w…Kondala Rao-Oracle 437 views 11 comments 2 points Most recent by Smarajit Samantaray-Oracle Database -
How can I determine my total database size?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… -
Best database option in oracle cloud i.e. optimal in cost? Executed via Oracle Integration CloudSummary: I would like to know what is best database option we have in oracle cloud that is optimal in cost? Content (please ensure you mask any confidential information)…
-
storage quota exceededHi Team, We are placing file from onpremise server to oci server using oci cli, but we are getting "StorageQuotaExceeded". We have 1 TB procured initially for object sto…
-
Index - Performance queryHi Team, We are using Oracle Database 19.28 version. We need your support in fixing the below SQL query appeared in SQL ordered by Elapsed Time in AWR report. CPU consum…
-
DBMS_CLOUD_AI_AGENTSummary: we are at 23.26 DB version OCI DBaaS Content (please ensure you mask any confidential information): How do we install DBMS_CLOUD_AI_AGENT? We have tried: 274836…
-
conversion error loading table due to character set mismatchexported(using expdp) schema from oracle database that uses charset WE8MSWIN1252, and while import huge schema which has 1.5TB using impdp to Target where character set …
-
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…
-
Oracle Database AIHi Team, We are planning to upgrade DBCS Oracle Base Database Service from19c to 23. Please kindly share with us about which version of 23 have AI features. Thanks, Sati…
-
dbbackup (sku B91628) on my bill even though I have terminated the databaseSummary I am being billed for a database backup in object storage even though I terminated the database, and I can neither see nor delete this from the OCI consoleConten… -
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…
-
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…
-
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…
-
Procedure to rollback applied OS patches in DBCS/DB systemSummary: Hello Team, We have a 19.25.0.0 Version DB system/DBCS. We have applied OS patches through DBCLI using below command : dbcli get-availableospatches dbcli update…
-
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. …
-
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…
-
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…
-
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…
-
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…
-
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…