DBD:Oracle question

--_206a212c-aaab-4588-87c5-efcc130073b3_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hello,

I have perl program which connects to the Oracle DB. It seems to run fine w=
hen i run it from its directory. But when i set up the program as a CRON JO=
B it fails to run.
Tries to execute but gives this error and quits -

------------------------------------------------------------ ---------------=
----------------
Can't load '/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto /DBD=
/Oracle/Oracle.so' for module DBD::Oracle: libocci.so.10.1: cannot open sha=
red object file: No such file or directory at /usr/lib/perl5/5.8.5/i386-lin=
ux-thread-multi/DynaLoader.pm line 230.
at /home/kiran/projects/ORACLE_TO_MYSQL_table_copy/subject_form /copy_subjF=
ormTable_fromOraToMysql.pl line 5
Compilation failed in require at /home/kiran/projects/ORACLE_TO_MYSQL_table=
_copy/subject_form/copy_subjFormTable_fromOraToMysql.pl line 5.
BEGIN failed--compilation aborted at /home/kiran/projects/ORACLE_TO_MYSQL_t=
able_copy/subject_form/copy_subjFormTable_fromOraToMysql.pl line 5.
------------------------------------------------------------ ---------------=
-----------------


I do have the Oracle.so shared library file in the location specified above=
..=20
Wondering why it is failing to load, considering that it program runs fine=
from its directory.

thank you all
Kiran




____________________________________________________________ _____
Connect and share in new ways with Windows Live.
http://www.windowslive.com/share.html?ocid=3DTXT_TAGHM_Wave2 _sharelife_0120=
08=

--_206a212c-aaab-4588-87c5-efcc130073b3_--

Re: DBD:Oracle question

Off the top of my head I would say it is a permission error or your
environment variables are not set. When running from Cron you do not
have the values in you .proflile set so you will have to set them in the
..pl you will need I think ORACLE_HOME and LD_LIBRARY_PATH to be set in
you program

Kiran Annaiah wrote:
> Hello,
>
> I have perl program which connects to the Oracle DB. It seems to run fine when i run it from its directory. But when i set up the program as a CRON JOB it fails to run.
> Tries to execute but gives this error and quits -
>
> ------------------------------------------------------------ -------------------------------
> Can't load '/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto /DBD/Oracle/Oracle.so' for module DBD::Oracle: libocci.so.10.1: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230.
> at /home/kiran/projects/ORACLE_TO_MYSQL_table_copy/subject_form /copy_subjFormTable_fromOraToMysql.pl line 5
> Compilation failed in require at /home/kiran/projects/ORACLE_TO_MYSQL_table_copy/subject_form /copy_subjFormTable_fromOraToMysql.pl line 5.
> BEGIN failed--compilation aborted at /home/kiran/projects/ORACLE_TO_MYSQL_table_copy/subject_form /copy_subjFormTable_fromOraToMysql.pl line 5.
> ------------------------------------------------------------ --------------------------------
>
>
> I do have the Oracle.so shared library file in the location specified above.
> Wondering why it is failing to load, considering that it program runs fine from its directory.
>
> thank you all
> Kiran
>
>
>
>
> ____________________________________________________________ _____
> Connect and share in new ways with Windows Live.
> http://www.windowslive.com/share.html?ocid=TXT_TAGHM_Wave2_s harelife_012008
>

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

RE: DBD:Oracle question

--_ed6b887f-f394-4b6c-8817-3d22efde6f53_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

i have those env variables set. I guess you are right...the cron job is not=
able to access those.
i will set it explicitly in the program.

Thank you
K



> Date: Wed, 30 Jan 2008 11:51:24 -0500
> From: scoles@pythian.com
> To: anna3144@hotmail.com
> CC: perl@lists.mysql.com
> Subject: Re: DBD:Oracle question
>=20
> Off the top of my head I would say it is a permission error or your=20
> environment variables are not set. When running from Cron you do not=20
> have the values in you .proflile set so you will have to set them in the=
=20
> .pl you will need I think ORACLE_HOME and LD_LIBRARY_PATH to be set in=20
> you program
>=20
> Kiran Annaiah wrote:
> > Hello,
> >
> > I have perl program which connects to the Oracle DB. It seems to run fi=
ne when i run it from its directory. But when i set up the program as a CRO=
N JOB it fails to run.
> > Tries to execute but gives this error and quits -
> >
> > ------------------------------------------------------------ -----------=
--------------------
> > Can't load '/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto =
/DBD/Oracle/Oracle.so' for module DBD::Oracle: libocci.so.10.1: cannot open=
shared object file: No such file or directory at /usr/lib/perl5/5.8.5/i386=
-linux-thread-multi/DynaLoader.pm line 230.
> > at /home/kiran/projects/ORACLE_TO_MYSQL_table_copy/subject_form /copy_s=
ubjFormTable_fromOraToMysql.pl line 5
> > Compilation failed in require at /home/kiran/projects/ORACLE_TO_MYSQL_t=
able_copy/subject_form/copy_subjFormTable_fromOraToMysql.pl line 5.
> > BEGIN failed--compilation aborted at /home/kiran/projects/ORACLE_TO_MYS=
QL_table_copy/subject_form/copy_subjFormTable_fromOraToMysql .pl line 5.
> > ------------------------------------------------------------ -----------=
---------------------
> >
> >
> > I do have the Oracle.so shared library file in the location specified a=
bove.=20
> > Wondering why it is failing to load, considering that it program runs =
fine from its directory.
> >
> > thank you all
> > Kiran
> >
> >
> >
> >
> > ____________________________________________________________ _____
> > Connect and share in new ways with Windows Live.
> > http://www.windowslive.com/share.html?ocid=3DTXT_TAGHM_Wave2 _sharelife_=
012008
> > =20
>=20
> --=20
> MySQL Perl Mailing List
> For list archives: http://lists.mysql.com/perl
> To unsubscribe: http://lists.mysql.com/perl?unsub=3Danna3144@hotmail.c=
om
>=20

____________________________________________________________ _____
Climb to the top of the charts!=A0Play the word scramble challenge with sta=
r power.
http://club.live.com/star_shuffle.aspx?icid=3Dstarshuffle_wl mailtextlink_ja=
n=

--_ed6b887f-f394-4b6c-8817-3d22efde6f53_--