23 июня 2015

32-bit Oracle 11g in Slackware 14.1

Installing software

  • download Oracle 11g binaries from oracle.com
  • copy 32-bit version of libstdc++.so.5.0.7 to /usr/lib/
  • create link /usr/lib/libstdc++.so.5 to /usr/lib/libstdc++.so.5.0.7
  • create link /lib/libgcc_s.so.1 to /usr/lib/libgcc_s.so.1
  • create user oracle with single group users
  • switch to user oracle and unpack downloaded parts of Oracle 11g
  • merge them in single directory database
  • execute runInstaller
  • select Install database sofware only, do not install Enterprise manager
  • ignore all checks and prerequisites
  • during installation there will be one error when compiling emdctl, ignore it and continue

Creating database

  • setup several variables for oracle user
cat /home/oracle/.bashrc
export ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_1
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
export PATH=$PATH:$ORACLE_HOME/bin
  • run dbca command and setup DB options
  • edit /etc/oratab - switch N to Y
Now you should be able to start and stop oracle instanse from user oracle with these commands:
dbstart $ORACLE_HOME
dbshut $ORACLE_HOME