Install OracleXE in 64-bit javastuserver

Ubuntu version: uname-rLinuxlocalserver2.6.32-24-server #43-20.tusmpthusep1616: 05: 42UTC2010x86_64GNU/Linux install xe on a 64-bit system first install 32-bit Library: sudoapt-getinstalllibc6-i386 the next step is to download the required file: libaio_0.3.1

Ubuntu version:

Uname-r

Linux localserver 2.6.32-24-server # 43-Ubuntu SMP Thu Sep 16 16:05:42 UTC 2010 x86_64 GNU/Linux

To install xe on a 64-bit system, you must first install a 32-bit Library:

Sudo apt-get install libc6-i386

The next step is to download the desired files: libaio_0.3.104-1_i386.deb and Oracle-xe-universal_10.2.0.1-1.1_i386.deb

Wget-c http://oss.oracle.com/debian/dists/unstable/main/binary-i386/libaio_0.3.104-1_i386.deb http://oss.oracle.com/debian/dists/unstable/non-free/binary-i386/oracle-xe-universal_10.2.0.1-1.1_i386.deb

Installation:

Sudo apt-get install bc

Sudo dpkg-I -- force-architecture libaio_0.3.104-1_i386.deb
Sudo dpkg-I -- force-architecture oracle-xe-universal_10.2.0.1-1.1_i386.deb

The installation steps have been completed. Next is the Settings section

Sudo/etc/init. d/oracle-xe configure

Complete the settings as prompted.

Edit some environment variables: sudo vim/etc/profile

Add the following at the end of the file:

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

After completion, access http: // 127.0.0.1: 8080/apex to manage the database.

FAQ: xe cannot be accessed remotely.

Answer:

After Oracle XE is installed, you can access Oracle Application Express through http: // 127.0.0.1: 8080/apex. Oracle XE only listens to port 8080 of 127.0.0.1 by default, and cannot access the XE instance on another machine through a browser. If you need to access the XE instance on another machine, log on to the XE database as a system and run EXEC DBMS_XDB.SETLISTENERLOCALACCESS (FALSE );.

SQL> EXEC DBMS_XDB.SETLISTENERLOCALACCESS (FALSE );

The PL/SQL process is successfully completed.

SQL> exit