Oracle 9i on Mandrake 8.1

Installing Oracle 9i on Mandrake 8.1

Installing oracle 9i on Mandrake is a little more complex than on other distributions due to the version on binutils that comes with mandrake, however this is easily got round.

To install you need

• Oracle 9i disks (downloadable oracle technet at http://otn.oracle.com)
• Lots of disk space 2-3 gb
• A Java machine e.g. Sun 1.3.1 from http://java.sun.com
• Binutils 2.10 tar from any gnu mirror http://see www.gnu.org
• Oracle quick install guide for linux

You should be able to follow the oracle quick install guide for linux except for the following issues

Binutils

Mandrake comes with binutils 2.11 which is incompatible with Oracles installer. To fix this simply extract Binutils using

• tar -xzvf binutils-2.10.1.tar.gz
• cd binutils-2.10.1
• ./configure
• make
• as root - make install

This will install binutils in /usr/local/bin (this is delibrate). If any of these steps fail you are probably missing some development libraries. The error message should give you a clue. Next as root

• cd /usr/bin
• mv ld ld.new
• cp /usr/local/bin/ld ./

This temporarily replaces ld 2.11 with ld 2.10

Java

If you do not have the sun JVM simply get the RPM version from java.sun.com and run the binary.

• j2sdk-1_3_1_01-linux-i386-rpm.bin

This will extract the JVM rpm to install use

• rpm -ivh j2sdk-1_3_1_01-linux-i386.rpm

You may want to add Java to the path.

Install it

Once this is done simply run the oracle installer as the oracle user (see the oracle install guide). You can put oracle anywhere you like I suggest /opt/oracle/

Post Install Issues

Java Support

The oracle installer does not set up a listener for JVM in the database edit your $ORACLE_HOME/network/admin/listener.ora. You need to add the section about GIOP (be careful about brakets).

 # LISTENER.ORA Network Configuration  File: /opt/oracle/product/9.0.1/network/admin/listener.ora
 # Generated by Oracle configuration tools.

LISTENER =

  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = YOUR_HOSTNAME)(PORT = 1521))
      )
    )
    (DESCRIPTION =
      (PROTOCOL_STACK=
       (PRESENTATION = GIOP)
 (SESSION = RAW)
      )
      (ADDRESS = (PROTOCOL = TCP) (HOST =  YOUR_HOSTNAME )(PORT = 2481))
     )
    )

SID_LIST_LISTENER =

  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /opt/oracle/product/9.0.1)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = YOURDB.WORLD)
      (ORACLE_HOME = /opt/oracle/product/9.0.1)
      (SID_NAME = YOURDB)
    )
  )

Test this by runing 'lsnrctl stop' then 'lsnrctl start'

Setting up a service

You need to copy dbora from $ORACLE_HOME/bin to /etc/rc.d/init.d Then run ksysv to configure it to start at runlevel 3 and stop at run level 2 Edit the /etc/oratab and put Y next to any DB instances you want to start on boot.

Restoring Binutils

If you want your system to work as intended by Mandrake you need to restore ld from binutils 2.11 so as root

• cd /usr/bin
• mv ld.new ld

Any questions etc you can Contact me. If you have problems I suggest looking at the Oracle 9i on Unix manual as this has tons of information in it.

Oracle Community Forums

http://www.orafaq.com/