Oracle

How to Restore Oracle Database using RMAN (with Examples)

by Ramesh Natarajan on November 24, 2014

As a Linux sysadmin, you might recover a system from backup, which may include Oracle Database.

So, it is essential for all admins to understand how to restore oracle database from backup.

Typically, DBAs will use Oracle RMAN utility to take a hot backup of the database.

This tutorial provides an introduction on how to restore an Oracle database from the RMAN backup.
(more…)

How to Create an Oracle OVM VM from an Linux ISO DVD Image

by Ramesh Natarajan on January 15, 2014

If you are a Linux sysadmin, working in an environment that uses lot of Oracle products, you might be in a situation to explore the Oracle virtualization product called OVM.

In OVM, you’ll typically use a pre-existing OVM templates for a particular Linux distro (or Windows) to create a virtual machine.

But, you can also create an OVM VM from an ISO image. If you are installing a specific version of OS on your environment a lot, you can upload that particular distro ISO image to an Oracle VM repository, and use it to create new virtual machine as many times as you like.
(more…)

Most of you are already familiar with SQL database, and have a good knowledge on either MySQL, Oracle, or other SQL databases. In the last several years, NoSQL database is getting widely adopted to solve various business problems.

It is helpful to understand the difference between SQL and NoSQL database, and some of available NoSQL database that you can play around with.
(more…)

How Much Swap Space to Add for Oracle Database on Linux

by Ramesh Natarajan on October 17, 2013

If you are running Oracle database on your environment, and having some performance issues because of memory, you may have to look at the swap space configured on your system.

For Oracle 11g database, the following is the recommendation from Oracle in terms of how much space space you should add.
(more…)

How to Backup Oracle Database using RMAN (with Examples)

by Ramesh Natarajan on August 27, 2013

Even if you are not an Oracle DBA, you’ll still encounter a situation where you may have to take a backup of an Oracle database.

Using Oracle RMAN, you can take a hot backup for your database, which will take a consistent backup even when your DB is up and running.

This tutorial gives you an introduction on how to perform Oracle DB backup using RMAN.
(more…)

If you are using Oracle database, at some point you might have to deal with uploading data to the tables from a text file.

This article provides 10 practical examples on how to upload data from a flat file to Oracle tables.
(more…)

How to Install Oracle VM VirtualBox and Create a Virtual Machine

by Lakshmanan Ganapathy on February 3, 2012

Oracle VM VirtualBox is an open source virtualization software that you can install on various x86 systems. You can install Oracle VM Virtualbox on top of Windows, Linux, Mac, or Solaris. Once you install the virtualbox, you can create virtual machines that can be used to run guest operating systems like Windows, Linux, Solaris, etc.

On a high-level Oracle VM VirtualBox is similar to VMware. Oracle got this VirtualBox technology from Sun.

This article cover the basic installation of virtualbox and how to install a guest OS on it.
(more…)

Question: I have purchased Linux support for RHEL and OEL from Oracle corporation. How do I register my Linux system to Oracle support network to download and update packages? Can you explain me with step-by-step instruction?

Answer: After purchasing Linux support from Oracle, you should register your Linux system with Oracle’s Unbreakable Linux Network using up2date utility as explained in this article.
(more…)