Connection to Database failed through perl

Hi,

We installed TeamSite 6.7.1 SP1 in Solaris 10 and migrated the contents into this server.After the migration,everything seems to be working fine.
We have a scenario,in which the ipl(perl) file is called in an TPL.
So when the user clicks the generate button the ipl is called and connects to the DB to make an entry of the generated HTML file name in the DB.

This work fine when the ipl file is executed through the command promt.But not through the TPL.When i click the generate button it calls the ipl but it fails when the connection to the DB line is executed.
It shows the following error..

"install_driver(Oracle) failed: Can't load '/app/mass1/teamsite/iw-home/iw-perl/site/lib/auto/DBD/Oracle/Oracle.so' for module DBD: Smiley Surprised

racle: ld.so.1: perl: fatal: libclntsh.so.9.0: open failed: No such file or directory at /app/mass1/teamsite/iw-home/iw-perl/lib/DynaLoader.pm line 229.
at (eval 2) line 3
Compilation failed in require at (eval 2) line 3.
Perhaps a required shared library or dll isn't installed where expected
at /app/mass1/teamsite/iw-home/iw-perl/bin/hottopics.pl line 59"..

I went through the forums and found that we need to set the ENV variables.In my coding i added the lines of code to set the ENV variables in the beginning of the perl file.

BEGIN
{
$ENV{'ORACLE_HOME'}='value1';
$ENV{'LD_LIBRARY_PATH'}='value2';
$ENV{'TNS_ADMIN'}='value3';
};

Still it is not working.

Please suggest to resolve the issue.

Thanks
Vasanthi P

Find more posts tagged with

Comments

Adam Stoller

Are you sure you're using the same version of Perl when you run the command from the command line?
The error is clearly from iwperl (or something which includes the iwperl library directories in @INC) - but if you run: perl script_name from the command line then you might be getting a different Perl and it might be that you have the Oracle DBD installed for that Perl and not for iwperl.

I'm also confused about the error regarding a missing dll - it's been a while since I've been on a Unix implementation, but I thought dll's were a Windows thing. It also looks like there's a problem accessing libclntsh.so.9.0 - which might be a more significant error.

I suggest having your script dump out ALL of its environment variables (near the beginning of the script) - and run the script both ways (from command line and from PT) and compare the output - you may need to include other entries in your BEGIN block (I'm assuming that value1, value2, and value3 are complete and properly [Unix] formatted values for the environment variables you are setting - yes?)

vasanthi

Hi Ghoti,

Thanks for your reply.

I tried changing the perl exe path and executed the ipl file in the command prompt..But i got the same error.If the perl exe path is /iw-home/iw-perl/bin/iwperl,then the perl is executed from the command promt.So i guess that the DBD module is installed for the iwperl.

Also i removed all the ENV variables in the BEGIN block of the ipl and tried executing with both command prompt and through tpl template file.Since the ENV variables in UNIX is set for the user by default,it executes in command prompt but not through tpl.I have given the correct values in the ENV variables for ORACLE_HOME.Please advice.

Thanks,
Vasanthi

Adam Stoller

...
Also i removed all the ENV variables in the BEGIN block of the ipl and tried executing with both command prompt and through tpl template file.Since the ENV variables in UNIX is set for the user by default,it executes in command prompt but not through tpl.I have given the correct values in the ENV variables for ORACLE_HOME.Please advice.

I didn't say to remove them - I said compare the differences between both sets of environment variables and go through a process of elimination - e.g.: Take the complete list of ENV settings from the command prompt and hard-code them into your script in the BEGIN block. If the script still doesn't work when called from within FormsPublisher you've got a more significant issue. My guess is that it will work.

Assuming that works, start commenting out the lines in the BEGIN block and re-trying it from FormsPublisher - when you find that the most recently commented-out line stops the script from working, un-comment it and continue the process by commenting the line below it, etc.

When all is said and done, you should be able to remove completely all the commented-out lines, leaving you with N ENV settings in your BEGIN block.

At this point, if any of those entries contain multiple values (comma-separated, semi-colon-separated, etc.) you can go through the same process of elimination by trimming down those component values. Eventually you should arrive at the absolute minimum set of ENV and ENV-values you need to set in the script in order for it to work when called from FormsPublisher.

As a good forum netizen - you can then post the final settings used and close the thread.

stackedBarChart.png

DavidHugenberg

Hi Ghoti,

Thanks for your reply.

I tried changing the perl exe path and executed the ipl file in the command prompt..But i got the same error.If the perl exe path is /iw-home/iw-perl/bin/iwperl,then the perl is executed from the command promt.So i guess that the DBD module is installed for the iwperl.

Also i removed all the ENV variables in the BEGIN block of the ipl and tried executing with both command prompt and through tpl template file.Since the ENV variables in UNIX is set for the user by default,it executes in command prompt but not through tpl.I have given the correct values in the ENV variables for ORACLE_HOME.Please advice.

Thanks,
Vasanthi

Do you have PerlDBD installed or just copied from the old server?
# /app/iw-home/iw-perl/bin/iwperl Makefile.PL
# make
# make test
# make install

It looks like you have the oracle client installed. Did the path of the old client change after you built the new server? If so you will have to recompile the perl DBD.

Assuming the path is the same and the oracle version is the same, check your permissions on the ld.so files.

You may also want to create a simple perl test file like the one in the URL below. Under 5) Test. Be sure to change from #!/usr/bin/perl to #!app/mass1/teamsite/iw-home/iw-perl in the example. If you get this running from the cmdln your perl DBD is installed correctly.

http://duberga.net/dbd_oracle_instantclient_linux/

Dave