{"id":442,"date":"2010-12-09T12:08:37","date_gmt":"2010-12-09T17:08:37","guid":{"rendered":"http:\/\/otac.isa-geek.net\/blog\/?p=442"},"modified":"2010-12-09T12:08:37","modified_gmt":"2010-12-09T17:08:37","slug":"installing-oracle-express-edition-xe-on-64-bit-ubuntu-10-04-lucid","status":"publish","type":"post","link":"https:\/\/otac.isa-geek.net\/blog\/?p=442","title":{"rendered":"Installing Oracle Express Edition (XE) on 64-bit Ubuntu 10.04 (Lucid)"},"content":{"rendered":"

I wanted to install Oracle XE on my laptop to do some simple Oracle database modeling work, since it gives fairly complete Oracle database functionality without the space and configuration hassle of Enterprise 10G or 11G. However, After going to http:\/\/www.oracle.com\/technetwork\/database\/express-edition\/downloads\/102xelinsoft-102048.html<\/a> to download the Debian (.deb) package, I discovered there that is no 64-bit version available for Linux! (Windows, surprisingly, is<\/strong> supported in 64-bit). However, it turns out the Linux 32-bit i386 version will work under Ubuntu 64-bit. I followed the steps below to get it installed:<\/p>\n

In a terminal session, I ran:<\/p>\n

duanecato@ino:~$ cd downloads
\nduanecato@ino:~\/downloads$ sudo dpkg -i –force-architecture oracle-xe_10.2.0.1-1.0_i386.deb
\n[sudo] password for duanecato:
\ndpkg: warning: overriding problem because –force enabled:
\npackage architecture (i386) does not match system (amd64)
\nSelecting previously deselected package oracle-xe.
\n(Reading database … 266352 files and directories currently installed.)
\nUnpacking oracle-xe (from oracle-xe_10.2.0.1-1.0_i386.deb) …
\ndpkg: dependency problems prevent configuration of oracle-xe:
\noracle-xe depends on libaio (>= 0.3.96) | libaio1 (>= 0.3.96); however:
\nPackage libaio is not installed.
\nPackage libaio1 is not installed.
\ndpkg: error processing oracle-xe (–install):
\ndependency problems – leaving unconfigured
\nProcessing triggers for desktop-file-utils …
\nProcessing triggers for python-gmenu …
\nRebuilding \/usr\/share\/applications\/desktop.en_US.utf8.cache…
\nProcessing triggers for man-db …
\nProcessing triggers for ureadahead …
\nureadahead will be reprofiled on next reboot
\nProcessing triggers for python-support …
\nErrors were encountered while processing:
\noracle-xe
\nduanecato@ino:~\/downloads$ ^C<\/p>\n

As seen above, there is a dependency error for\u00a0 libaio – to resolve this I ran Synaptic, searched for the libaio packages, and installed the dev and shared libraries. I then reran the Oracle XE install:<\/p>\n

duanecato@ino:~\/downloads$ sudo dpkg -i –force-architecture oracle-xe_10.2.0.1-1.0_i386.deb<\/p>\n

dpkg: warning: overriding problem because –force enabled:
\npackage architecture (i386) does not match system (amd64)
\n(Reading database … 268769 files and directories currently installed.)
\nPreparing to replace oracle-xe 10.2.0.1-1.0 (using oracle-xe_10.2.0.1-1.0_i386.deb) …
\nUnpacking replacement oracle-xe …
\nSetting up oracle-xe (10.2.0.1-1.0) …
\nupdate-rc.d: warning: \/etc\/init.d\/oracle-xe missing LSB information
\nupdate-rc.d: see <http:\/\/wiki.debian.org\/LSBInitScripts>
\nExecuting Post-install steps…
\n-e You must run ‘\/etc\/init.d\/oracle-xe configure’ as the root user to configure the database.<\/p>\n

Processing triggers for desktop-file-utils …
\nProcessing triggers for python-gmenu …
\nRebuilding \/usr\/share\/applications\/desktop.en_US.utf8.cache…
\nProcessing triggers for man-db …
\nProcessing triggers for ureadahead …
\nProcessing triggers for python-support …<\/p>\n

As can be seen from above, the library dependency is now resolved, and I need to complete the configuration by running \/etc\/init.d\/oracle-xe configure as root:<\/p>\n

duanecato@ino:~\/downloads$ sudo \/etc\/init.d\/oracle-xe configure
\n[sudo] password for duanecato:<\/p>\n

Oracle Database 10g Express Edition Configuration
\n————————————————-
\nThis will configure on-boot properties of Oracle Database 10g Express
\nEdition.\u00a0 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.\u00a0 Press <Enter> 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.\u00a0 Note that the same
\npassword will be used for SYS and SYSTEM.\u00a0 Oracle recommends the use of
\ndifferent passwords for each database account.\u00a0 This can be done after
\ninitial configuration:
\nConfirm the password:<\/p>\n

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

Starting Oracle Net Listener…Done
\nConfiguring Database…Done
\nStarting Oracle Database 10g Express Edition Instance…Done
\nInstallation Completed Successfully.
\nTo access the Database Home Page go to “http:\/\/127.0.0.1:8080\/apex”
\nduanecato@ino:~\/downloads$<\/p>\n

I took the defaults for everything, and then verified access to the Oracle XE login page in Firefox:<\/p>\n\n\n\n
\n

\n

\"Oracle<\/a>

Oracle XE - Mozilla Firefox<\/p><\/div><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

I hope this quick post helps out others who want to do Oracle database development on 64-bit Linux, without going whole-hog on the full Enterprise install of 10G\/11G.<\/p>\n","protected":false},"excerpt":{"rendered":"

I wanted to install Oracle XE on my laptop to do some simple Oracle database modeling work, since it gives fairly complete Oracle database functionality without the space and configuration hassle of Enterprise 10G or 11G. However, After going to http:\/\/www.oracle.com\/technetwork\/database\/express-edition\/downloads\/102xelinsoft-102048.html to download the Debian (.deb) package, I discovered there that is no 64-bit version […]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[39,7],"tags":[],"class_list":["post-442","post","type-post","status-publish","format-standard","hentry","category-database","category-oracle"],"_links":{"self":[{"href":"https:\/\/otac.isa-geek.net\/blog\/index.php?rest_route=\/wp\/v2\/posts\/442","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/otac.isa-geek.net\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/otac.isa-geek.net\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/otac.isa-geek.net\/blog\/index.php?rest_route=\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/otac.isa-geek.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=442"}],"version-history":[{"count":1,"href":"https:\/\/otac.isa-geek.net\/blog\/index.php?rest_route=\/wp\/v2\/posts\/442\/revisions"}],"predecessor-version":[{"id":449,"href":"https:\/\/otac.isa-geek.net\/blog\/index.php?rest_route=\/wp\/v2\/posts\/442\/revisions\/449"}],"wp:attachment":[{"href":"https:\/\/otac.isa-geek.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=442"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/otac.isa-geek.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=442"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/otac.isa-geek.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=442"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}