{"id":6435,"date":"2017-02-01T20:16:37","date_gmt":"2017-02-01T12:16:37","guid":{"rendered":"http:\/\/rmohan.com\/?p=6435"},"modified":"2017-02-01T20:20:01","modified_gmt":"2017-02-01T12:20:01","slug":"6435","status":"publish","type":"post","link":"https:\/\/mohan.sg\/?p=6435","title":{"rendered":"Install Oracle Express 11G R2 on CentOS 7"},"content":{"rendered":"

\u00a0Install Oracle Express 11G R2 on CentOS 7<\/h3>\n
\n
\n
\n
\n
\n
\n
<\/div>\n<\/header>\n
\n

Preparations<\/h2>\n

Install some additional packages via yum to ensure that the installation and execution of the database will work. The list may differ, depending on the actual version of CentOS you are using, but the internet gave me back the following packages and you should be on the safe side.<\/p>\n

yum update\r\nyum install unzip libaio bc flex<\/pre>\n
\"\"<\/a><\/h2>\n
Download<\/h2>\n
Before using the express edition, make yourself familiar with the license and usage restriction<\/a> this edition is shipped with. If it still fits your needs, be aware that CentOS is not on the list of officially supported Linux distributions<\/a>. You are on your own. Download Oracle Express 11G R2 from Oracle<\/a>. It`s a 308MB file.<\/p>\n
The downloaded file is a zipped RPM package; first step is to unzip the file.<\/p>\n
unzip oracle-xe-11.2.0-1.0.x86_64.rpm.zip<\/pre>\n
\"\"<\/a><\/h2>\n
his gives you a new directory called Disk1. This folder contains the installation RPM.<\/p>\n
Installation<\/h2>\n
Go to the folder and install the RPM via rpm tool.<\/p>\n
cd Disk1\r\nrpm -ivh oracle-xe-11.2.0-1.0.x86_64.rpm<\/pre>\n<\/div>\n
 <\/p>\n
\n
\"\"<\/a><\/h2>\n
After the installation, you`ll be prompted to configure the database.<\/h2>\n<\/div>\n
\"\"<\/a><\/p>\n<\/article>\n
Configuration<\/h2>\n
Run the tool \/etc\/init.d\/oracle-xe to configure the database.<\/p>\n
\/etc\/init.d\/oracle-xe configure<\/pre>\n
\n
\n
\"\"<\/a><\/h2>\n
Configure the port<\/h2>\n
\"\"<\/a>\"\"<\/a><\/h2>\n
Specify the port of the listener<\/h2>\n
Inform the system user password. Be sure to note this down somewhere or to really remember it!!!<\/p>\n
\"\"<\/a><\/h2>\n
Specify if you want the database to be started at boot time.<\/h2>\n
\"\"<\/a>\"\"<\/a><\/h2>\n
The configuration should now start automatically and only take a few minutes to complete.<\/p>\n<\/div>\n
\"\"<\/a><\/p>\n
The database is install at \/u01\/app\/oracle\/product\/11.2.0\/xe\/<\/p>\n
The oracle_env script is in the folder bin.<\/p>\n
\n
\"\"<\/a><\/h2>\n
\"\"<\/a><\/h2>\n<\/div>\n<\/article>\n
Oracle Express 11G R2 is also started and using ps \u2013ef you can see the processes running.<\/h2>\n
\n
\n
\"\"<\/a><\/h2>\n
 <\/p>\n<\/div>\n<\/article>\n
<\/h2>\n
\n
\n
<\/h2>\n
<\/h2>\n
Download<\/h2>\n
Before using the express edition, make yourself familiar with the license and usage restriction<\/a> this edition is shipped with. If it still fits your needs, be aware that CentOS is not on the list of officially supported Linux distributions<\/a>. You are on your own. Download Oracle Express 11G R2 from Oracle<\/a>. It`s a 308MB file.<\/p>\n<\/div>\n<\/article>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
<\/div>\n
<\/div>\n
\n
\n
Install Oracle 11g Express (XE) on CentOS<\/a><\/div>\n
\n
This post will cover basic installation and configuration of Oracle 11g Express Edition (XE) on CentOS.<\/p>\n
We will also take a quick look at configuring Application Express (APEX) for 11g XE.<\/p>\n
Basic installation is straight forward.<\/p>\n
If you just want to get up and running, you can just do steps 1 to 4 below (and 10 and 11 for Apex). The remaining steps (5 to 9) cover basic backup, recovery, and performance configuration.<\/p>\n
The full system requirements are\u00a0here<\/a><\/p>\n<\/div>\n
<\/a><\/p>\n
Your CentOS box should have swap equal to 2xRAM.<\/p>\n
On every CentOS installation I have done for XE, I just needed to update\/install the packages for libaio, bc, and flex.<\/p>\n
\n
\n
view plain<\/a>copy to clipboard<\/a>print<\/a>?<\/a><\/div>\n<\/div>\n
    \n
  1. [root@ms3\u00a0~]#\u00a0\u00a0yum\u00a0install\u00a0libaio\u00a0bc\u00a0flex<\/li>\n<\/ol>\n<\/div>\n
    Step 1: Download and Install Oracle 11g XE rpm<\/b><\/div>\n
    You can download the Oracle XE rpm, oracle-xe-11.2.0-1.0.x86_64.rpm.zip, from the OTN\u00a0here<\/a><\/p>\n
    Unzip oracle-xe-11.2.0-1.0.x86_64.rpm.zip:<\/p>\n
    \n
    \n
    view plain<\/a>copy to clipboard<\/a>print<\/a>?<\/a><\/div>\n<\/div>\n
      \n
    1. [root@ms3\u00a0~]#\u00a0unzip\u00a0-q\u00a0oracle-xe-11.2.0-1.0.x86_64.rpm.zip<\/li>\n<\/ol>\n<\/div>\n
      This will create the directory Disk1. Change to the Disk1 directory:<\/p>\n
      \n
      \n
      view plain<\/a>copy to clipboard<\/a>print<\/a>?<\/a><\/div>\n<\/div>\n
        \n
      1. [root@ms3\u00a0~]#\u00a0cd\u00a0Disk1<\/li>\n
      2. [root@ms3\u00a0Disk1]#\u00a0ls<\/li>\n
      3. oracle-xe-11.2.0-1.0.x86_64.rpm\u00a0\u00a0response\u00a0\u00a0upgrade<\/li>\n<\/ol>\n<\/div>\n
        Install the rpm using rpm -ivh oracle-xe-11.2.0-1.0.x86_64.rpm<\/p>\n
        \n
        \n
        view plain<\/a>copy to clipboard<\/a>print<\/a>?<\/a><\/div>\n<\/div>\n
          \n
        1. [root@ms3\u00a0Disk1]#\u00a0rpm\u00a0-ivh\u00a0oracle-xe-11.2.0-1.0.x86_64.rpm<\/li>\n
        2. Preparing…\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0###########################################\u00a0[100%]<\/li>\n
        3. \u00a0\u00a0\u00a01:oracle-xe\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0###########################################\u00a0[100%]<\/li>\n
        4. Executing\u00a0post-install\u00a0steps…<\/li>\n
        5. You\u00a0must\u00a0run\u00a0‘\/etc\/init.d\/oracle-xe\u00a0configure’<\/span>\u00a0as\u00a0the\u00a0root\u00a0user\u00a0to\u00a0configure\u00a0the\u00a0database.<\/li>\n
        6. <\/li>\n
        7. [root@ms3\u00a0Disk1]#<\/li>\n<\/ol>\n<\/div>\n
          Step 2: Configure 11g XE Database and Options<\/b><\/div>\n
          When installation completes, run ‘\/etc\/init.d\/oracle-xe configure’ to configure and start the database.<\/p>\n
          Unless you wish to change the ports, except the defaults and set SYS\/SYSTEM password.<\/p>\n
          \n
          \n
          view plain<\/a>copy to clipboard<\/a>print<\/a>?<\/a><\/div>\n<\/div>\n
            \n
          1. [root@ms3\u00a0Disk1]#\u00a0\/etc\/init.d\/oracle-xe\u00a0configure<\/li>\n
          2. <\/li>\n
          3. Oracle\u00a0Database\u00a011g\u00a0Express\u00a0Edition\u00a0Configuration<\/li>\n
          4. ————————————————-<\/li>\n
          5. This\u00a0will\u00a0configure\u00a0on-boot\u00a0properties\u00a0of\u00a0Oracle\u00a0Database\u00a011g\u00a0Express<\/li>\n
          6. Edition.\u00a0\u00a0The\u00a0following\u00a0questions\u00a0will\u00a0determine\u00a0whether\u00a0the\u00a0database\u00a0should<\/li>\n
          7. be\u00a0starting\u00a0upon\u00a0system\u00a0boot,\u00a0the\u00a0ports\u00a0it\u00a0will\u00a0use,\u00a0and\u00a0the\u00a0passwords\u00a0that<\/li>\n
          8. will\u00a0be\u00a0used\u00a0for<\/span>\u00a0database\u00a0accounts.\u00a0\u00a0Press\u00a0<enter>\u00a0to\u00a0accept\u00a0the\u00a0defaults.<\/li>\n
          9. Ctrl-C\u00a0will\u00a0abort.<\/li>\n
          10. <\/li>\n
          11. Specify\u00a0the\u00a0HTTP\u00a0port\u00a0that\u00a0will\u00a0be\u00a0used\u00a0for<\/span>\u00a0Oracle\u00a0Application\u00a0Express\u00a0[8080]:<\/li>\n
          12. <\/li>\n
          13. Specify\u00a0a\u00a0port\u00a0that\u00a0will\u00a0be\u00a0used\u00a0for<\/span>\u00a0the\u00a0database\u00a0listener\u00a0[1521]:<\/li>\n
          14. <\/li>\n
          15. Specify\u00a0a\u00a0password\u00a0to\u00a0be\u00a0used\u00a0for<\/span>\u00a0database\u00a0accounts.\u00a0\u00a0Note\u00a0that\u00a0the\u00a0same<\/li>\n
          16. password\u00a0will\u00a0be\u00a0used\u00a0for<\/span>\u00a0SYS\u00a0and\u00a0SYSTEM.\u00a0\u00a0Oracle\u00a0recommends\u00a0the\u00a0use\u00a0of<\/li>\n
          17. different\u00a0passwords\u00a0for<\/span>\u00a0each\u00a0database\u00a0account.\u00a0\u00a0This\u00a0can\u00a0be\u00a0done\u00a0after<\/li>\n
          18. initial\u00a0configuration:<\/li>\n
          19. Confirm\u00a0the\u00a0password:<\/li>\n
          20. <\/li>\n
          21. Do\u00a0you\u00a0want\u00a0Oracle\u00a0Database\u00a011g\u00a0Express\u00a0Edition\u00a0to\u00a0be\u00a0started\u00a0on\u00a0boot\u00a0(y\/n)\u00a0[y]:y<\/li>\n
          22. <\/li>\n
          23. Starting\u00a0Oracle\u00a0Net\u00a0Listener…Done<\/li>\n
          24. Configuring\u00a0database…Done<\/li>\n
          25. Starting\u00a0Oracle\u00a0Database\u00a011g\u00a0Express\u00a0Edition\u00a0instance…Done<\/li>\n
          26. Installation\u00a0completed\u00a0successfully.<\/enter><\/li>\n<\/ol>\n<\/div>\n
            The installation created the directory \/u01 under which Oracle XE is installed.<\/p>\n
            Step 3: Set the Environment<\/b><\/div>\n
            To set the required Oracle environment variables, use the oracle_env.sh the script included under cd \/u01\/app\/oracle\/product\/11.2.0\/xe\/bin<\/p>\n
            \n
            \n
            view plain<\/a>copy to clipboard<\/a>print<\/a>?<\/a><\/div>\n<\/div>\n
              \n
            1. [root@ms3\u00a0Disk1]#\u00a0cd\u00a0\/u01\/app\/oracle\/product\/11.2.0\/xe\/bin<\/li>\n<\/ol>\n<\/div>\n
              To set the environment for your current session run ‘. .\/oracle_env.sh’:<\/p>\n
              \n
              \n
              view plain<\/a>copy to clipboard<\/a>print<\/a>?<\/a><\/div>\n<\/div>\n
                \n
              1. [root@ms3\u00a0bin]#\u00a0.\u00a0.\/oracle_env.sh<\/li>\n<\/ol>\n<\/div>\n
                To set the environment permanently for users, add the following to the .bashrc or .bash_profile of the users you want to access the environment:<\/p>\n
                \n
                \n
                view plain<\/a>copy to clipboard<\/a>print<\/a>?<\/a><\/div>\n<\/div>\n
                  \n
                1. .\u00a0\/u01\/app\/oracle\/product\/11.2.0\/xe\/bin\/oracle_env.sh<\/li>\n<\/ol>\n<\/div>\n
                  You should now be able to access SQL*Plus<\/p>\n
                  \n
                  \n
                  view plain<\/a>copy to clipboard<\/a>print<\/a>?<\/a><\/div>\n<\/div>\n
                    \n
                  1. [root@ms3\u00a0bin]#\u00a0sqlplus\u00a0\/nolog<\/li>\n
                  2. <\/li>\n
                  3. SQL*Plus:\u00a0Release\u00a011.2.0.2.0\u00a0Production\u00a0on\u00a0Wed\u00a0Sep\u00a021\u00a008:17:26\u00a02011<\/li>\n
                  4. <\/li>\n
                  5. Copyright\u00a0(c)\u00a01982,\u00a02011,\u00a0Oracle.\u00a0\u00a0All\u00a0rights\u00a0reserved.<\/li>\n
                  6. <\/li>\n
                  7. SQL>\u00a0connect\u00a0sys\/Password\u00a0as\u00a0sysdba<\/li>\n
                  8. Connected.<\/li>\n
                  9. SQL><\/li>\n<\/ol>\n<\/div>\n
                    Step 4: Allow Remote Access to Oracle 11g XE GUI<\/b><\/div>\n
                    To allow remote access to Oracle 11g XE GUI (as well as Application Express GUI) issue the following from SQL*Plus<\/p>\n
                    \n
                    \n
                    view plain<\/a>copy to clipboard<\/a>print<\/a>?<\/a><\/div>\n<\/div>\n
                      \n
                    1. SQL>\u00a0EXEC\u00a0DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);<\/li>\n
                    2. <\/li>\n
                    3. PL\/SQL\u00a0procedure\u00a0successfully\u00a0completed.<\/li>\n<\/ol>\n<\/div>\n
                      You should now be able to access the Oracle 11g XE Home Page GUI at:<\/p>\n
                      quotes8<\/a><\/p><\/blockquote>\n