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…
AWR Hourly
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…
Identify sessions of an user in Oracle EBS
SELECT DISTINCT * FROM ( select usr.user_name user_name ,ses.sid||’,’||ses.serial# sid_serial from apps.icx_sessions i ,apps.fnd_logins l…
Revert the cutvover
Oracle E-Business Suite Release 12.2: Backup and Recovery Guidelines For Online Patching (adop) Cutover (Doc…
Issue RMAN Duplicate
While doing RMAN dupicate, I have not give log_file_name_convert and db_file_name_convert Here are errors and solutions…
Error “Use of uninitialized value $result in split” In File txkADOPValidations.error When Running fs_clone (Doc ID 2090393.1)
Error “Use of uninitialized value $result in split” In File txkADOPValidations.error When Running fs_clone (Doc…
What queries are running in the database
In this document, we can find out what are queries are running in the database using…