Software & AppsOperating SystemLinux

How To Install Oracle 12c DB on Ubuntu 18.04 LTS and Informatica ETL Tool

Ubuntu 9

In this article, we will guide you through the process of installing Oracle 12c Database on Ubuntu 18.04 LTS and setting up Informatica ETL tool. This comprehensive guide will provide you with step-by-step instructions to ensure a successful installation.


Before we start, ensure that you have the following:

  • A 64-bit version of Ubuntu 18.04 LTS installed.
  • Sufficient system resources: Oracle 12c requires a minimum of 2GB of RAM (4GB recommended), and at least 10GB of disk space.
  • Oracle Database 12c Release 2 for Linux x86-64 installation files. You can download them from the Oracle website.
  • Informatica ETL tool installation files. You can download them from the Informatica website.

Installing Required Packages

Before installing Oracle 12c, we need to install some necessary packages. Open the terminal and run the following command:

sudo apt-get install alien libaio1 unixodbc
  • alien is a program that converts between different Linux package formats.
  • libaio1 and unixodbc are libraries required by Oracle.

Installing Oracle 12c DB

Extracting Installation Files

After downloading the Oracle 12c DB installation files, extract them to a directory of your choice. You can do this using the tar command:

tar -xvf [filename]

Replace [filename] with the name of the downloaded file.

Running the Oracle Universal Installer

Navigate to the directory where you extracted the installation files and run the Oracle Universal Installer:

sudo ./runInstaller

This command will start the installer. Follow the on-screen instructions to install the software. When asked for the installation type, choose “Install database software only” and provide the necessary configuration details.

Fixing Potential Hang Issue

During the database startup, you might encounter a self-deadlock issue. Here’s how to fix it:

Navigate to the $ORACLE_HOME/lib/stubs directory and remove the existing libc* files:

cd $ORACLE_HOME/lib/stubs
rm libc*

Then, navigate to the $ORACLE_HOME/bin directory and relink all the binaries:

./relink all

Creating the Oracle 12c Database

After fixing the hang issue (if applicable), you can proceed to create the database. Start the Database Configuration Assistant (dbca) by running the following command:


Follow the on-screen instructions to configure and create your Oracle 12c database.

Installing Informatica ETL Tool

After successfully installing Oracle 12c DB, you can install the Informatica ETL tool. The installation process may vary depending on the specific version of the tool. Therefore, it is recommended to refer to the Informatica documentation for the specific installation steps.


Congratulations! You have successfully installed Oracle 12c DB on Ubuntu 18.04 LTS and the Informatica ETL tool. Remember to always refer to the official Oracle and Informatica documentation for detailed and up-to-date installation instructions.

What is Oracle 12c Database?

Oracle 12c Database is a relational database management system developed by Oracle Corporation. It is designed to handle large amounts of data and provides features such as high availability, scalability, and security.

What is Ubuntu 18.04 LTS?

Ubuntu 18.04 LTS (Long Term Support) is a popular Linux distribution that provides a stable and secure operating system for desktops, servers, and cloud environments. LTS releases are supported for five years, making them a reliable choice for long-term use.

What is an ETL tool?

ETL stands for Extract, Transform, and Load. ETL tools are software applications used to extract data from various sources, transform it into a suitable format, and load it into a target database or data warehouse. These tools help in data integration, data migration, and data warehousing tasks.

Where can I download Oracle 12c Database and Informatica ETL tool?

You can download Oracle 12c Database from the Oracle website at []. Informatica ETL tool can be downloaded from the Informatica website at [].

What are the system requirements for installing Oracle 12c Database?

Oracle 12c Database requires a 64-bit version of Ubuntu 18.04 LTS, a minimum of 2GB of RAM (4GB recommended), and at least 10GB of disk space. Make sure your system meets these requirements before proceeding with the installation.

Leave a Comment

Your email address will not be published. Required fields are marked *