RMAN – Backup Based Clone
RMAN has the ability to duplicate, or clone, a database from a backup or from an active database. It is possible to create a duplicate database on a remote server…
Read MoreRecycle Bin in Oracle
Oracle database has the recycle bin which is a data dictionary table and contains information about dropped objects. Until we don’t use the purge option, all dropped tables and…
Read MoreUseful TFACTL Commands
1. Check tfactl status with version: tfactl status 2. Check tfactl tool status: tfactl toolstatus 3. Get config details: tfactl print config 4. List of user having access to tfactl:…
Read MorePDB Lockdown Profiles In Oracle 12.2
ALTER LOCKDOWN PROFILE statement to alter a PDB lockdown profile. You can use PDB lockdown profiles in a multitenant environment to restrict user operations in pluggable databases (PDBs). Create a…
Read MoreSGA TARGET ADVISORY IN ORACLE
The V$SGA_TARGET_ADVICE view provides information that helps us in deciding optimal value for SGA_TARGET. MMON background process gather statistics about sga_target usage and update the V$SGA_TARGET_ADVICE view. Check sga target advisory is…
Read MoreQuery To Find Dependent Objects Of An Invalid Object
SELECT owner, object_type, object_name FROM dba_objects WHERE status = ‘INVALID’ AND object_name IN (SELECT referenced_name FROM dba_dependencies WHERE name = ‘<INVALID_OBJECT_NAME>’);
Read MoreQuery to Check locks on a table
Select object_id, session_id, oracle_username, os_user_name, Process, locked_mode From sys.v_$locked_object; Select a.object_name, b.oracle_username From all_objects a, v$locked_object b Where a.object_id = b.object_id And a.object_name like ‘po%’;
Read MoreSupport date for Oracle WebLogic Server versions
The following table provides the date each version was released and its end of Grace Period. These are dependent on a Patch Set released in order for the Grace Period…
Read MoreOID EMAGENT not started once after Daylight Savings
Once after Daylight saving happened, Some of the IAM & IDM management service was down. So we thought of bouncing the complete SSO services. While starting IDM services EMAGENT was…
Read MoreOpmnctl Process Hangs During Installation and Cloning Due to a Bug in the Opmnctl Script
Environment: Oracle Fusion Middleware - Version 10.1.3.1.0 to 10.1.3.3.0 [Release AS10gR3] Symptoms: The opmnctl process hangs and goes into a loop, executing opmnctl repeatedly and thereby increasing the number of…
Read More