Skip to content
Tuesday, February 07, 2023
Database Learners
Menu
  • About Database
  • Oracle
    • ASM
    • Data Pump
    • Backup and Recovery
    • Patching and Upgradation
    • Performance Tuning
    • Data Guard
    • Real Application Cluster
    • Golden Gate
    • PL/SQL
  • MySQL
  • PostgreSQL
  • MongoDB
  • MS SQL Server
  • SQL
  • Linux
  • About Me
  • Contact Us
  • Home
  • 2020
  • August

Month: August 2020

Oracle Enterprise Manager (OEM)

31 March 201520 August 2020 Administrator

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…

How to Backup and Restore a RAC Database

31 March 20153 August 2020 Administrator

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

31 March 2015 Administrator

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

30 March 20157 August 2020 Administrator

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

30 March 20151 August 2020 Administrator

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

30 March 201520 August 2020 Administrator

SQL> select * from v$version; BANNER ——————————————————————————– Oracle Database 11g EnterpRead More…

Add database to 11g OEM Grid control

30 March 201520 August 2020 Administrator

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

30 March 2015 Administrator

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

30 March 20157 August 2020 Administrator

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

30 March 20157 August 2020 Administrator

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…

Posts navigation

Older posts

Recent Posts

  • How to Optimize MySQL Tables and Defragment to Recover Space
  • ORA-01031: Insufficient Privileges When Connect As Sysdba
  • Oracle RAC log files locations
  • Drop all tables in Oracle DB (Schema)
  • How to Determine If the Oracle Redo Log File Size Is a Problem

Categories

  • ASM (40)
  • Backup and Recovery (52)
  • Data Guard (36)
  • Data Pump (28)
  • DB Scripts (26)
  • General (1)
  • Golden Gate (7)
  • Interview Questions (24)
  • Linux (86)
  • MS SQL Server (8)
  • MySQL (120)
  • ORA-Errors (45)
  • Oracle (301)
  • Oracle 10g (19)
  • Oracle 11g (24)
  • Oracle 12c (9)
  • Oracle RAC (101)
  • Oracle XE (7)
  • Patching and Upgradation (19)
  • Performance Tuning (61)
  • PL/SQL (26)
  • RMAN (85)
  • SQL (32)

Visitors

  • 0
  • 40
  • 49,288

Reference Links:

  • https://docs.oracle.com/en/database/index.html
  • https://dev.mysql.com/doc/
  • https://docs.mongodb.com/manual/
  • https://docs.microsoft.com/en-us/sql/sql-server/?view=sqlallproducts-allversions
  • https://www.postgresql.org/docs/current/
@2021 databaselearners.com | Theme: BlogMagazine by Dinesh Ghimire.