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
-
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… -
How to Handle Redo Gaps/Apply Lag and Standby Backups in DBCS Data GuardHi Team, We have an Oracle Database Cloud Service (DBCS) environment with Data Guard configured between the primary and standby databases. In our previous on-premises en…
-
Java Memory Consumption and Server UnresponsivenessHi team, We have an OCI Compute instance running the OIC Connectivity Agent as a Java process, with an initial heap allocation of 2 GB. Recently, the server became unres…
-
Backup LogsHi Team, On the legacy system, We have taken an RMAN Level 0 backup using a TAG. The backup completed successfully, and LIST BACKUP SUMMARY TAG '' displays the backup pi…
-
tags- oci resource schedulerHi Team, Need your guidance on resource scheduler to stop and start the specific instance. We are not choosing static option: We have 3 instances shown here. However we …
-
Transferring Backups to Object storageHi Team, If we need to onboard a legacy database with backups size approximately 500 GB that must be transferred and made available for restore in OCI, please let us kno…
-
Onboarding new account PaaSHi Team, We are planning to onboard a new account supporting Oracle Fusion. As part of that,we will also have a paas environment. It will have dev,uat environment and on…
-
Debug large proc/packageHi Team, We recently faced an issue after migrating an APEX application from DEV to UAT. The APEX page was not working as expected, and finally we found that the issue w…
-
Code migration scripts - oracle paasHi Team, we have recently procured a Fusion SaaS environment along with a small PaaS environment where we are hosting Oracle Database, APEX, and ORDS. For our developmen…
-
Object strorage file managementHi team, We are migrating our application files away from a legacy architecture to OCI Object Storage. Our Previous Setup: Previously, our application files lived on a s…
-
OCI Generative AI - Guidance requiredHi Team, We would like to perform a Proof of Concept (POC) using Oracle Select AI. For testing purposes, it appears that we require access to an LLM (Large Language Mode…
-
Guudance on budgets in ociHi team, I can see the Budgets option in the OCI Console. Could you please explain what it is used for? Could you also provide some practical examples of how budgets can…
-
Object Storage Migration Progress - Files Uploaded for VerificationHi Masi, Thanks for the options suggested in (https://community.oracle.com/customerconnect/discussion/comment/1702235). While performing the migration activity, we recei…
-
Security and Architecture GuidanceHi Team, We have an on-premises application currently deployed with the following architecture: One public IP address is NATed to an HAProxy server. HAProxy routes traff…
-
Analysis of DB-to-Disk File Discrepancy Prior to Object Storage MigrationHi Masi, We have refreshed the required data and files from PROD to TEST environment. We are currently migrating existing files from local storage to Object Storage. As …
-
Practical Use Cases of Oracle AI for SQL Optimization and TuningHi Team, I would like to understand the practical application of AI in Oracle Database performance tuning and SQL optimization. Traditionally, Oracle Database has provid…
-
Security - Small OCI environmentsHi Team, We are evaluating whether security best practices in our environment and would appreciate your guidance on its practical benefits, use cases, and cost implicati…
-
Apex uploads Migration from local storage to Object StorageHi Team, Due to the limited storage available on the DBCS /u01 filesystem, we are proceeding with DBMS_CLOUD as the immediate solution to move the application files to O…
-
Oracle Database 26ai - How to Demonstrate Select AI (POC)?Hi Team, We have a test environment running Oracle Database 26ai and would like to build a simple Proof of Concept (POC) to demonstrate Oracle Select AI capabilities to …
-
rsync - copying files from prod to uatHi Team, We are choosing option 1 as suggested in https://community.oracle.com/customerconnect/discussion/comment/1699182#Comment_1699182 Option 1: Full directory synchr…
-
debugging plsql/sql statementsHi Team, We generated an ASH report attached for a performance issue and identified two PL/SQL blocks/packages. However, we are unable to determine the actual SQL statem…
-
Autostop of oci compute instanceHi Team, When we click on create schedule,it throws away below error, can you please guide us what was the reason for this error. Thanks, SGU
-
performance issue with reportHi Team, We have report generation from apex calling bipublisher which is there in onpremise environment connected through site to site vpn. We have verified the sesssio…
-
Security oci computeHi Team, We have a PaaS environment supporting our Fusion environments, consisting of two compute servers and two dbcs base db database servers, with separate servers fo…
-
Upgrade 26aiHi Team, We are currently evaluating an upgrade from Oracle Database 19c to Oracle AI Database 26ai. From a DBA perspective, I would like to understand the AI-related ca…
-
Upgrade OCI Base Database Service from 19.28 to Oracle AI Database 26aiHi All, We are currently managing OCI Base Database Service environments running Oracle Database 19.28 with CDB/PDB architecture. As part of an AI initiative, we are pla…
-
Upgrading specific pdb - OCI console basedbHi Team, Please help us understand the upgrade of specific PDB in CDB. In one of our environment, we have CDB with 2 PDB(test & uat). Looks like there is no option to up…
-
Oracle DashboardsHi Team, Oracle databases hosted in OCI, many of these capabilities are already available through native OCI services and dashboards, including: Database availability an…
-
Testing file upload to OCI Object StorageHi Team, We have an APEX application hosted on a Base Database Service (DBCS). Currently, user-uploaded files from apex are stored on the DBCS server under the /u01 file…
-
Network Stats for BaseDBHi Team, We are able to view NetworkBytesIn and NetworkBytesOut metrics for Compute instances through Metrics Explorer to monitor network traffic. However, we could not …