Issue installing DBD::Oracle 1.16 module on 64 bit linux

Hi Friends,

I'm facing an issue while installing the DBD: Smiley Surprised

racle on 64 bit linux. I'm installing this for iwperl. I'm getting the following error while doing so.

install_driver(Oracle) failed: Can't load '/autonomy/TS6.7.2Installable/DBD-Oracle-1.16/blib/arch/auto/DBD/Oracle/Oracle.so' for module DBD: Smiley Surprised

racle: /autonomy/TS6.7.2Installable/DBD-Oracle-1.16/blib/arch/auto/DBD/Oracle/Oracle.so: cannot open shared object file: No such file or directory at /Interwoven/TeamSite/iw-perl/lib/DynaLoader.pm line 229.
at (eval 1) line 3

Please see the environment and version details below.

TS: 6.7.2 SP2
DBD:: DBI: 1.38
DBD:: Oracle: 1.16
Linux: RHEL 5.3 64 bit
OracleClient: 10g 64 bit

Steps followed for installing the DBD: Smiley Surprised

racle.

Login to linux as
root
.
Download and extract the
DBD-Oracle-1.16.zip
from cpan website.
Set and export the perl path to
export PATH=/Interwoven/TeamSite/iw-perl/bin/:${PATH}
Set and export the oracle home to
export ORACLE_HOME=/opt/oracle/current.
Set and export the oracle library path to
export LD_LIBRARY_PATH=$ORACLE_HOME/lib32.
Check that all the paths have been set correctly by issuing the
echo
command.
Navigate to the directory /autonomy/TS6.7.2Installable/DBD-Oracle-1.16
Run
/Interwoven/TeamSite/iw-perl/bin/iwperl Makefile.PL
Run
make
Run
make test
[color=Red][font=Verdana][color=Black]The above error comes
.
make test
fails.
[/color][/color][/font]

We've looked over internet and checked support

articles regarding the same. However, nothing helped. It would be great if you can provide your inputs on the same.

Find more posts tagged with

Comments

jagadesh

Hi Friends,

I'm facing an issue while installing the DBD:racle on 64 bit linux. I'm installing this for iwperl. I'm getting the following error while doing so.

install_driver(Oracle) failed: Can't load '/autonomy/TS6.7.2Installable/DBD-Oracle-1.16/blib/arch/auto/DBD/Oracle/Oracle.so' for module DBD:racle: /autonomy/TS6.7.2Installable/DBD-Oracle-1.16/blib/arch/auto/DBD/Oracle/Oracle.so: cannot open shared object file: No such file or directory at /Interwoven/TeamSite/iw-perl/lib/DynaLoader.pm line 229.
at (eval 1) line 3

Please see the environment and version details below.

TS: 6.7.2 SP2
DBD:: DBI: 1.38
DBD:: Oracle: 1.16
Linux: RHEL 5.3 64 bit
OracleClient: 10g 64 bit

Steps followed for installing the DBD:racle.

Login to linux as
root
.
Download and extract the
DBD-Oracle-1.16.zip
from cpan website.
Set and export the perl path to
export PATH=/Interwoven/TeamSite/iw-perl/bin/:${PATH}

Set and export the oracle home to
export ORACLE_HOME=/opt/oracle/current.

Set and export the oracle library path to
export LD_LIBRARY_PATH=$ORACLE_HOME/lib32.

Check that all the paths have been set correctly by issuing the
echo
command.
Navigate to the directory /autonomy/TS6.7.2Installable/DBD-Oracle-1.16
Run
/Interwoven/TeamSite/iw-perl/bin/iwperl Makefile.PL

Run
make

Run
make test

[color=Red][font=Verdana][color=Black]The above error comes
.
make test
fails.
[/color][/color][/font]
We've looked over internet and checked support
articles regarding the same. However, nothing helped. It would be great if you can provide your inputs on the same.

You should follow the below steps to achieve instead of ur Step 8 to Step 11

Login to linux as
root
.
Download and extract the
DBD-Oracle-1.16.zip
from cpan website.
Set and export the perl path to
export PATH=/Interwoven/TeamSite/iw-perl/bin/:${PATH}
Set and export the oracle home to
export ORACLE_HOME=/opt/oracle/current.
Set and export the oracle library path to
export LD_LIBRARY_PATH=$ORACLE_HOME/lib32.
Check that all the paths have been set correctly by issuing the
echo
command.
Navigate to the directory /autonomy/TS6.7.2Installable/DBD-Oracle-1.16
/iw-home/iw-perl/bin/iwperlcc Makefile.PL PREFIX=/var/tmp/lib
/iw-home/iw-perl/bin/iwperl -pi -e 's/oracle_home\/lib/oracle_home\/lib32/g' Makefile
/iw-home/iw-perl/bin/iwperl -pi -e 's/oracle_home\/rdbms\/lib/oracle_home\/rdbms\/lib32/g' Makefile
make
make test
make install

Note: Make necessary change as per your Oracle_Home

kissthedevil

You should follow the below steps to achieve instead of ur Step 8 to Step 11

Login to linux as
root
.
Download and extract the
DBD-Oracle-1.16.zip
from cpan website.
Set and export the perl path to
export PATH=/Interwoven/TeamSite/iw-perl/bin/:${PATH}

Set and export the oracle home to
export ORACLE_HOME=/opt/oracle/current.

Set and export the oracle library path to
export LD_LIBRARY_PATH=$ORACLE_HOME/lib32.

