From: Pepe TD Vo <pepevo@yahoo.com>
To: Don Seiler <don@seiler.us>
Cc: Shreeyansh Dba <shreeyansh2014@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: ora2pg perl module error
Date: Thu, 24 Jan 2019 18:18:15 +0000 (UTC)
Message-ID: <2134930529.547389.1548353895875@mail.yahoo.com> (raw)
In-Reply-To: <1924376145.2429322.1548263832913@mail.yahoo.com>
References: <34359708.2383722.1548257429166.ref@mail.yahoo.com>
<34359708.2383722.1548257429166@mail.yahoo.com>
<1924376145.2429322.1548263832913@mail.yahoo.com>
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 <pepevo@yahoo.com> 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_ora2pgdhwbrzinstall_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 190at (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 <pepevo@yahoo.com> wrote:
echo ORACLE_HOMEORACLE_HOME /u01/app/oracle/product/12.2.0/dbhome_1/echo LD_LIBRARY_PATHLD_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 <don@seiler.us> wrote:
On Wed, Jan 23, 2019 at 8:16 AM Pepe TD Vo <pepevo@yahoo.com> 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 instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: pepevo@yahoo.com, don@seiler.us, shreeyansh2014@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: ora2pg perl module error
In-Reply-To: <2134930529.547389.1548353895875@mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox