gcc: /opt/oracle/product/10g/rdbms/lib32/defopt.o: No such file or directory

##</code><code>##

Can't load '/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/Oracle/Oracle.so: undefined symbol: kgefac_ at /usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230.
 at sql.pl line 3
Compilation failed in require at sql.pl line 3.
BEGIN failed--compilation aborted at sql.pl line 3.

##</code><code>##

G_BROKEN_FILENAMES --> 1
HISTSIZE --> 1000
HOME --> /opt/kpiadmin
HOSTNAME --> lsp1app124
INPUTRC --> /etc/inputrc
KDEDIR --> /usr
LANG --> en_US.UTF-8
LD_LIBRARY_PATH --> /opt/oracle/product/10g/lib
LESSOPEN --> |/usr/bin/lesspipe.sh %s
LOGNAME --> kpiadmin
LS_COLORS --> no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
MAIL --> /var/spool/mail/kpiadmin
OLDPWD --> /opt/kpiadmin/kevin/DBD-Oracle-1.27
ORACLE_BASE --> /opt/oracle
ORACLE_HOME --> /opt/oracle/product/10g
ORACLE_SID --> OEM10G
ORACLE_TERM --> xterm
PATH --> /opt/oracle/product/10g/bin:/usr/sbin:.:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/opt/kpiadmin/bin:/opt/kpiadmin/tools/bin
PWD --> /opt/kpiadmin/kevin
SHELL --> /bin/bash
SHLVL --> 1
SSH_ASKPASS --> /usr/libexec/openssh/gnome-ssh-askpass
SSH_CLIENT --> ::ffff:172.18.55.112 2145 22
SSH_CONNECTION --> ::ffff:172.18.55.112 2145 ::ffff:172.18.102.124 22
SSH_TTY --> /dev/pts/4
TERM --> xterm
USER --> kpiadmin
_ --> /usr/bin/perl