From: hartrc <rhart2@mt.gov>
To: pgsql-general@postgresql.org
Subject: oracle_fdw
Date: Thu, 18 Oct 2012 13:53:23 -0700 (PDT)
Message-ID: <1350593603292-5728931.post@n5.nabble.com> (raw)
Environment: PostgreSQL 9.1.6
SLES 11 SP2
Oracle_fdw 0.9.7
I am trying to implement the use of oracle_fdw.
So far I have installed an oracle client on my postgres server. I can
connect to the oracle environment from the postgres server (as postgres os
user) by navigating to $ORACLE_HOME/bin then ./sqlplus /nolog
then:
connect user@instance
I have downloaded and run make and make install for the oracle_fdw - both
executed successfully. I have created the extension successfully. I have
created a foreign server, foreign data wrapper and a foreign table.
When i try a select from the foreign table I get:
ERROR: error connecting to Oracle: OCIEnvCreate failed to create
environment handle
DETAIL:
ERROR: error connecting to Oracle: OCIEnvCreate failed to create environment
handle
SQL state: HV00N
from what limited info i can find this is most likely due to my ORACLE_HOME
environment variable or other environment setting? I have set ORACLE_HOME in
postgres user .bash_profile
Where should i set ORACLE_HOME and TNS_ADMIN environment variables? Is there
something else I am missing? Does the database require to be restarted
following any changes to environment variables?
Thank you
Rob
--
View this message in context: http://postgresql.1045698.n5.nabble.com/oracle-fdw-tp5728931.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
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-general@postgresql.org
Cc: rhart2@mt.gov
Subject: Re: oracle_fdw
In-Reply-To: <1350593603292-5728931.post@n5.nabble.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