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
    compare and copy between os files & object storage
    Hi Team, We need your guidance on below 2 requirements. "/u01/interfaces/outbound/ap/BPS_DOC" "/mnt/nfsbkp/interfacebkp/outbound/ap/BPS_DOC" Can you please provide a sim…
    Accepted answer
    SGU 10 views 1 comment Most recent by Masiuddin Ahmed-Oracle
  • SGU
    AI implementation low complexity examples
    Hi Team, I want to understand what practical AI use cases a DBA can independently implement and showcase as part of the organization's AI adoption initiative. While func…
    Accepted answer
    SGU 24 views 13 comments Most recent by Masiuddin Ahmed-Oracle
  • SGU
    Ai agent
    Hi Team, Our current architecture consists of an OCI Load Balancer, with the backend application hosted on a oci compute(ORDS), and Oracle Base Database Service, with AP…
    Accepted answer
    SGU 21 views 7 comments Most recent by Masiuddin Ahmed-Oracle
  • SGU
    Migration strategy and cpu review
    Hi Team, We are currently planning to migrate the on-premises HRMS application to our existing OCI environment, which consists of an Oracle Database Service and an OCI L…
    Accepted answer
    SGU 32 views 11 comments Most recent by Masiuddin Ahmed-Oracle
  • SGU
    Apex AI
    Hi Team, We are using apex 24.2 version with 19c database. Our dev team exploring to use any of the AI feature which is shown in apex as attached. Can you please guide w…
    Accepted answer
    SGU 40 views 12 comments Most recent by L. Fernigrini
  • SGU
    Migration
    Hi team, we are currently running Oracle EBS R12, with both the application and database tiers hosted on physical servers (4 OCPUs each). We are planning to migrate the …
    Accepted answer
    SGU 52 views 10 comments Most recent by SGU
  • SGU
    R12.2 migration to new server
    Hi Team, We have a requirement to migrate our existing Oracle E-Business Suite R12.2 environment to new servers with a different operating system version. Current enviro…
    Accepted answer
    SGU 93 views 9 comments Most recent by SGU
  • SGU
    Content security policy
    Hi Marcy, Need guidance on implementing a Content Security Policy (CSP) for our Oracle APEX and ORDS-based applications. Our architecture includes OCI WAF, Load Balancer…
    Accepted answer
    SGU 25 views 3 comments Most recent by Masiuddin Ahmed-Oracle
  • SGU
    restore database review
    Hi Team, We have 2 node RAC with 19.18 version. We are about to migrate the DB to new VM. We want to know whether the backup taken is valid. Attached the restore databas…
    Accepted answer
    SGU 51 views 13 comments Most recent by Masiuddin Ahmed-Oracle
  • SGU
    adcfgclone failure
    Hi Team, adcfgclone in r12.2 app server failed as follows: Log [root@db-erp-rhel7 wlsT2PApply]# cat CLONE2026-11-02_10-53-31_1959775180.error SEVERE : Nov 2, 2026 12:00:…
    Accepted answer
    SGU 42 views 5 comments Most recent by SGU
  • Sudarshan Kulkarni-Oracle
    import table with CLOB
    Summary: We want to perform expdp/impdp of database having a large tables with CLOB datatype of size around 1 TB. What is the fastest way to complete this ? since normal…
    Received Response
    Sudarshan Kulkarni-Oracle 33 views 3 comments Most recent by Masiuddin Ahmed-Oracle
  • SGU
    code migrations
    Hi Masi, We need to revoke direct server access for the development team from linux server immediately, in which they place table and code creation scripts. While we wor…
    Accepted answer
    SGU 23 views 5 comments Most recent by Masiuddin Ahmed-Oracle
  • SGU
    adcfgclone - preq failed
    Hi Team, We are running adcfgclone in R12.2 new app test server. DB version 19c. Both Preinstall rpm was installed. We are on RHEL 7.9 We are facing below error. Any ide…
    Accepted answer
    SGU 15 views 6 comments Most recent by Masiuddin Ahmed-Oracle
  • SGU
    restore failed to new server with same dbname
    Hi Team, We are restoring to new server with same db name. We have taken the source database in mount and fired the backup. But we are unable to do the restore. Please f…
    Accepted answer
    SGU 32 views 6 comments Most recent by SGU
  • SGU
    Memory alert - DBCS
    Hi Team, We recieved alert today: High Memory usage - please check PROD DB State FIRING Type OK_TO_FIRING Severity CRITICAL Notification type Grouped messages across met…
    Accepted answer
    SGU 52 views 24 comments Most recent by SGU
  • SGU
    OTP - Fusion
    Hi Team, A user has reported an issue with MFA authentication in Oracle Fusion. After registering MFA on the mobile device, the OTP is being delivered very late during l…
    Accepted answer
    SGU 22 views 3 comments Most recent by Masiuddin Ahmed-Oracle
  • SGU
    OIC agent migration
    Hi Team, Currently, we have two connectivity agents deployed in our environment: One connectivity agent installed on a cloud server. Another connectivity agent installed…
    Accepted answer
    SGU 20 views 5 comments Most recent by SGU
  • SGU
    backup copy to object storage
    Hi Team, I have backup files of 600 GB, few files sizes are around 150GB. I want to move them to object storage. Uploading from OCI-CLI using CURL without PAR URL curl -…
    Accepted answer
    SGU 32 views 3 comments Most recent by Masiuddin Ahmed-Oracle
  • SGU
    compare files in object storage
    Hi Team, We have a directory containing approximately 10,000 files. These files were copied to an Object Storage bucket, and new files continue to be generated in the so…
    Accepted answer
    SGU 22 views 3 comments Most recent by Masiuddin Ahmed-Oracle
  • SGU
    Secured Object Storage
    Hi Team, I have one query regarding OCI Object Storage security. If an application user's credentials are compromised and the attacker uploads malicious files or launche…
    Accepted answer
    SGU 41 views 12 comments Most recent by Himanshu Nayak-Oracle
  • SGU
    Identifying the integration causing heap error
    Hi Masi, OIC connectivity agent logs Exception in thread "Keep-Alive-Timer" java.lang.OutOfMemoryError: Java heap space Exception in thread "weblogic.transaction.TxTimer…
    Accepted answer
    SGU 33 views 7 comments Most recent by Masiuddin Ahmed-Oracle
  • SGU
    oci waf capability rules
    Hi Masi, We currently have 20 capability rules added in the OCI WAF console. However, the recommended list displays 29 capability rules, and we are planning to add the r…
    Accepted answer
    SGU 21 views 2 comments Most recent by SGU
  • SGU
    OIC agent errors
    Hi Team, Environment: Oracle Integration Cloud (OIC) Connectivity Agent running on Linux. We are occasionally seeing heap memory errors in the Oracle Integration Cloud (…
    Accepted answer
    SGU 72 views 27 comments Most recent by Masiuddin Ahmed-Oracle
  • SGU
    WAF body inspection and proection capabilities comparision
    Hi Team, We need your guidance on the following two points: Is Request Body Inspection mandatory? Our architecture is as follows: OCI WAF policy attached to an OCI Publi…
    Accepted answer
    SGU 51 views 16 comments Most recent by SGU
  • SGU
    Architectural Guidance DBCS Apex and ORDS
    Hi Masi, For context, our current OCI setup consists of: 1 OCI Load Balancer 1 ORDS server running in standalone mode 1 DBCS instance A single ORDS pool serving the appl…
    Accepted answer
    SGU 30 views 4 comments Most recent by SGU
  • SGU
    custom application migration
    Hi 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…
    Accepted answer
    SGU 51 views 7 comments Most recent by SGU
  • SGU
    ORDS sizing
    Hi 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…
    Accepted answer
    SGU 50 views 10 comments Most recent by SGU
  • George Taylor
    Ever faced the Oracle ORA-00942 error Info
    Ever 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…
    Received Response
    George Taylor 22 views 2 comments Most recent by Masiuddin Ahmed-Oracle
  • SGU
    Monitoring, Alerting for OCI WAF and Load Balancer
    Hi 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…
    Accepted answer
    SGU 33 views 5 comments Most recent by Masiuddin Ahmed-Oracle
  • SGU
    Guidance Required: Configuring OCI WAF Security Alerts for SQL Injection, XSS, and Suspicious IP Act
    Hi 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…
    Accepted answer
    SGU 71 views 6 comments Most recent by SGU