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
-
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… -
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… -
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… -
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…