OEM CONTROL COMMANDS: ===================== Stop/start and status oms in cloud control =============================== cd $ORACLE_HOME/bin emctl stop oms emctl start oms emctl status oms stop/start agent in oem cloud control =====================================…
Read MoreViewing an Alert Log from ADRCI ================================ You want to view an alert log by using ADRCI commands. To view an alert log with ADRCI, follow these steps: Invoke ADRCI.…
Read MoreFinding What’s Consuming the Most Undo ======================================= Use the following query to find out which SQL statement has run for the longest time in your database. SQL> select s.sql_text from…
Read MoreDetermining the Optimal Undo Retention Period ============================================== You need to determine the optimal length of time for undo retention in your database. Solution You can specify the length of time…
Read MoreTo obtain the current patchset levels for each specific E-Business Suite functional product test the following steps: 1. Log into OAM. (Responsibility System Administrator,”Oracle Applications Manager”, menu “OAM Support Cart”)…
Read MoreTo find retention guarantee for undo tablespace select tablespace_name,status,contents,retention from dba_tablespaces where tablespace_name like ‘%UNDO%’; To find Undo Space Availability select a.tablespace_name, SIZEMB, USAGEMB, (SIZEMB – USAGEMB) FREEMB from (select…
Read MoreLocking and Disabling User Accounts in Linux 1. Locking the user account To lock a user account use the command usermod -L or passwd -l. Both the commands adds…
Read MoreWe can use ssh to connect between servers, but many times it is required to setup a password less connectivity between the servers. We can follow below steps to…
Read MoreError in `FNDLIBR’: double free or corruption (out) In some concurrent programs, I was seeing the error as FNDLIBR corrupted. Other programs were working fine. This was observed in EBS…
Read MorePROBLEM: After adding a datafile in primary database, recovery process in standby stopped with below error. — Error in alert log of standby database Fri Jan 15 09:56:46 2021 Errors…
Read More