Changed long_running JVM to false https://oraclepitstop.wordpress.com/2008/09/12/blank-appslogin-appslocallogin-page-in-r12/ Workaround Set LONG_RUNNING_JVM=false in $INST_TOP/ora/10.1.3/j2ee/oacore/config/oc4j.properties Bounce opmn services …
https://ss64.com/orav/V$SQLAREA.html
It is often experienced in Oracle Applications R12 that user has been assigned a responsibility…
1. Go to View All Concurrent Requests form System Administrator: (N) Requests > View 2.…
–Set the override address to ‘xyz@abc.com’ , using the following script: –Login to the application…
Oracle Current Activity Given below is a small query that provides the following information about…
select fl.meaning,fcp.process_status_code, decode(fcq.concurrent_queue_name,’WFMLRSVC’,’maile r container’,’WFALSNRSVC’,’listener container’,fcq.concurrent_queue_name), fcp.concurrent_process_id,os_process_id, fcp.logfile_name from fnd_concurrent_queues fcq, fnd_concurrent_processes fcp , fnd_lookups…
After running autoconfig on DB node.. the issue got resolved
It could be lock issue, rename below files cd $EBS_DOMAIN_HOME/servers/oacore_server1/data/store/diagnostics WLS_DIAGNOSTICS000000.DAT mv WLS_DIAGNOSTICS000000.DAT WLS_DIAGNOSTICS000000.DAT_old You can now…
https://oracleracdba1.wordpress.com/2012/09/18/script-to-generate-awr-reports-for-all-snap_ids-between-2-given-dates/ gen_batch.sql set echo off heading off feedback off verify off select ‘Please enter dates…