How-to Install Oracle 11g R2 Express Database on CentOS 7 64bit GNU/Linux Easy Guide

The Linux Tutorial Show Step-by-Step How-to Install and Getting-Started with Oracle 11g R2 Express Edition Database on CentOS 7 x8664 Workstation/Server Linux+GNU.

Oracle Database Express Edition is a free, smaller-footprint edition of Oracle Database. Oracle Database XE is easy to install and easy to manage.

With Oracle Database XE and related tools you can:

• Administer the database
• Create tables, views, and other database objects
• Import, export, and view table data
• Run queries and SQL scripts

1. Open a Command Line Terminal Window
   (Press “Enter” to Execute Commands)

   Or Login into the Server Shell

2. Download Oracle 11g R2 Express Database Linux:
   Get Oracle 11g Express DB rpm.zip 64bit
3. Double-Click on Archive and Extract into /tmp/
   Or from Shell:

   unzip -d /tmp/ ~/Downloads/oracle-xe-11*.zip
4. Oracle 11g Express Database Installation

   cd /tmp/Disk1

   su -c "rpm -ivh oracle-xe-11*.rpm"

5. Post-Installation SetUp

   su -c "/etc/init.d/oracle-xe configure"

   Eventually Accept the 8080 and 1521 Default Ports…
   Then Set and Take Note of Password for SYS and SYSTEM Admin Accounts
   Finally the Installation should be Successfull! 🙂

6. To Start & Stop Oracle 11g Express DB Manually

   sudo/etc/init.d/oracle-xestart sudo /etc/init.d/oracle-xe stop
7. Environment Vars SetUp

   sudo /u01/app/oracle/product/11.2.0/xe/bin/sqlplus

   If Got “User is Not in Sudoers file” then Look: Solution
   Test:

   which sqlplus

8. Set the ‘oracle’ User Pass

   sudo passwd oracle

9. Login as ‘oracle’ User

   su oracle

10. Launch SQL-Plus

    sqlplus /nolog

11. Connect to Database as SYSTEM Admin

    CONNECT SYSTEM/[yourSYSTEMadminPASS]

    Example:

    CONNECT SYSTEM/eureka

    Then You should be Successfully Connected Locally to the Database! 🙂