Check that all the paths have been set correctly by issuing the
echo
command.
Navigate to the directory /autonomy/TS6.7.2Installable/DBD-Oracle-1.16
/iw-home/iw-perl/bin/iwperlcc Makefile.PL PREFIX=/var/tmp/lib
/iw-home/iw-perl/bin/iwperl -pi -e 's/oracle_home\/lib/oracle_home\/lib32/g' Makefile
/iw-home/iw-perl/bin/iwperl -pi -e 's/oracle_home\/rdbms\/lib/oracle_home\/rdbms\/lib32/g' Makefile
make
make test
make install
Note: Make necessary change as per your Oracle_Home

Hi Jagadesh,

Tried to

the

/var/tmp/lib

directory. But didn't find the

/lib

under the

/var/tmp

.

Getting the following error when running step 8 and step 9.

[root@lnx DBD-Oracle-1.16]# iwperlcc Makefile.PL PREFIX=/var/tmp/lib
/Interwoven/TeamSite/iw-perl/bin/iwperlcc: using Makefile.PL as input file, ignoring PREFIX=/var/tmp/lib
/usr/bin/ld: skipping incompatible /Interwoven/TeamSite/iw-perl/lib/CORE/libperl.a when searching for -lperl
/usr/bin/ld: cannot find -lperl
collect2: ld returned 1 exit status

[root@lnx DBD-Oracle-1.16]# iwperl -pi -e 's/opt/oracle/current\/lib/opt/oracle/current\/lib32/g' Makefile
Bareword found where operator expected at -e line 1, near "s/opt/oracle/current"
Backslash found where operator expected at -e line 1, near "urrent\"
Bareword found where operator expected at -e line 1, near "/lib/opt"
(Missing operator before pt?)
Backslash found where operator expected at -e line 1, near "current\"
syntax error at -e line 1, near "s/opt/oracle/current"
Execution of -e aborted due to compilation errors.

jagadesh

Tried to cd the /var/tmp/lib directory. But didn't find the /lib under the /var/tmp.

Its Temporary directory to hold execution files. No probs. u can point to any other directory as well. But it should be temp

iwperl -pi -e 's/opt/oracle/current\/lib/opt/oracle/current\/lib32/g' Makefile

You should pass like this 's/opt\/oracle\/current\/lib/opt\/oracle\/current\/lib32/g' Bcoz / use as regex separator

skipping incompatible /Interwoven/TeamSite/iw-perl/lib/CORE/libperl.a when searching for -lperl

Even I am not sure on the above. Try it once again if you face the same issue then let us know.

kissthedevil

I'm facing the same error repeatedly. Also it does not generate Makefile for the next set of commands.

[root@lnx DBD-Oracle-1.16]# iwperlcc Makefile.PL PREFIX=/var/tmp/
/Interwoven/TeamSite/iw-perl/bin/iwperlcc: using Makefile.PL as input file, ignoring PREFIX=/var/tmp/
/usr/bin/ld: skipping incompatible /Interwoven/TeamSite/iw-perl/lib/CORE/libperl.a when searching for -lperl
/usr/bin/ld: cannot find -lperl
collect2: ld returned 1 exit status

Adam Stoller

My first suggestion is to carefully look through all the README files that come with the module - there's a whole bunch of information there.

Secondly, I'd verify that iwperl is 32-bit (I believe you should be able to do so by using the file command) - as such, you will probably need to make sure that you're building a 32-bit version of the library/modules (which is, I believe, what jagadesh's regex's were for)

I'm not sure why one would use iwperlcc as opposed to iwperl - the one time I had to build these modules on Solaris (years ago) - I just used iwperl to construct the Makefile - but I did have to go through a bunch of contortions with regard to getting the linker and assembler to be referenced correctly for gcc (as I recall, Solaris kept trying to run something like /usr/ccbin/as with the Gnu assembler's command line arguments - so we had to move the existing assembler out of the way and symbolically link /usr/local/bin/gas in to its place)

brvhrt

well, i have a similar issue but not with installing the DBD: Smiley Surprised

racle but when trying to run a perl script ( it could be the installation was done incorrectly too.. i didnt do it though)

[root@localhost Desktop]# ./dbtest.pl
install_driver(Oracle) failed: Can't load '/apps/iw-home/iw-perl/site/lib/auto/DBD/Oracle/Oracle.so' for module DBD: Smiley Surprised

racle: /apps/iw-home/iw-perl/site/lib/auto/DBD/Oracle/Oracle.so: wrong ELF class: ELFCLASS64 at /apps/iw-home/iw-perl/lib/DynaLoader.pm line 229.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected

[root@localhost Desktop]# echo $LD_LIBRARY_PATH
/usr/lib/oracle/xe/oracle/product/10.2.0/db_1/lib32
[root@localhost Desktop]# echo $ORACLE_HOME
/usr/lib/oracle/xe/oracle/product/10.2.0/db_1

one thing i noticed is that after i close the terminal session and open a new open $ORACLE_HOME and $LD_LIBRARY_PATH get erased ??

[root@localhost ~]# echo $ORACLE_HOME

[root@localhost ~]# echo $LD_LIBRARY_PATH

kissthedevil

Hi guys,

Found a solution for the same.

&amp;amp;lt;!-- /* Font Definitions */ @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:1; mso-generic-font-family:roman; mso-font-format Smiley Surprised

ther; mso-font-pitch:variable; mso-font-signature:0 0 0 0 0 0;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-1610611985 1073750139 0 0 159 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman","serif"; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin;} .MsoChpDefault {mso-style-type:export-only; mso-default-props:yes; font-size:10.0pt; mso-ansi-font-size:10.0pt; mso-bidi-font-size:10.0pt;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.0in 1.0in 1.0in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page Smiley Frustrated

ection1;} --&amp;amp;gt;

Please see the attachment. Don't know

[font=Arial][/font] this forum is not allowing me to add that.