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
-
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 …
-
data loadingHi Masi, For one of our new OCI onboarding projects, we have a requirement to load data only once from a PostgreSQL database into an Oracle database. The PostgreSQL data…
-
Vector index 26ai databaseHi Team, From a DBA perspective regarding AI Vector Search: Vector Indexing and Performance What types of vector indexes are available in Oracle Database, such as HNSW a…
-
Recommended approach to email backup log files from OCI Compute/DBCSHi Team, We have a daily backup script running on an OCI Compute/DBCS instance. The script performs an rsync operation to copy files from one location to another locatio…
-
AI - Vector searchHi Team, We are new to Oracle Database 26ai AI Vector Search. What exactly are chunks and in what cases we need it, and how do we create and load them into the database?…
-
Guidance - SFTP Setup OCIHi Masi, We have a vendor integration where the vendor will send files to us and the files only need to be stored. No further processing is required. We do not have a de…
-
OCI Queue for ClamAV Scan WorkflowHi Team, For an event-driven malware scanning solution, We are trying to implement the below approach. OCI Events → OCI Function → Queue → ClamAV Compute Worker Can you …
-
OCI Vulnerability Scanning ServiceHi Team, We can see OCI Vulnerability Scanning Service (VSS) in the OCI Console and are evaluating whether it would be useful for our environment. How is VSS different f…
-
Vector search 26aiHi Team, I have two separate questions regarding Oracle AI Vector Search: Ranking: How does Oracle calculate cosine distance and rank the results to retrieve the Top K m…
-
OIC : HTTP 503 (Service Unavailable) server errorsHi Team, We seek your guidance on below matter: Process Overview & Flow 1.Data Ingestion (RMS Source DB → Target DB): Daily, around 2,500 to 3,000 records across 14 dist…
-
Oci devops code migrationHi team, After creating the Code Repository from the OCI Console, is it mandatory to install any software on the developer’s desktop to upload/download code? If software…
-
MFA - Oracle FusionHi Team, We are evaluating MFA options for Oracle Fusion Applications. If MFA is configured to send OTPs through SMS to users' mobile phones instead of using a mobile au…
-
malware scanning workflow ociHi Team, We are using Oracle APEX with OCI Object Storage to allow users to upload and download files. We are planning to implement security controls such as file type a…
-
adcfgclone fails in DMZ server for DR setupSummary: adcfgclone.pl appTier dualfs failing with permission error SEVERE : Oct 7, 2026 17:09:43 - ERROR - CLONE-20218 Cloning is not successful. SEVERE : Oct 7, 2026 1… -
OCI scheduler - BaseDBHi Team, For an OCI Base Database Service (DBCS), could you please advise on: What is the recommended IAM policy for Resource Scheduler to stop/start the DBCS instance? …
-
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…
-
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…