Oracle

From YobiWiki
Jump to navigation Jump to search

Oracle9i on Debian Etch

Get files from http://www.oracle.com/technology/software/products/oracle9i/htdocs/linuxsoft.html

gunzip ship_9204_linux_disk1.cpio.gz
gunzip ship_9204_linux_disk2.cpio.gz
gunzip ship_9204_linux_disk3.cpio.gz
cpio -idmv < ship_9204_linux_disk1.cpio
cpio -idmv < ship_9204_linux_disk2.cpio
cpio -idmv < ship_9204_linux_disk3.cpio

I burned a DVD with all three DiskN
Mount the DVD with exec rights:

mount /cdrom -o exec

I followed this doc (french) but there is also this one

mkdir /opt/oracle
addgroup oracle
adduser --ingroup oracle oracle
chown oracle:oracle /opt/oracle
chmod g+rwx /opt/oracle
mkdir /opt/oracle/OraHome
chown oracle:oracle /opt/oracle/OraHome/
chmod g+rwx /opt/oracle/OraHome/
apt-get install libc6 libc6-dev make binutils gcc libstdc++2.10-glibc2.2 libstdc++2.10-dev xlibs

I had hard time finding libstdc++2.9-glibc2.1, I got it finally from here

ln -s /usr/bin/awk /bin/awk
ln -s /usr/bin/sort /bin/sort
ln -s /usr/bin/basename /bin/basename
ls -l /usr/bin/gcc
ln -sf /usr/bin/gcc-2.95 /usr/bin/gcc
unset LANG
unset LC_ALL
unset LC_CTYPE
export LC_TYPE=en_US
export ORACLE_BASE=/opt/oracle
export ORACLE_SID=dbname
sysctl kernel.sem
sysctl -w kernel.sem="250 32000 100 128"
sysctl kernel.shmall
sysctl kernel.shmmax
sysctl -w kernel.shmmax=512000000
sysctl kernel.shmmni
cat /proc/sys/fs/file-max 
ulimit -n
ulimit -n 65536
ulimit -u
ulimit -u 16386
ulimit -f
export JAVA_HOME=/usr/lib/jvm/java-1.5.0-sun

When trying to launch the installer I got the error

Unable to load native library: /tmp/OraInstall2003-10-25_03-14-57PM/jre/lib/i386/libjava.so:
   symbol __libc_wait, version GLIBC_2.0 not defined in file libc.so.6 with link time reference

as described here so I took the patch (it's part of this zip) and I ran rhel3_pre_install.sh
Finally I got the installer GUI :-)
I ran it as the new oracle user, this means the local user had to give access to the X11 (xhost local:) and I had to export in the env of the user oracle the following:

export DISPLAY=:0.0
  • Oracle Database / Enterprise edition / General Purpose / dba? -> root