Installing oracle 9i on woody,

I. DEBIAN GNU/LINUX ENVIRONMENT SETUP Steps to perform as root for setting up Oracle installation environment: a. Create oracle group, user and home directory.
addgroup dba
adduser --home /ora --no-create-home --ingroup dba oracle
chown oracle.dba /ora
mkdir /ora/9iR2
chown oracle.dba /ora/9iR2
b. Create links needed by Oracle installer.
ln -s /usr/bin/awk /bin/awk
ln -s /usr/bin/sort /bin/sort
ln -s /usr/bin/basename /bin/basename
c. Install mandatory packages.
apt-get install make binutils gcc libstdc++2.10-glibc2.2 libstdc++2.10-dev libstdc++2.9-glibc2.1

If exim isn't in your Woody installation (dpkg -l | grep exim ) you should install some decent smtp server apt-get install postfix Now check versions of development environment perl -v This is perl, v5.6.1 built for i386-linux gcc -v Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs gcc version 2.95.4 20011002 (Debian prerelease) ld -V GNU ld version 2.12.90.0.1 20020307 Debian/GNU Linux Supported emulations: elf_i386 i386linux uname -a Linux puigsuris 2.4.20-686 #1 SMP Fri Jan 10 14:39:43 CET 2003 i686 unknown d. Reconfigure Locales with en_US and unicoded en_US, then use LC_TYPE for root user. dpkg-reconfigure locales then select en_US ISO-8859-1 en_US.UTF-8 UTF-8 unset LANG unset LC ALL export LC_CTYPE=en_US e. Create 1GB swap file if needed. dd if=/dev/zero of=/ora/tmpswap bs=1k count=1024000 chmod 600 /ora/tmpswap mkswap /ora/tmpswap swapon -v /ora/tmpswap remember to disable and delete upon installation of Oracle. swapoff /ora/tmpswap rm /ora/tmpswap f. Check and Setup Kernel Semaphore parameters. sysctl kernel.sem (alternative method cat /proc/sys/kernel/sem ). kernel.sem = 250 32000 32 128 Values SEMMSL SEMMNS SEMOPM SEMMNI As Oracle release notes SEMOPM should be 100 at least, so setup it. sysctl -w kernel.sem="250 32000 100 128" and put permanently at boot time. echo "kernel.sem=250 32000 100 128" >> /etc/sysctl.conf sysctl kernel.shmall kernel.shmall = 2097152 leave as default sysctl kernel.shmmax Again as release notes should be at least one half of RAM, so setup it. sysctl -w kernel.shmmax=`expr \( 512 \/ 2 \) \* 1024 \* 1024` and put at boot time echo "kernel.shmmax=`expr \( 512 \/ 2 \) \* 1024 \* 1024`" >> /etc/sysctl.conf sysctl kernel.shmmni 4096 at least 100 echo 65536 > /proc/sys/fs/file-max ulimit -n 65536 ulimit -u 16384 ulimit -f unlimited III. ORACLE INSTALLATION Steps to perform as oracle user to start Oracle Universal Installer. xauth list | grep localdom (to get MIT-MAGIC-COOKIE of X window current user) su - oracle (or directly sux - oracle) export DISPLAY=:0.0 xauth add $DISPLAY MIT-MAGIC-COOKIE-1 PASTE MAGIC-COOKIE STRING cd /ora Decompress downloaded installation system gunzip *.gz cpio -idmv < lnx_920_disk1.cpio; cpio -idmv < lnx_920_disk2.cpio; cpio -idmv < lnx_920_disk3.cpio Alternatively you shoud mount your Oracle cd. Setup environment variables export ORACLE_BASE=/ora export ORACLE_HOME=$ORACLE_BASE/9iR2 export ORACLE_TERM=xterm export ORACLE_SID=compiere export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib export PATH=$PATH:$ORACLE_HOME/bin export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib export LC_LANG=en_US export LC_ALL=en_US unset LANG If your /tmp dir doesn't have 500MB you shoud create one mkdir /ora/tmp and export variables export TEMP=/ora/tmp export TMPDIR=/ora/tmp Cross your fingers, read random fortune quote, read random king james bible's verse and type: ./Disk1/runInstaller First installation screens shoud appear. Then asks for oraInventory destination Unix Group Name dba Open a root shell window and perform script /tmp/orainstRoot.sh File locations and $ORACLE_HOME destination Product to install Oracle9i Database 9.2.0.1.0 Installation of Custom type Product Components to install ------------------------------------------------------------------- Oracle9i (mandatory for Compiere) 9.2.0.1.0 Oracle Net Services (mandatory for Compiere) Oracle9i Development Kit (optional) Oracle JDBC/OCI Interfaces (mandatory for Compiere) ------------------------------------------------------------------- Component Locations OSDBA and OSOPER is dba group We want to create a database Summary and start of Installation... When install is about to 100% and before linking starts, due to: /lib/libdl.so.2: undefined reference to `_dl_addr@GLIBC_PRIVATE' that appears as Error in invoking target install of makefile $ORACLE_HOME/ctx/lib/ins_ctx.mk We need to edit vi $ORACLE_HOME/ctx/lib/env_ctx.mk as oracle user And add $(LDLIBFLAG)dl to "INSO_LINK =" and leave line as: INSO_LINK = -L$(CTXLIB) $(LDLIBFLAG)m $(LDLIBFLAG)dl $(LDLIBFLAG)sc_ca $(LDLIBFLAG)sc_fa $(LDLIBFLAG)sc_ex $(LDLIBFLAG)sc_da $(LDLIBFLAG)sc_ut $(LDLIBFLAG)sc_ch $(LDLIBFLAG)sc_fi $(LLIBCTXHX) $(LDLIBFLAG)c -Wl,-rpath,$(CTXHOME)lib $(CORELIBS) $(COMPEOBJS) Finished linking run on the root shell window the script /ora/9iR2/root.sh Start of configuration tools: Net Configuration Assistant (netca) Defer of directory service setup Listener name: LISTENER TCP Protocol 1521 Port No more listeners, complete! Defer of naming methods setup, so completely complete! Start of Database Configuration Assistant (dbca) and Wellcome to creating a New data base Global Database Name (TNS) compiere.compiere.org SID compiere

| Installing oracle 9i on woody, | | 2004.02.12-20:54.00

 You are scrupulously honest, frank, and straightforward. Therefore you have few friends.