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)

    Oracle 11g Express Database Installation for CentOS 7 - Open Terminal

    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
    How-to Install Oracle 11g R2 Express Database for CentOS 7 - Extraction
  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! 🙂
    CentOS 7 Oracle 11g Express Database Installation - Post Installation Setup

  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! 🙂

  12.  
Advertisements
Leave a comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: