How to Quick-Start With Oracle 11g Express Database for Linux Easy Guide

April 9, 2015 | By the+gnu+linux+evangelist.

Linux Oracle 11g Express Edition Database Quick Start

Hi! The Tutorial shows you Step-by-Step How to Install and Getting-Started with Oracle 11g R2 Express Edition Database on Linux Desktops/Servers.

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
Oracle 11g Database Getting-Started on Linux - Featured
  1. How to Install Oracle 11g Express Database on Linux

    Oracle 11g Express DB Installation
  2. Environment Vars SetUp.

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

    If Got “User is Not in Sudoers file” then see: How to Enable sudo
    Test:

    which sqlplus
  3. Set the ‘oracle’ User Pass.

    sudo passwd oracle
  4. Login as ‘oracle’ User.

    su oracle
  5. Launch SQL-Plus.

    sqlplus /nolog
  6. Connect to Database as SYSTEM Admin.

    CONNECT SYSTEM/[yourSYSTEMadminPASS]

    Example:

    CONNECT SYSTEM/eureka

    Then you should be Successfully Connected Locally to the Database! :)

  7. Further Oracle 11g Express DB Online Documentation

    Oracle 11g Express DB Docs

QuickChic Theme • Powered by WordPress