How to install oracle Explained: Tips and Best Practices

by

Your Guide to Installing Oracle Database: A Step-by-Step Walkthrough

Oracle Database stands as a cornerstone of enterprise data management, powering critical applications worldwide. However, for newcomers and even seasoned IT professionals, the installation process can seem daunting. This comprehensive guide is designed to demystify the procedure, providing a clear, step-by-step walkthrough for installing Oracle Database on a Linux environment, which is the most common deployment scenario. By following these instructions, you’ll be well on your way to setting up a robust database foundation for development, testing, or learning.

Pre-Installation: Laying the Groundwork

Success begins with preparation. Rushing into the installation without proper system checks is a common pitfall. This phase is crucial for a smooth setup.

1. Verify System Requirements

First, ensure your server meets the minimum hardware and software requirements. For Oracle Database 19c, a typical starting point, you should have:

  • Operating System: A supported Linux distribution like Oracle Linux 7/8, Red Hat Enterprise Linux 7/8, or SUSE Linux Enterprise Server 12/15.
  • Memory: At least 1 GB of RAM for the OS plus 1 GB for Oracle. 2 GB minimum is recommended.
  • Disk Space: A minimum of 10 GB for the software binaries and database files.
  • Kernel Parameters: Specific system parameters must be configured. Oracle provides pre-installation RPMs (or scripts) to automate this.

2. Create the Oracle User and Groups

Oracle should never run as the root user. You need to create a dedicated user and groups.

  1. Open a terminal as root.
  2. Create the necessary groups: groupadd -g 54321 oinstall and groupadd -g 54322 dba.
  3. Create the oracle user: useradd -u 54321 -g oinstall -G dba -m -s /bin/bash oracle.
  4. Set a password for the new user: passwd oracle.

3. Configure the Environment and Directories

Set up the optimal environment for the oracle user.

  • Create the directory structure for the software: mkdir -p /u01/app/oracle and chown -R oracle:oinstall /u01.
  • Edit the .bash_profile for the oracle user to set essential environment variables like ORACLE_BASE, ORACLE_HOME, and PATH.
  • Install required OS packages using your distribution’s package manager (e.g., yum or dnf). The Oracle documentation provides an exact list.

The Installation Process

With the system prepared, you can proceed with the actual software installation.

1. Obtain and Unpack the Software

Download the installation files from Oracle’s official website (Oracle Technology Network). You will typically get a ZIP file. Transfer it to your server and unzip it as the oracle user in a temporary directory. Ensure the oracle user has read and execute permissions on the files.

2. Launch the Oracle Universal Installer (OUI)

The OUI is a graphical Java-based tool that guides you through the setup. You need to have a display configured or use X11 forwarding if connecting remotely.

  1. Navigate to the unzipped database directory.
  2. Launch the installer: ./runInstaller.

3. Navigate the Installer Screens

The OUI will present a series of screens. Key decisions include:

  • Configuration Option: Choose “Create and configure a single instance database” for a standard setup.
  • System Class: Select “Server Class” for more control and options.
  • Installation Type: “Typical Install” is recommended for beginners. It uses standard paths and a general-purpose database template.
  • Oracle Home User: On Linux, simply use the existing oracle user you created.
  • Database Configuration: You will be prompted for:
    • Global Database Name: e.g., orcl.localdomain
    • Administrative Password: Set a strong password for the SYS, SYSTEM, and other admin accounts.
    • Database File Location: Use the Oracle-Base directory (/u01/app/oracle).

4. Execute Configuration Scripts

Near the end of the installation, the OUI will prompt you to run two configuration scripts as the root user. Open a new terminal, switch to root, and execute the scripts exactly as the installer indicates. This step is mandatory and finalizes the OS-level configuration.

Post-Installation: Verification and First Steps

Once the installer completes, your database is created and started automatically. It’s time to verify.

  1. Set your environment: source ~/.bash_profile (or log out and back in as the oracle user).
  2. Connect using SQL*Plus: sqlplus sys as sysdba and enter your password.
  3. Run a simple query: SELECT name, open_mode FROM v$database; You should see your database name and that it is READ WRITE.

Congratulations! You have a working Oracle Database instance. Key next steps include unlocking sample schemas like HR for practice, configuring network access via the listener, and establishing your backup strategy.

Conclusion

Installing Oracle Database is a structured process that rewards careful preparation. By methodically meeting system requirements, configuring the operating environment, and carefully following the Oracle Universal Installer, you can successfully deploy one of the world’s most powerful database systems. Remember, this installation creates a foundational instance. Your journey continues with learning database administration, performance tuning, and security hardening. With a solid installation complete, you are now ready to build, store, and manage data on an enterprise-grade platform.

Leave a Comment