Solving ORA-1031 while connecting as “/ as sysdba” :
https://askdba.org/weblog/2008/05/ora-1031-as-sysdba/
opmn is taking time to start
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 …
What is running in the database
https://ss64.com/orav/V$SQLAREA.html
R12 – Responsibility assigned to user cannot be accessed/seen by users
It is often experienced in Oracle Applications R12 that user has been assigned a responsibility…
How to stop/start Cost Manager
1. Go to View All Concurrent Requests form System Administrator: (N) Requests > View 2.…
HOW TO SET THE OVERRIDE ADDRESS in WORKFLOW MAILER
–Set the override address to ‘xyz@abc.com’ , using the following script: –Login to the application…
Troubleshooting Queries
Oracle Current Activity Given below is a small query that provides the following information about…
Current workflow mailer log file location
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…
EBS R12.2.7 of adcfgclone.pl appsTier failed with “Invalid APPS database user credentials. No updates Performed”
After running autoconfig on DB node.. the issue got resolved
Unable to start managed server in R12.2
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…