Showing posts from September, 2020

How To Assign AME[Approval Management Roles/Responsiblities} Access to Any User in Oracle Apps

How To Assign AME[Approval Management Roles/Responsiblities] Access to Any User in Oracle…

Read more

ORA-01207: file is more recent than control file - old control file

ORA-01207: file is more recent than control file - old control file Database showed the c…

Read more

How to Setup Local NTP server in Linux 7

How to Setup Local NTP server in Linux 7 Network Time Protocol   ( NTP ) – This is a p…

Read more

Oracle Reports - Program exited with status 255 for EBS in Windows

Oracle Reports - Program exited with status 255 for EBS in Windows Issue: When running Ac…

Read more

Query to Find High Water Mark for a Given Table/All Table in Oracle

Query to Find High Water Mark for a Given Table/All Table in Oracle Script: Please note  …

Read more

Query to shrink Datafiles and Reclaim unused Space in Oracle

Query to shrink Datafiles and Reclaim unused Space in Oracle Steps to Shrink the datafil…

Read more

Query to find Oracle Process consuming most of Memory and CPU

Query to find Oracle Process consuming most of the Memory and CPU Session consuming the m…

Read more

How to identify a filesystem type in Linux System

How to identify a filesystem type in Linux System There are multiple ways to determine t…

Read more

How to perform Oracle 11g Data Guard Switchover and Switchback

How to perform Oracle 11g Data Guard Switchover and Switchback  Switchover: Before perfo…

Read more

Cron to Schedule a Script on Last Day of Month

Cron to Schedule a Script on Last Day of Month 00 01 28-31 * * [ "$(date +%d -d tom…

Read more

Query to find Plan Hash Values for a SQLID in Oracle

Query to find Plan Hash Values for a SQLID in Oracle SELECT DISTINCT sql_id, plan_hash_v…

Read more

How to get Oracle SQL output in HTML format and send as a Mail Body

How to get Oracle SQL output in HTML format and send as a Mail Body  SQL Script to get t…

Read more

sendmail errors: Deferred: local mailer (/usr/bin/rmail) exited with EX_TEMPF (HP UX)

sendmail errors: Deferred: local mailer (/usr/bin/rmail) exited with EX_TEMPF (HP UX) Er…

Read more

FNDCPASS error in R12 - Error in password verification for APPS

FNDCPASS error in R12 - Error in password verification for APPS Issue: While changing pas…

Read more