Install Oracle XE In 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

4. Create a database
Create database ora10
Logfile group 1 ('/mnt/hdb6/oradata/redo1.log') size 10 M,
Group 2 ('/mnt/hdb6/oradata/redo2.log') size 10 M,
Group 3 ('/mnt/hdb6/oradata/redo3.log') size 10 M
Character set...
National character set...
Datafile '/mnt/hdb6/oradata/system. dbf'
Size 50 M
Autoextend on
Next 10 M maxsize unlimited
Extent management local
Sysaux datafile '/mnt/hdb6/oradata/sysaux. dbf'
Size 10 M
Autoextend on
Next 10 M
Maxsize unlimited
Default temporary tablespace temp
Tempfile '/mnt/hdb6/oradata/temp. dbf'
Size 10 M;

5. Run catalog. SQL and catproc. SQL.
SQL> @? /Rdbms/admin/catalog. SQL
SQL> @? /Rdbms/admin/catproc. SQL
Catalog. SQL creates the data dictionary.
Catproc. SQL creates all structures required for PL/SQL.

6. Create a user tablespace
Create tablespace users
Datafile '/mnt/hdb6/oradata/users. dbf' size 50 M
Extent management local;

7. Create a user
Create user dis
Identified by "dis"
Default tablespace users;

8. Authorize the user
Grant dba to dis;