Differences
This shows you the differences between two versions of the page.
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]] | ||
+ | |||