Install Oracle XE On Debian 4

1. Download Oracle Database 10g Release 2 Express Edition for Linux x86
Web: http://www.oracle.com/technology/software/products/database/
Xe/htdocs/102xelinsoft.html

Download oracle-xe-universal_10.2.0.1-1.0_i386.deb

2. Run dpkg-I oracle-xe-universal _... deb after the download.
The installation may fail because the swap partition is too small. The solution is to increase the swap partition.
Dd if =/dev/zero of = swap bs = 1024 count = 16416
This command creates a 16 MB (16416 blocks) file exchange zone (called swap ).
Next, use the following command to physically create a file exchange zone:
Mkswap swap 16416
The number of swap areas should be the same as that above. Finally, run the following command to open the swap zone:
Swapon swap

3. Run/etc/init. d/oracle-xe configure after installation to perform initial configuration.
HTTP port [8080 by default]
TNS Listener port [1521 by default]
SYS/SYSTEM User Password
Start or not [yes]

4. manually create a database
1. Specify ORACLE_SID
Export ORACLE_SID = XE
2. Create initXE. ora
You can copy the default init. ora file and make some modifications.
Cd/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs
Cp init. ora initXE. ora
Change db_name in initXE. ora from DEFAULT to XE
Increase the value of shared_pool_size, which will be used later.
Modify the location of control_files to/mnt/hdb6/oradata /...
3. sqlplus/nolog
SQL> connect as sysdba
SQL> startup nomount

1 2 Next Page

[Content navigation]
Page 1st: Install Oracle XE On Debian 4	Page 2nd: Install Oracle XE On Debian 4