Oracle instaltion - Ubuntu7/Debian4

1. packages:

apt-get install gcc make binutils lesstif2 libc6 libc6-dev rpm libmotif3 libaio libstdc++5 alien

2. user:

$addgroup oinstall

$addgroup dba

$addgroup nobody

$useradd -g oinstall -G dba -p passwd -d /home/oracle -s /bin/bash oracle

$usermod -g nobody nobody

3. Directory

mkdir -p /opt/oracle

mkdir -p /opt/oracle

chown -R oracle:oinstall /opt/ora*

chmod -R 775 /opt/ora*

4. parameters

su oracle

cd /home/oracle

sudo nano ./.bashrc
# oracle 10g
export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0

#export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/Apache/Apache/bin:$PATH
export ORACLE_OWNER=oracle
export ORACLE_SID=orcl
export ORACLE_TERM=xterm

# Edit paths
#export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/opt/oracle/lib/stubs/:$LD_LIBRARY_PATH
export PATH=$ORACLE_HOME/bin:$PATH

$ e sysctl.conf
-----------------------
#Oracle Settings
#By Chenghaojun 2008-08-19 16.53
kernel.shmall = 2097152
kernel.shmmax = 3147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000

$ e limits.conf
---------------------
#By chenghaojun 2008-08-19 17.18
soft nproc 2047
hard nproc 16384
soft nofile 1024
hard nofile 65536

5. swap

$ dd if=/dev/zero of=tmp_swap bs=1k count=900000
$ chmod 600 tmp_swap
$ mkswap tmp_swap
$ swapon tmp_swap
release swap after installation:
$ swapoff tmp_swap
$ rm tmp_swap

6. soft-link

$ ln -s /usr/bin/awk /bin/awk
$ ln -s /usr/bin/rpm /bin/rpm
$ ln -s /usr/bin/basename /bin/basename

7. To be a faked Redhat

$ touch /etc/redhat-release
$ e /etc/redhat-release
-----------------------
#add below:
Red Hat Linux release 3.1 (drupal)

or use -ignoreSysPrereqs

8. installation

$ su oracle
$ cd /usr/repository/oracle/oracle
$ unzip oracle\ for\ linux32.zip
$ cd ./database
$ export LANG=en_US
to use root user set DISPLAY parameter to “:0.0”，then
$ xhost +
more info:

9. startup

#sqlplus:
oracle@administrator-desktop:/$ sqlplus "scott/tiger as sysdba"
#LSNRCTL
oracle@administrator-desktop:/$ lsnrctl
LSNRCTL> start

10. web access:
      

11. error:

#LSNRCTL
oracle@administrator-desktop:/$ lsnrctl
LSNRCTL> start
------------------------------------
Starting /app/oracle/10.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /app/oracle/10.2.0/db_1/network/admin/listener.ora
Log messages written to /app/oracle/10.2.0/db_1/network/log/listener_orcl.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=gprsint1.ke.celtel.com)(PORT=1521)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
TNS-12555: TNS:permission denied
TNS-12560: TNS:protocol adapter error

then:
oracle@administrator-desktop:/$ sudo chown -R -v oracle /var/tmp/.oracle
[sudo] password for oracle:
--------------------------------------
ownership of `/var/tmp/.oracle/s#9628.2' retained as oracle
ownership of `/var/tmp/.oracle/s#9654.1' retained as oracle
ownership of `/var/tmp/.oracle/s#9654.2' retained as oracle
ownership of `/var/tmp/.oracle/s#14765.2' retained as oracle
ownership of `/var/tmp/.oracle/sEXTPROC1' retained as oracle
ownership of `/var/tmp/.oracle/s#9628.1' retained as oracle
ownership of `/var/tmp/.oracle/sEXTPROC0' retained as oracle
ownership of `/var/tmp/.oracle/s#14765.1' retained as oracle
ownership of `/var/tmp/.oracle' retained as oracle
TNS-00525: Insufficient privilege for operation
Linux Error: 1: Operation not permitted

12. PL/SQL-like: