ora2pg perl module error

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
7 messages Options
Reply | Threaded
Open this post in threaded view
|

ora2pg perl module error

Pepe TD Vo
Good morning Experts,

after install DBD::Oracle and configure ora2pg.conf.  I run orag2pg and get an error
# cd /etc/ora2pg
# cp ora2pg.conf.dist ora2pg.conf
# vi ora2pg.conf   ---> with modification below
ORACLE_HOME /u01/app/oracle/product/12.2.0/dbhome_1
ORACLE_DSN dbi::Oracle:host=hostname;sid=CIDR;port-1521
ORACLE_USER system
ORACLE_PWD xxxxx
TYPE TAPE PACKAGE INSERT COPY VIEW GRANT SEQUENCE TRIGGER FUNCTION PROCEDURE TABLESPACE TYPE PARTITION QUERY DBLINK SYNONYM LOAD

#ora2pg
install_driver(Oracle) failed: can't load '/usr/local/lib64/perl5/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle:libclntsh.so.12.1: cannot open shared object file:No such file or directory at /usr/lib64/perl5/DynaLoader.pm line 190 at (evel13) line3.
compilcation failed in require at (eval13) line 3.
Perhaps a required shared library or dll isn't installed where expected at /usr/local/share/perl5/Ora2Pg.pm line 1570.

the /usr/lib64/perl5/DynaLoader.pm existed and at line 190, I found:
my $libreg = dl_load_file($file, $module->dl_load_flags) or
croak("Can't load '$file' for module $module: ".dl_error());

what library/module needed?

thank you.
 
Bach-Nga

No one in this world is pure and perfect.  If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.
To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)

**Live simply **Love generously **Care deeply **Speak kindly.
*** Genuinely rich *** Faithful talent *** Sharing success
Reply | Threaded
Open this post in threaded view
|

Re: ora2pg perl module error

Shreeyansh dba
It seems that, DBD:: Oracle can't find the Oracle client libraries because they're not in your library path. You need to add its lib directory (something like  /usr/lib/oracle/instantclient/lib or /opt/ora/instantclient10_1/lib) to your library path -- either by adding a line to /etc/led. so. conf and running ldconfig as root, or by setting the LD_LIBRARY_PATH environment variable.
Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com


On Wed, Jan 23, 2019 at 7:10 PM Pepe TD Vo <[hidden email]> wrote:
Good morning Experts,

after install DBD::Oracle and configure ora2pg.conf.  I run orag2pg and get an error
# cd /etc/ora2pg
# cp ora2pg.conf.dist ora2pg.conf
# vi ora2pg.conf   ---> with modification below
ORACLE_HOME /u01/app/oracle/product/12.2.0/dbhome_1
ORACLE_DSN dbi::Oracle:host=hostname;sid=CIDR;port-1521
ORACLE_USER system
ORACLE_PWD xxxxx
TYPE TAPE PACKAGE INSERT COPY VIEW GRANT SEQUENCE TRIGGER FUNCTION PROCEDURE TABLESPACE TYPE PARTITION QUERY DBLINK SYNONYM LOAD

#ora2pg
install_driver(Oracle) failed: can't load '/usr/local/lib64/perl5/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle:libclntsh.so.12.1: cannot open shared object file:No such file or directory at /usr/lib64/perl5/DynaLoader.pm line 190 at (evel13) line3.
compilcation failed in require at (eval13) line 3.
Perhaps a required shared library or dll isn't installed where expected at /usr/local/share/perl5/Ora2Pg.pm line 1570.

the /usr/lib64/perl5/DynaLoader.pm existed and at line 190, I found:
my $libreg = dl_load_file($file, $module->dl_load_flags) or
croak("Can't load '$file' for module $module: ".dl_error());

what library/module needed?

thank you.
 
Bach-Nga

No one in this world is pure and perfect.  If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.
To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)

**Live simply **Love generously **Care deeply **Speak kindly.
*** Genuinely rich *** Faithful talent *** Sharing success
Reply | Threaded
Open this post in threaded view
|

Re: ora2pg perl module error

Pepe TD Vo
i am using oracle database server.  the LD_LIBRARY_PATH already declared as  $ORACLE_HOME/lib  before running ora2pg

do I need to set it on ora2pg.conf ?

thank you expert.

v/r,
 
Bach-Nga

No one in this world is pure and perfect.  If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.
To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)

**Live simply **Love generously **Care deeply **Speak kindly.
*** Genuinely rich *** Faithful talent *** Sharing success


On Wednesday, January 23, 2019 9:09 AM, Shreeyansh Dba <[hidden email]> wrote:


It seems that, DBD:: Oracle can't find the Oracle client libraries because they're not in your library path. You need to add its lib directory (something like  /usr/lib/oracle/instantclient/lib or /opt/ora/instantclient10_1/lib) to your library path -- either by adding a line to /etc/led. so. conf and running ldconfig as root, or by setting the LD_LIBRARY_PATH environment variable.
Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com


