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
-
Last Chance to Register: Innovate with AI Built Into Your Database - Everywhere. (April 8, 2026)Lead the change with the only database that natively architects AI into your data everywhere. AI promises faster insights, better decisions, and higher productivity, but… -
Ever faced the Oracle ORA-00942 error InfoEver faced the Oracle ORA-00942 error even when the table exists? It’s worth checking the current schema, table name, and user permissions before making changes. What do… -
ORDS sizingHi Team, We are planning to onboard a new custom application to our existing ORDS environment and need guidance on capacity planning and sizing. Current Architecture OCI…
-
PROD Migration - Steps ReviewDear Masi, We are starting the PROD migration today to move files from /u01 on DBCS to Object Storage. Thank you for your support and assistance throughout the migration…
-
custom application migrationHi Team, We have one custom onpremise HRMS application in postgresql DB. Now we are planning to migrate it to oracle DB and develop it in Apex. Regarding the infrastruct…
-
OIC agent errorsHi Team, Environment: Oracle Integration Cloud (OIC) Connectivity Agent running on Linux. We are occasionally seeing heap memory errors in the Oracle Integration Cloud (…
-
Monitoring, Alerting for OCI WAF and Load BalancerHi Team, Recently, we came across a security incident in an on-premises environment where the infrastructure team reviewed the firewall logs and reported that the firewa…
-
Guidance Required: Configuring OCI WAF Security Alerts for SQL Injection, XSS, and Suspicious IP ActHi Team, We are implementing security monitoring for the first time in our OCI environment and would appreciate your guidance on configuring security alerts and email no…
-
OCI failed login - serverHi Team, In OCI, We need an alert whenever there are multiple failed login attempts to the server from the same user account or source IP address. Please advise which lo…
-
Troubleshooting OCI Site-to-Site VPN Connectivity with On-Premises FortiGateHi Team, We have configured an OCI Site-to-Site VPN between our OCI VCN and an on-premises FortiGate firewall. In future, In case of any connectivity issues, I would lik…
-
Consuming high cpu SQL Capture - BaseDbHi Team, We do not currently have the Database Management feature available for our Oracle Database 19.28 environment. Instead, we have configured a CPU utilization aler…
-
DUPLICATE TARGET DATABASE using RMAN backup-based duplicationHi Team, In one of our legacy system, We are planning to refresh our source database to the target Dev environment using RMAN backup-based duplication. We start the auxi…
-
instance is receiving updates from OSMHHi Team, We have unregistered our DEV instance from OSMH. However, we still see messages indicating that the instance is receiving updates from OSMH. Additionally, the O…
-
OSMHHi Team, We have 2 oci compute instances uat and prod in which we run ords and oic connectivity agent . Not sure,for some reason, osmh is enabled for prod. We want to pe…
-
RHEL 7.9 OS Rebuild – RPMHi team, We have a legacy R12 server that we need to rebuild from scratch using the backups. The test server will be formatted, and we plan to install the same RHEL 7.9 …
-
RMAN restore and recovery procedureHi Team, I have a few questions regarding RMAN restore and recovery procedures: How can we accurately determine the correct SCN and archive log sequence number to use fo…
-
OIC message packHi team, We initially procured one message pack for our OIC instance. Could you please guide me on where to check the message pack consumption and how to identify whethe…
-
How to Identify Peak Concurrent Users in Oracle APEXHi team, We are using Oracle APEX with ORDS on an Oracle 19c database, with Fusion IAM domain for SSO. Users are provisioned through the Fusion Security Console, synchro…
-
RMAN BackupsHi Team, In our production database environment, we have scheduled RMAN backups configured through cron shell scripts. We have tested the restore process, and it is work…
-
ASN Requirements and Best Practices for OCI Site-to-Site VPN with On-Premises FortiGateHi Team, We are configuring a site-to-site IPsec VPN between OCI and our on-premises FortiGate firewall. We would like to understand the ASN requirements and the precaut…
-
Oci site to site vpnHi Team, We are configuring a Site-to-Site VPN between OCI and our on-premises data center. During the configuration, we came across the Diffie-Hellman (DH) group used i…
-
Hub and spoke modelHi Team, In Oracle Cloud Infrastructure (OCI), in which scenarios should we use the Hub-and-Spoke network architecture? Could you please explain the key use cases, benef…
-
How do I set the time zone data file in Autonomous Database?Summary: Receiving ORA-30094 error when building OML Model on Autonomous Database Content (required): I am receiving a an error: ORA-30094: failed to find the time zone … -
Network firewallHi team, Please help us understand; Can the network firewall protect against intrusion attacks and malware? Does it support Intrusion Prevention System (IPS) and real-ti…
-
Adding second OIC Connectivity Agent for High AvailabilityHi Team, Currently, we have an OCI compute instance running the Oracle Integration Cloud (OIC) Connectivity Agent. We are planning to provision a second compute instance…
-
Sequence Handling During Table RefreshHi Team, How should we handle Oracle sequences when refreshing tables from production to the test environment? If we use CONTENT=DATA_ONLY with TABLE_EXISTS_ACTION=TRUNC…
-
Table refreshHi Team, We are on 19.28 version. We regularly refresh tables from the production database to the test environment using Oracle Data Pump (impdp). Depending on the requi…
-
Oracle AI Database 26ai Select AI – Default LLM, Token Limits, and QuotasHi Team, I am exploring Select AI with LLMs in Oracle AI Database 26ai and would like clarification on the following: What is the default LLM model used by Select AI in …
-
VM.Standard.E3.Flex shapesHi team, our current OCI DB System is using the VM.Standard.E3.Flex shape. When I try to create a new DB System from the backup, in the same region and availability doma…
-
Hostnames in ociHi Team, I have a question regarding hostname and DNS configuration when provisioning an Oracle Database in OCI. Do we need to configure our own hostname and customer DN…
-
Public ip and vlan use casesHi Team, We need your guidance to understand below options. 1. Public IP for a Private Instance: is it possible to assign a public IP to an instance that is hosted in a …