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…
SELECT DISTINCT * FROM ( select usr.user_name user_name ,ses.sid||’,’||ses.serial# sid_serial from apps.icx_sessions i ,apps.fnd_logins l…
Oracle E-Business Suite Release 12.2: Backup and Recovery Guidelines For Online Patching (adop) Cutover (Doc…
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…
In this document, we can find out what are queries are running in the database using…
Solution: Enable virtulazation from Bios https://www.youtube.com/watch?v=qNPGljaR_E4