On Wed, Jan 23, 2019 at 7:10 PM Pepe TD Vo <[hidden email]> wrote:
Good morning Experts,

after install DBD::Oracle and configure ora2pg.conf.  I run orag2pg and get an error
# cd /etc/ora2pg
# cp ora2pg.conf.dist ora2pg.conf
# vi ora2pg.conf   ---> with modification below
ORACLE_HOME /u01/app/oracle/product/12.2.0/dbhome_1
ORACLE_DSN dbi::Oracle:host=hostname;sid=CIDR;port-1521
ORACLE_USER system
ORACLE_PWD xxxxx
TYPE TAPE PACKAGE INSERT COPY VIEW GRANT SEQUENCE TRIGGER FUNCTION PROCEDURE TABLESPACE TYPE PARTITION QUERY DBLINK SYNONYM LOAD

#ora2pg
install_driver(Oracle) failed: can't load '/usr/local/lib64/perl5/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle:libclntsh.so.12.1: cannot open shared object file:No such file or directory at /usr/lib64/perl5/DynaLoader.pm line 190 at (evel13) line3.
compilcation failed in require at (eval13) line 3.
Perhaps a required shared library or dll isn't installed where expected at /usr/local/share/perl5/Ora2Pg.pm line 1570.

the /usr/lib64/perl5/DynaLoader.pm existed and at line 190, I found:
my $libreg = dl_load_file($file, $module->dl_load_flags) or
croak("Can't load '$file' for module $module: ".dl_error());

what library/module needed?

thank you.
 
Bach-Nga

No one in this world is pure and perfect.  If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.
To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)

**Live simply **Love generously **Care deeply **Speak kindly.
*** Genuinely rich *** Faithful talent *** Sharing success


Reply | Threaded
Open this post in threaded view
|

Re: ora2pg perl module error

Don Seiler
On Wed, Jan 23, 2019 at 8:16 AM Pepe TD Vo <[hidden email]> wrote:
i am using oracle database server.  the LD_LIBRARY_PATH already declared as  $ORACLE_HOME/lib  before running ora2pg

Please share what the output of "echo $ORACLE_HOME" and "echo $LD_LIBRARY_PATH" is, to confirm that both are properly set. Do you have Oracle database server installed on this host, or is this using instantclient? 
 
do I need to set it on ora2pg.conf ?

No, ora2pg will need to see it in your shell session's environment.

Don. 
--
Don Seiler
www.seiler.us
Reply | Threaded
Open this post in threaded view
|

Re: ora2pg perl module error

Pepe TD Vo
In reply to this post by Pepe TD Vo
echo ORACLE_HOME
ORACLE_HOME /u01/app/oracle/product/12.2.0/dbhome_1/
echo LD_LIBRARY_PATH
LD_LIBRARY_PATH /u01/app/oracle/product/12.2.0/dbhome_1/lib

I even added the library on ora2pg.conf but didn't work.

when I set both on command prompt and ora2pg is running but no result.  Hung somewhere????
 
Bach-Nga

No one in this world is pure and perfect.  If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.
To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)

**Live simply **Love generously **Care deeply **Speak kindly.
*** Genuinely rich *** Faithful talent *** Sharing success


On Wednesday, January 23, 2019 9:26 AM, Don Seiler <[hidden email]> wrote:


On Wed, Jan 23, 2019 at 8:16 AM Pepe TD Vo <[hidden email]> wrote:
i am using oracle database server.  the LD_LIBRARY_PATH already declared as  $ORACLE_HOME/lib  before running ora2pg

Please share what the output of "echo $ORACLE_HOME" and "echo $LD_LIBRARY_PATH" is, to confirm that both are properly set. Do you have Oracle database server installed on this host, or is this using instantclient? 
 
do I need to set it on ora2pg.conf ?

No, ora2pg will need to see it in your shell session's environment.

Don. 
--
Don Seiler
www.seiler.us


Reply | Threaded
Open this post in threaded view
|

Re: ora2pg perl module error

Pepe TD Vo
I reset and the ora2pg run with 65 tables 100% scanning and the server timeout.

reconnect the server and reset the LD_LIBRARY_PATH and ORACLE_HOME from command prompt and I rerun ora2pg with background I get:

FATAL: can not remove old temporary file /tmp/tmp_ora2pgdhwbrz
install_driver(oracle) failed: Can't load '/usr/local/lib64/perl5/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: libclntsh.so.12.1: cannot open shared object file: No suck file or directory at /usr/lib64/perl5/DynaLoader.pm line 190
at (evel 13) line 3.
complication failed in require at (eval 13) line 3.
Perhaps a required share library or ddl isn't installed where expected at /usr/local/share/perl5/Ora3Pg.pm line 1570
 

I removed /tmp/tmp_ora2pgdhwbrz and the error is still the same when I run "ora2pg"

