Oracle Enterprise Manager (OEM)
Oracle Enterprise Manager is Oracle’s GUI-based database management tool. It is possible to manage the oracle environment using SQL and PL/SQL but OERead More…
Month: August 2020
How to Backup and Restore a RAC Database
This example illustrates how to backup and recover a 2-node, 10gR2 RAC cluster on Linux. Backup and recovery operations for RAC databases are similarRead More…
Convert 11gR2 non-RAC database to RAC database using rconfig
This post talks about the Conversion of 11gR2 non-RAC database to RAC database using rconfig. Oracle provides 3 methods to convert non-RAC sinRead More…
RAC 11gR2 Setup requirements document
Architecture • Shown above is very basic 2-node 11gR2 RAC architecture.
• IP addresses shown are just for the sake of example purpose only.
•Read More…
Bitmap & B-Tree indexes
What is Index? An index is a performance-tuning method of allowing faster retrieval of records. An index creates an entry for each value that appearsRead More…
Move datafile to NEW Location
SQL> select * from v$version; BANNER ——————————————————————————– Oracle Database 11g EnterpRead More…
Add database to 11g OEM Grid control
Here I have a 11g Grid control running on Linux x86_64. To add a database in the Grid control, Open OEM grid control page –> targets –> datRead More…
Upgrade OPatch version from 11.2.0.1.1 to 11.2.0.3.3
I want to update my OPatch version from 11.2.0.1.1 to 11.2.0.3.3 on My LINUX server, to do so we need to apply patch 6880880 $ cd $ORACLE_HOME/OPatcRead More…
Install Oracle Goldengate on LINUX 11gr2
Here we are going to install oracle Goldengate 11.2.1.0.3 on my oracle 11.2.0.2 database, Linux 64 bit If it is a RAC, then install in a common loRead More…
Uninstall Oracle GOLDENGATE on LINUX
Log on to the database server (as oracle) where the GoldenGate software is installed. cd /home/oracle/ggs Start GGSCI: ./ggsci Stop all GoRead More…