To 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 MoreASMLIB is a storage management interface. ASMLIB is not required for ASM to function; it is like an add-on library that simplifies the tasks of managing and discovering the disks.…
Read MoreThe auditing mechanism for Oracle is extremely flexible. Oracle stores information that is relevant to auditing in its data dictionary. Every time when a user attempts anything in the database…
Read MoreBelow are some of the useful ASM commands which will be helpful all the time. ASMCMD > showversion ASMCMD > showversion –releasepatch –softwarepatch ASMCMD > showpatches ASMCMD > showclustermode ASMCMD…
Read MoreWhere I Faced this Issue? When I ran adcfgclone appsTier on EBS 12.2 I got this error, and it said got error while running autoconfig, but the actual error is…
Read MoreLong Term Release: Oracle Database Long Term Releases offers highest level of stability including lot of bug fixes developed over the period of years. It typically has highest premier…
Read More