Oracle Multitenant explained in simple terms
Many of us would have come across the word “Multitenant Architecture” in Oracle world. By the time, we read this, some of us feel boring to go in detail and…
Read MoreScript to see all lock objects
set term on; set lines 130; column sid_ser format a12 heading 'session,|serial#'; column username format a12 heading 'os user/|db user'; column process format a9 heading 'os|process'; column spid format a7…
Read MoreQuery to get the baseline for an sql id
Please use below query. col sql_text for a60 wrap set verify off set pagesize 999 set lines 155 col username format a13 col prog format a22 col sid format…
Read MoreHow to remove the Oracle OLAP Option from a 12c Database during 19c Upgrade
Check the OLAP option is enabled in database. select parameter, value from v$option where parameter = ‘OLAP’; PARAMETER VALUE OLAP FALSE select comp_id, comp_name, version, status, schema from dba_registry where…
Read MoreRMAN Active Duplicate Fails with ORA-19837 ORA-19849 ORA-19850
RMAN active duplicate fails with error: RMAN-03002: failure of Duplicate Db command at 09/25/2018 08:24:05 RMAN-05501: aborting duplication of target database RMAN-03015: error occurred in stored script Memory Script ORA-19849:…
Read MoreUseful CRSCTL Commands
STOP & START CRS: ( run from root user) $GRID_HOME/bin/crsctl stop crs $GRID_HOME/bin/crsctl start crs Enable/Disable auto restart of CRS. $GRID_HOME/bin/crsctl disable crs $GRID_HOME/bin/crsctl enable crs Find the cluster name…
Read MoreSchedule Statspack Report Generation.
Declaration : In this scripts using for schedule statspack report generation for hourly, frequently and purge weekly snapshots. Statspack is instead of AWR because AWR report is licensed. Script:…
Read MoreCreate a New PL/SQL Library
The steps in this section will show you how to create a new PL/SQL library, then create a function that will live in this library. To create the library: Launch…
Read MoreORA 02049: Distributed Transaction Timeout waiting for lock
ORA 02049: Distributed Transaction Timeout waiting for lock This error occurs when a session is trying to modify a table’s row in a remote database through a database link that…
Read MoreORACLE GOLDEN GATE ERROR OGG-00868
In this tutorial, we are going to learn about, “How to resolve this ERROR OGG-00868″ I got the below type of error while re-start the replicat in golden gate. I…
Read More