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