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…
Failed to open a sesion for the virtual machine
Solution: Enable virtulazation from Bios https://www.youtube.com/watch?v=qNPGljaR_E4
Upgrade from R12.1.1 to R12.1.3
Here are the steps to upgrade from R12.1.1 to R12.1.3
Upgrade from_R12.2 to R12.2.7
Here are the steps to upgrade from R12.2. to R12.2.7 using startCD 51