Re: ora2pg perl module error - Mailing list pgsql-admin

From Pepe TD Vo
Subject Re: ora2pg perl module error
Date
Msg-id 34359708.2383722.1548257429166@mail.yahoo.com
Whole thread Raw
In response to ora2pg perl module error  (Pepe TD Vo <pepevo@yahoo.com>)
Responses Re: ora2pg perl module error  (Pepe TD Vo <pepevo@yahoo.com>)
List pgsql-admin
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 <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


pgsql-admin by date:

Previous
From: Don Seiler
Date:
Subject: Re: ora2pg perl module error
Next
From: Pepe TD Vo
Date:
Subject: Re: ora2pg perl module error