Differences

This shows you the differences between two versions of the page.

Link to this comparison view

tech:others:oracle_install [2014/11/15 09:13]
tech:others:oracle_install [2014/11/15 09:13] (current)
Line 1: Line 1:
 +====== Oracle Install on Ubuntu 64-bit ======
 +Steps to install Oracle on the Ubuntu 64-bit server
 +
 +===== Swap space =====
 +Oracle needs swap space of 1GB defined. Here is a [[https://​help.ubuntu.com/​community/​SwapFaq|link]] to steps for creating it
 +
 +Steps to create swap space
 +<​code>​
 +dd if=/​dev/​zero of=/​mnt/​5120MB.swap bs=1M count=5120
 +mkswap /​mnt/​5120MB.swap
 +swapon /​mnt/​5120MB.swap
 +vim /etc/fstab
 +add line: /​mnt/​5120MB.swap ​ none  swap  sw  0 0
 +</​code>​
 +
 +===== Oracle install steps =====
 +<​code>​
 +apt-get update
 +apt-get install libc6-i386
 +wget "​http://​oss.oracle.com/​debian/​dists/​unstable/​main/​binary-i386/​libaio_0.3.104-1_i386.deb"​
 +wget "​http://​oss.oracle.com/​debian/​dists/​unstable/​non-free/​binary-i386/​oracle-xe-universal_10.2.0.1-1.1_i386.deb"​
 +dpkg -i --force-architecture libaio_0.3.104-1_i386.deb
 +dpkg -i --force-architecture oracle-xe-universal_10.2.0.1-1.1_i386.deb
 +/​etc/​init.d/​oracle-xe configure
 +</​code>​
 +
 +===== Install Configuration log =====
 +<​code>​
 +root@ub1:/​tmp#​ /​etc/​init.d/​oracle-xe configure
 +
 +Oracle Database 10g Express Edition Configuration
 +-------------------------------------------------
 +This will configure on-boot properties of Oracle Database 10g Express
 +Edition. ​ The following questions will determine whether the database should
 +be starting upon system boot, the ports it will use, and the passwords that
 +will be used for database accounts. ​ Press <​Enter>​ to accept the defaults.
 +Ctrl-C will abort.
 +
 +Specify the HTTP port that will be used for Oracle Application Express [8080]:
 +
 +Specify a port that will be used for the database listener [1521]:
 +
 +Specify a password to be used for database accounts. ​ Note that the same
 +password will be used for SYS and SYSTEM. ​ Oracle recommends the use of
 +different passwords for each database account. ​ This can be done after
 +initial configuration:​
 +Confirm the password:
 +
 +Do you want Oracle Database 10g Express Edition to be started on boot (y/n) [y]:
 +
 +Starting Oracle Net Listener...Done
 +Configuring Database...Done
 +Starting Oracle Database 10g Express Edition Instance...Done
 +Installation Completed Successfully.
 +To access the Database Home Page go to "​http://​127.0.0.1:​8080/​apex"​
 +</​code>​
 +
 +===== Config files =====
 +  * /​etc/​default/​oracle-xe
 +  * /etc/oratab
 +
 +===== Post install and configure =====
 +edit your ~/.bashrc
 +
 +<code bash>
 +ORACLE_HOME=/​usr/​lib/​oracle/​xe/​app/​oracle/​product/​10.2.0/​server
 +PATH=$PATH:​$ORACLE_HOME/​bin
 +export ORACLE_HOME
 +export ORACLE_SID=XE
 +export PATH
 +</​code>​
 +
 +Oracle user's home directory: /​usr/​lib/​oracle/​xe
 +
 +===== Other references =====
 +[[http://​www.oracle.com/​technology/​tech/​linux/​install/​xe-on-kubuntu.html|Oracle Install]]
 +
 +[[http://​littlebrain.org/​2008/​05/​12/​how-to-install-oracle-xe-in-ubuntu-64-bit/​|How To Install Oracle XE in Ubuntu 64 Bit]]
 +
  

QR Code
QR Code tech:others:oracle_install (generated for current page)