OEM Upgrade from 13.4 to 13.5
OEM UPGRADE FROM 13.4 TO 13.5 PRE-REQUISITE: First, we need to take a backup of the Middleware Home, the Management Repository, Central inventory, Software library, Management Agent. The minimum…
Read MoreOEM 13.4 Step by Step Installation
OEM 13.4 INSTALLATION AND CONFIGURATION OEM OVERVIEW: Oracle Enterprise Manager is management tool, which is used to integrated solution for managing your heterogeneous environment. It Includes, Graphical console, Agents,…
Read MoreBLOCK CHANGE TRACKING
BLOCK CHANGE TRACKING Block changing tracking improves the performance of incremental backups by recording changed blocks in the block change tracking file. During an incremental backup, instead of scanning all…
Read MoreHOW TO RESOLVE ORA-04031: UNABLE TO ALLOCATE 11513896 BYTES OF SHARED MEMORY (“LARGE POOL”,”LARGE POOL”,”CTWR DBA BUFFER”)
Step1: We want to ensure the block change tracking is enabled in our database or not by using the below sql statement. i.e, SQL> select filename,status from v$block_change_tracking; FILENAME ——————————————————————————–…
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 MoreHOW TO RESOLVE THE ORA-01092: ORACLE instance terminated. Disconnection forced ORA-00704: bootstrap process failure ORA-39700: database must be opened with UPGRADE option
In this tutorial, we are going to learn about, “How to resolve these ORA ERRORS: ORA-01092, ORA-00704 and ORA-39700”. I got the below type of error while startup the database.…
Read MoreORACLE OS WATCHER
ORACLE OS WATCHER What is oracle OS watcher? Oracle OS watcher is collects and stores as archives operating system and network metrics that you can use to diagnose performance…
Read MoreORACLE TRACE FILE ANALYZER UPGRADE TO 21.1.2
TRACE FILE ANALYZER UPGRADE TO 21.1.2 Oracle Trace file Analyzer provides a number of diagnostic tools in single bundle, making it easy to gather diagnostic information about oracle database and…
Read MoreEXPORT AND IMPORT DATAPUMP BACKUP USING TABLESPACE PARAMETER
EXPORT AND IMPORT DATAPUMP BACKUP USING TABLESPACE PARAMETER In this blog, we are going to learn about how to do export/import data pump backup by using the tablespace parameter [oracle@oracle Desktop]$ cd [oracle@oracle ~]$ export ORACLE_SID=Trainee [oracle@oracle ~]$ sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 Production on Thu Feb 4 10:42:03 2021 Copyright (c) 1982, 2016, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started.…
Read MoreSCRIPT TO VIEW WHICH DATABASE INSTANCE IS RUNNING CURRENTLY
SCRIPT TO VIEW WHICH DATABASE INSTANCE IS RUNNING In this tutorial, we going to learn about to find which database instance is running now. Mostly we use “/etc/oratab” to view…
Read More