{"id":3239,"date":"2013-04-06T06:28:01","date_gmt":"2013-04-06T13:28:01","guid":{"rendered":"http:\/\/blog.networkpresence.co\/?p=3239"},"modified":"2013-04-06T06:28:01","modified_gmt":"2013-04-06T13:28:01","slug":"installing-oracle-xe-database-on-centos","status":"publish","type":"post","link":"http:\/\/blog.networkpresence.co\/?p=3239","title":{"rendered":"Installing Oracle XE Database on CentOS"},"content":{"rendered":"

Once you satisfy the login requirements for Oracle’s site, you can download their “Express” Database, which from their License Agreement<\/a> for that DB sofware, can only be run\/used in the following manner:<\/p>\n

Any use of the Oracle Database Express Edition is subject to the following limitations;
\n1. Express Edition is limited to a single instance on any server;
\n2. Express Edition may be installed on a multiple CPU server, but may only be executed on one processor in any server;
\n3. Express Edition may only be used to support up to 11GB of user data (not including Express Edition system data);
\n4. Express Edition may use up to 1 GB RAM of available memory.<\/p><\/blockquote>\n

We offer a number of 1GB+ RAM VPS Plans<\/a> and once you’ve downloaded the Oracle Express DB distriubtion .zip file, the following describes getting it installed and running on a CentOS 5.9 64-bit VPS.<\/p>\n

1) Install and ensure Prerequisites<\/p>\n

yum install libaio bc flex<\/code><\/p>\n

You also need to have twice as much RAM configured as Swap space to the CentOS system. So if you have a 1GB RAM VPS, then Oracle XE’s installer requires that you need (at least) 2GB of Swap configured to the system.<\/p>\n

A quick way to add Swap space is to use a “swap file” in the filesystem, commands like:<\/p>\n

dd if=\/dev\/zero of=\/var\/swap.file count=2000000 bs=1024
\nchmod go= \/var\/swap.file
\nmkswap \/var\/swap.file
\necho \"\/var\/swap.file swap swap defaults 0 0\" >> \/etc\/fstab
\nswapon -a<\/code><\/p>\n

2) Download oracle-xe-11.2.0-1.0.x86_64.rpm.zip<\/a> and unzip to \/usr\/local\/src<\/p>\n

cd \/usr\/local\/src
\nunzip oracle-xe-11.2.0-1.0.x86_64.rpm.zip
\nArchive: oracle-xe-11.2.0-1.0.x86_64.rpm.zip
\n creating: Disk1\/
\n creating: Disk1\/upgrade\/
\n inflating: Disk1\/upgrade\/gen_inst.sql
\n creating: Disk1\/response\/
\n inflating: Disk1\/response\/xe.rsp
\n inflating: Disk1\/oracle-xe-11.2.0-1.0.x86_64.rpm
\n<\/code><\/p>\n

3) Install the .rpm<\/p>\n

rpm -ivh oracle-xe-11.2.0-1.0.x86_64.rpm<\/code><\/p>\n

4) After the RPM is installed, you need to run \/etc\/init.d\/oracle-xe configure, during which you need to supply the inital SYS DB User’s password.<\/p>\n

\/etc\/init.d\/oracle-xe configure<\/p>\n

Oracle Database 11g Express Edition Configuration
\n-------------------------------------------------
\nThis will configure on-boot properties of Oracle Database 11g Express
\nEdition. The following questions will determine whether the database should
\nbe starting upon system boot, the ports it will use, and the passwords that
\nwill be used for database accounts. Press to accept the defaults.
\nCtrl-C will abort.<\/p>\n

Specify the HTTP port that will be used for Oracle Application Express [8080]:<\/p>\n

Specify a port that will be used for the database listener [1521]:<\/p>\n

Specify a password to be used for database accounts. Note that the same
\npassword will be used for SYS and SYSTEM. Oracle recommends the use of
\ndifferent passwords for each database account. This can be done after
\ninitial configuration: TYPE your Passwd
\nConfirm the password: TYPE your Passwd Again<\/p>\n

Do you want Oracle Database 11g Express Edition to be started on boot (y\/n) [y]:<\/p>\n

Starting Oracle Net Listener...Done
\nConfiguring database...
\nDone
\nStarting Oracle Database 11g Express Edition instance...Done
\nInstallation completed successfully.<\/code><\/p>\n

5) After install, configure the Oracle environment for your relevant users on the CentOS system<\/p>\n

First, set the required Oracle environment variables, use the oracle_env.sh the script that’s installed by the RPM to \/u01\/app\/oracle\/product\/11.2.0\/xe\/bin<\/p>\n

cd \/u01\/app\/oracle\/product\/11.2.0\/xe\/bin
\n. .\/oracle_env.sh<\/code><\/p>\n

To set these environment variables permanently for users, add the following to the .bashrc or .bash_profile of the users you want to access the environment:<\/p>\n

. \/u01\/app\/oracle\/product\/11.2.0\/xe\/bin\/oracle_env.sh<\/code><\/p>\n

6) You can use the Oracle s\/ware (SQL*Plus) from the Linux command line with:<\/p>\n

sqlplus \/nolog<\/p>\n

SQL*Plus: Release 11.2.0.2.0 Production on ....
\nCopyright (c) 1982, 2011, Oracle. All rights reserved.<\/p>\n

SQL> connect sys\/your-SYS-Password as sysdba
\nConnected.
\nSQL><\/code><\/p>\n

7) Enable remote access for the DB<\/p>\n

To enable and allow remote access to the Oracle XE GUI, run the following command from SQL*Plus, connected as the SYS user:<\/p>\n

SQL> EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);<\/p>\n

PL\/SQL procedure successfully completed.
\n<\/code><\/p>\n

You should now be able to access the Oracle 11g XE Home Page GUI at:<\/p>\n

http:\/\/your-VPS-IP-Address:8080\/apex<\/code><\/p>\n

Replace your-VPS-IP-Address<\/code> above with your IP or hostname as required.<\/p>\n

Log in as SYSTEM using the password you supplied in the above ‘configure’ step.<\/p>\n

You now have a running Oracle XE database installed and usable from the command-line (sqlplus) and the Web.<\/p>\n

Any customers who’d like us to install this Database software are welcome to contact us<\/a> to do that for them.<\/p>\n

FYI,
\nRichard.<\/p>\n","protected":false},"excerpt":{"rendered":"

Once you satisfy the login requirements for Oracle’s site, you can download their “Express” Database, which from their License Agreement for that DB sofware, can only be run\/used in the following manner: Any use of the Oracle Database Express Edition … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,70],"tags":[246,18,157,78],"class_list":["post-3239","post","type-post","status-publish","format-standard","hentry","category-network-presence","category-sales","tag-database","tag-linux","tag-oracle","tag-sysadmin"],"_links":{"self":[{"href":"http:\/\/blog.networkpresence.co\/index.php?rest_route=\/wp\/v2\/posts\/3239","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/blog.networkpresence.co\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.networkpresence.co\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.networkpresence.co\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.networkpresence.co\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3239"}],"version-history":[{"count":8,"href":"http:\/\/blog.networkpresence.co\/index.php?rest_route=\/wp\/v2\/posts\/3239\/revisions"}],"predecessor-version":[{"id":3250,"href":"http:\/\/blog.networkpresence.co\/index.php?rest_route=\/wp\/v2\/posts\/3239\/revisions\/3250"}],"wp:attachment":[{"href":"http:\/\/blog.networkpresence.co\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3239"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.networkpresence.co\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3239"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.networkpresence.co\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3239"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}