You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
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.

Database

Discussion List

  • SGU
    OCI failed login - server
    Hi 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…
    Accepted answer
    SGU 41 views 10 comments Most recent by SGU
  • SGU
    Troubleshooting OCI Site-to-Site VPN Connectivity with On-Premises FortiGate
    Hi 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…
    Accepted answer
    SGU 24 views 4 comments Most recent by SGU
  • SGU
    DUPLICATE TARGET DATABASE using RMAN backup-based duplication
    Hi 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…
    Accepted answer
    SGU 84 views 10 comments Most recent by Himanshu Nayak-Oracle
  • SGUD
    OSMH
    Hi 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…
    Accepted answer
    SGUD 31 views 1 comment Most recent by Masiuddin Ahmed-Oracle
  • SGU
    RHEL 7.9 OS Rebuild – RPM
    Hi 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 …
    Accepted answer
    SGU 60 views 6 comments Most recent by Himanshu Nayak-Oracle
  • SGUD
    RMAN restore and recovery procedure
    Hi 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…
    Accepted answer
    SGUD 49 views 3 comments Most recent by Masiuddin Ahmed-Oracle
  • SGU
    OIC message pack
    Hi 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…
    Accepted answer
    SGU 32 views 7 comments Most recent by SGU
  • SGU
    How to Identify Peak Concurrent Users in Oracle APEX
    Hi 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…
    Accepted answer
    SGU 32 views 5 comments Most recent by Masiuddin Ahmed-Oracle
  • SGU
    ASN Requirements and Best Practices for OCI Site-to-Site VPN with On-Premises FortiGate
    Hi 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…
    Accepted answer
    SGU 21 views 1 comment Most recent by Masiuddin Ahmed-Oracle
  • SGU
    Oci site to site vpn
    Hi 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…
    Accepted answer
    SGU 12 views 2 comments Most recent by SGU
  • SGU
    Hub and spoke model
    Hi 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…
    Accepted answer
    SGU 10 views 2 comments Most recent by SGU
  • SunSeeker
    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 …
    Received Response
    SunSeeker 123 views 9 comments Most recent by Himanshu Nayak-Oracle
  • SGU
    Network firewall
    Hi 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…
    Accepted answer
    SGU 42 views 4 comments Most recent by Masiuddin Ahmed-Oracle
  • SGU
    Adding second OIC Connectivity Agent for High Availability
    Hi 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…
    Accepted answer
    SGU 32 views 6 comments Most recent by Masiuddin Ahmed-Oracle
  • SGU
    Sequence Handling During Table Refresh
    Hi 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…
    Accepted answer
    SGU 15 views 1 comment Most recent by Masiuddin Ahmed-Oracle
  • SGU
    Table refresh
    Hi 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…
    Accepted answer
    SGU 31 views 4 comments Most recent by Masiuddin Ahmed-Oracle
  • SGU
    Oracle AI Database 26ai Select AI – Default LLM, Token Limits, and Quotas
    Hi 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 …
    Accepted answer
    SGU 58 views 4 comments Most recent by SGU
  • SGU
    VM.Standard.E3.Flex shapes
    Hi 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…
    Accepted answer
    SGU 41 views 1 comment Most recent by Masiuddin Ahmed-Oracle
  • SGU
    Hostnames in oci
    Hi 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…
    Accepted answer
    SGU 21 views 1 comment Most recent by Masiuddin Ahmed-Oracle
  • SGU
    Public ip and vlan use cases
    Hi 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 …
    Accepted answer
    SGU 41 views 6 comments Most recent by SGU
  • SGU
    data loading
    Hi 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…
    Accepted answer
    SGU 43 views 1 comment Most recent by Masiuddin Ahmed-Oracle
  • SGU
    Vector index 26ai database
    Hi 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…
    Accepted answer
    SGU 43 views 4 comments Most recent by SGU
  • SGU
    Recommended approach to email backup log files from OCI Compute/DBCS
    Hi 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…
    Accepted answer
    SGU 50 views 4 comments Most recent by Himanshu Nayak-Oracle
  • SGU
    AI - Vector search
    Hi 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?…
    Accepted answer
    SGU 41 views 4 comments Most recent by Masiuddin Ahmed-Oracle
  • SGU
    Guidance - SFTP Setup OCI
    Hi 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…
    Accepted answer
    SGU 45 views 5 comments Most recent by SGU
  • SGU
    OCI Queue for ClamAV Scan Workflow
    Hi 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 …
    Accepted answer
    SGU 31 views 5 comments Most recent by Masiuddin Ahmed-Oracle
  • SGU
    OCI Vulnerability Scanning Service
    Hi 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…
    Accepted answer
    SGU 61 views 16 comments Most recent by SGU
  • SGU
    Vector search 26ai
    Hi 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…
    Accepted answer
    SGU 31 views 5 comments Most recent by SGU
  • SGU
    OIC : HTTP 503 (Service Unavailable) server errors
    Hi 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…
    Accepted answer
    SGU 52 views 8 comments Most recent by SGU
  • SGU
    Oci devops code migration
    Hi 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…
    Accepted answer
    SGU 40 views 8 comments Most recent by Masiuddin Ahmed-Oracle