what is the error at this time?

thank you for your input.

v/r,
Bach-Nga

No one in this world is pure and perfect.  If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.
To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)

**Live simply **Love generously **Care deeply **Speak kindly.
*** Genuinely rich *** Faithful talent *** Sharing success


On Wednesday, January 23, 2019 10:30 AM, Pepe TD Vo <[hidden email]> wrote:


echo ORACLE_HOME
ORACLE_HOME /u01/app/oracle/product/12.2.0/dbhome_1/
echo LD_LIBRARY_PATH
LD_LIBRARY_PATH /u01/app/oracle/product/12.2.0/dbhome_1/lib

I even added the library on ora2pg.conf but didn't work.

when I set both on command prompt and ora2pg is running but no result.  Hung somewhere????
 
Bach-Nga

No one in this world is pure and perfect.  If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.
To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)

**Live simply **Love generously **Care deeply **Speak kindly.
*** Genuinely rich *** Faithful talent *** Sharing success


On Wednesday, January 23, 2019 9:26 AM, Don Seiler <[hidden email]> wrote:


On Wed, Jan 23, 2019 at 8:16 AM Pepe TD Vo <[hidden email]> wrote:
i am using oracle database server.  the LD_LIBRARY_PATH already declared as  $ORACLE_HOME/lib  before running ora2pg

Please share what the output of "echo $ORACLE_HOME" and "echo $LD_LIBRARY_PATH" is, to confirm that both are properly set. Do you have Oracle database server installed on this host, or is this using instantclient? 
 
do I need to set it on ora2pg.conf ?

No, ora2pg will need to see it in your shell session's environment.

Don. 
--
Don Seiler
www.seiler.us




Reply | Threaded
Open this post in threaded view
|

Re: ora2pg perl module error

Pepe TD Vo
I reset all and rerun ora2pg with nohup.out.  I found out the output.sql didn't locate on the output directory (/u02) I specified in the ora2pg.conf.  Turned out it stop the process via fill up all root partition.  why the output is not on /u02 but root ?  How do I run ora2pg and/or relaunch it?

Bach-Nga

No one in this world is pure and perfect.  If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.
To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)

**Live simply **Love generously **Care deeply **Speak kindly.
*** Genuinely rich *** Faithful talent *** Sharing success


On Wednesday, January 23, 2019, 12:17:37 PM EST, Pepe TD Vo <[hidden email]> wrote:


I reset and the ora2pg run with 65 tables 100% scanning and the server timeout.

reconnect the server and reset the LD_LIBRARY_PATH and ORACLE_HOME from command prompt and I rerun ora2pg with background I get:

FATAL: can not remove old temporary file /tmp/tmp_ora2pgdhwbrz
install_driver(oracle) failed: Can't load '/usr/local/lib64/perl5/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: libclntsh.so.12.1: cannot open shared object file: No suck file or directory at /usr/lib64/perl5/DynaLoader.pm line 190
at (evel 13) line 3.
complication failed in require at (eval 13) line 3.
Perhaps a required share library or ddl isn't installed where expected at /usr/local/share/perl5/Ora3Pg.pm line 1570
 

I removed /tmp/tmp_ora2pgdhwbrz and the error is still the same when I run "ora2pg"

what is the error at this time?

thank you for your input.

v/r,
Bach-Nga

No one in this world is pure and perfect.  If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.
To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)

**Live simply **Love generously **Care deeply **Speak kindly.
*** Genuinely rich *** Faithful talent *** Sharing success


On Wednesday, January 23, 2019 10:30 AM, Pepe TD Vo <[hidden email]> wrote:


echo ORACLE_HOME
ORACLE_HOME /u01/app/oracle/product/12.2.0/dbhome_1/
echo LD_LIBRARY_PATH
LD_LIBRARY_PATH /u01/app/oracle/product/12.2.0/dbhome_1/lib

I even added the library on ora2pg.conf but didn't work.

when I set both on command prompt and ora2pg is running but no result.  Hung somewhere????
 
Bach-Nga

No one in this world is pure and perfect.  If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.
To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)

**Live simply **Love generously **Care deeply **Speak kindly.
*** Genuinely rich *** Faithful talent *** Sharing success


On Wednesday, January 23, 2019 9:26 AM, Don Seiler <[hidden email]> wrote:


On Wed, Jan 23, 2019 at 8:16 AM Pepe TD Vo <[hidden email]> wrote:
i am using oracle database server.  the LD_LIBRARY_PATH already declared as  $ORACLE_HOME/lib  before running ora2pg

Please share what the output of "echo $ORACLE_HOME" and "echo $LD_LIBRARY_PATH" is, to confirm that both are properly set. Do you have Oracle database server installed on this host, or is this using instantclient? 
 
do I need to set it on ora2pg.conf ?

No, ora2pg will need to see it in your shell session's environment.

Don. 
--
Don Seiler
www.seiler.us