How to Create a Custom Concurrent Manager
Adding Concurrent Manager is a crucial decision. Lots of things needs to be examined before adding new Concurrent Manager. One of the major area is resources.If you have less number…
Read MoreHow To Remove Error Notifications From The Worklist (Doc ID 357904.1)
racle Workflow – Version 11.5.10.2 to 12.2 [Release 11.5.10 to 12.2] Oracle Order Management – Version 12.2.4 to 12.2.4 [Release 12.2] Information in this document applies to any platform. GOAL…
Read MoreEBS R12: Oracle Application Manager – All Self Service page Display format and images not showing and overlapping:
We are on Oracle Linux 6.5, Oracle Database 11.2.0.4, Oracle EBS 12.1.3 for all Self Service Application, under Oracle Application Manager, like – Workflow, License Manager, Patching and Utilities and…
Read MoreR12 HTTP_Server Shows Status as Down After Running Apachectl.sh Start, and the Apache Log Shows Error ‘apachectl is not owned by this user’
APPLIES TO: Oracle E-Business Suite Technology Stack - Version 12.1.3 to 12.1.3 [Release 12.1] Information in this document applies to any platform. SYMPTOMS: E-Business Suite 12.1.3, IAS for Applications Technology…
Read MoreInternal Concurrent Manager Has Terminated With Status 137 – Giving Up . ld.so.1: mail: warning: /usr/lib/extendedFILE.so.1: open failed: illegal insecure pathname
APPLIES TO: Oracle Concurrent Processing - Version 12.1.3 to 12.1.3 [Release 12.1] Oracle Solaris on SPARC (64-bit) SYMPTOMS: Error in the Concurrent Manager Log File : ld.so.1: mail: warning: /usr/lib/extendedFILE.so.1:…
Read MoreMaximum Security Zone in Oracle Cloud
Maximum Security Zones provides both preventative and detective security controls for cloud environment. Maximum Security Zones is the preventative control, designed to stop from making bad implementation choices that would…
Read MoreMobile First strategy with Oracle CX Mobile App
Enterprise are emphasizing on building a culture of proactive sales with responsibility of identifying leads,new account openings and agility in closing deals. To achieve this, organizations are looking towards recent…
Read MoreTOP Elapsed time SQL in certain hours with below script
Query will find out TOP Elapsed time SQL in certain hours with below script SELECT st.sql_text, sub.sql_id, sub.ELAPSED_TIME PER_EXEC_ELAPSED_TIME_MINUTES FROM DBA_HIST_SQLTEXT st, ( SELECT t.sql_id, ROUND ( SUM (t.elapsed_time_delta /…
Read MoreFind undo blocks and connect by SQL_ID
Provided script will find out the UNDO tablespace blocks usage to the corresponding SQL ID which you will provide. select dhs.sql_id, round(sum((vu.activeblks*8)/1024)) ActiveUNDOMB, round(max((vu.unexpiredblks*8)/1024)) UnexpiredUNDOMB ,max(vu.tuned_undoretention)TunedUndo, max(vu.begin_time)newest_time from v$undostat vu…
Read Moreclrg comand for Oracle Apps DBA in Oracle SuperCluster Environment
Hi All, In Oracle SuperCluster Environment we use important command ‘clrg’ for stopping and Starting of Oracle Web tier and Concurrent Manager Services. clrg stands for clresourcegroup, which assist us…
Read More