HOWTO install Oracle 10.2.0.1.0 on debian etch

Written by Jens Heine <binbash_at_gmx.net> 1 Jun 2007, last modified 1 Jun 2007 deepx.homelinux.net

Contents

1. What is this about?

2. How do I solve this?

3. Oracle environment

1. What is this about?

I want to install the current Oracle Database 10.2.0.1.0 on my debian linux. There are some extra things to do when you want to have success. The Howto describes only the extra-things to do beside the „normal“ oracle installation procedure. I will not describe howto create user/group etc. This has been done some time before :)

2. How do I solve this?

Set some kernel parameters in /etc/sysctl.conf:

# oracle stuff

kernel.shmall = 2097152

kernel.shmmax = 2147483648

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

fs.file-max = 65536

net.ipv4.ip_local_port_range = 1024 65000

Make shure that the folling packages are installed:

• fileutils (?)

• binutils

• libaio1

• gcc

• g++

• libstdc++5

Execute the following commands as root:

ln -s /usr/bin/basename /bin/basename

ln -s /usr/bin/awk /bin/awk

Execute the following commands as oracle user:

export LD_LIBRARY_PATH=$ORACLE_HOME/lib

ln -s $ORACLE_HOME/lib/libclient10.a $ORACLE_HOME/lib/libagtsh.a

$ORACLE_HOME/bin/genagtsh $ORACLE_HOME/lib/libagtsh.so 1.0

3. Oracle environment

You may use this script to generate a nice oracle environment:

#

# 20070429 Jens Heine <binbash_at_gmx.net>

#

# Oracle default environment

#

#

export ORACLE_HOME=/home/oracle/product/ora102

export ORACLE_SID=DBNAME

export ORACLE_TERM=xterm

export ORACLE_OWNER=oracle

export TNS_ADMIN=$ORACLE_HOME/network/admin

export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1

export ORA_NLS10=${ORACLE_HOME}/nls/data

export CLASSPATH=${CLASSPATH}:${ORACLE_HOME}/jdbc/lib/classes12.zip

export LD_LIBRARY_PATH=${ORACLE_HOME}/lib

export PATH=$ORACLE_HOME/bin:~/bin:$PATH

#

# export sqlpath

# This is like the PATH in bash only for sql scripts. We set it to the folder

# where all rhenus default sql scripts are located.

#

export SQLPATH=/home/oracle/tools:$ORACLE_HOME/rdbms/admin:$SQLPATH

#

# set oracle_sid into prompt

#

export PS1='\u:${ORACLE_SID}@\h:\w> '

alias cds='cd /home/oracle/tools'

alias cda='cd $ORACLE_HOME/admin/${ORACLE_SID}'

alias cdac='cd $ORACLE_HOME/admin/${ORACLE_SID}/create'

alias cdap='cd $ORACLE_HOME/admin/${ORACLE_SID}/pfile'

alias cdab='cd $ORACLE_HOME/admin/${ORACLE_SID}/bdump'

alias cdab='cd /software/oracle/admin/${ORACLE_SID}/bdump'

alias cdh='cd ${ORACLE_HOME}'

alias cdt='cd ${TNS_ADMIN}'

alias cdb='cd /opt/oracle/orabackup/${ORACLE_SID}/'

alias l='ls -lh'