Oracle Wait Events and Their Solutions
Db file sequential read: This event occurs when a user tries to perform a Physical I/O while waiting for sequential reads from the Buffer cache. It occurs when the data on…
Read MoreORA-24247: network access denied by access control list (ACL)
ERROR:- Error starting at line : 20 in command – BEGIN APEX_INSTANCE_ADMIN.VALIDATE_EMAIL_CONFIG; END; Error report – ORA-24247: network access denied by access control list (ACL) ORA-06512: at “SYS.UTL_TCP”, line 19…
Read MoreAn API call has been prohibited
While calling the object in oracle apex metadata we are getting this issue. This issue was raised by development team. ISSUE:- Getting an error An API call has been prohibited.…
Read MoreMethods to fix adrelink fails in cloned environments
This blog post will discuss how to deal with adrelink failures when applying patches in EBS tech_st home. Sometimes, when you apply OPatch to EBS $ORACLE_HOME in cloned instances, the…
Read MoreEBS Application Migration Issues from RHEL 5 to RHEL 7 for Oracle EBS 12.1
One of the common challenges that Oracle EBS 12 users face is migrating their applications from RHEL 5 to RHEL 7. This process involves several steps to fix the issues,…
Read MoreDisplay Any Country’s Current Date and Time in Oracle Forms
1. Overview This blog explains about, how we can shows a text box to display the current date and time for the selected country in oracle forms. 2. Technologies and…
Read MoreHow do I fix the ORA-01172 error?
Issue: I have the ORA-01172 error in my alert log, and I cannot start my database: ORA-01172: recovery of thread 1 stuck at block 25 of file 2 ORA-01151: use…
Read MoreHow to Generate Serial Number in Oracle Forms
1. Overview This blog explains about, how we can Generate Serial Number in Oracle Forms. 2. Technologies and Tools Used The following technology has been used to achieve the same.…
Read MoreHow to fix if SRVCTL is not working?
Issue: srvctl commands and functionalities are not working in the RAC databases. Error: [oracle@host oracle] srvctl config database -d SID_NAME PRCR-1119 : Failed to look up CRS resources of database type PRKC-1137 :…
Read MoreEmployee Work Schedule Update Integration
Employee Work Schedule Update Integration – Oracle Fusion HCM. Introduction: This blog explains about how to call a bip report placed in the oracle fusion hcm instance. And then transfer…
Read More