From: Tom Lane <tgl@sss.pgh.pa.us>
To: Ray Stell <stellr@cns.vt.edu>
Cc: ?????? <jwchoi@modernlimes.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: How I do from PostgreSQL to Oracle Db Link
Date: Mon, 06 Jun 2011 10:02:54 -0400
Message-ID: <26102.1307368974@sss.pgh.pa.us> (raw)
In-Reply-To: <20110606123316.GA4391@cns.vt.edu>
References: <20110606123316.GA4391@cns.vt.edu>
Ray Stell <stellr@cns.vt.edu> writes:
> On Sat, Jun 04, 2011 at 10:05:46AM +0900, ?????? wrote:
>> ERROR: odbclink: unsuccessful SQLConnect call: [S1000] [12514]
>>
>> [[unixODBC][Oracle][ODBC][Ora]ORA-12514: TNS:listener does not currently
>> know of service requested in connect descripto
> sounds like you got to the listener, but didn't tell it the correct service name in
> the connect string. Did you spell it correctly? You can use the oracle cmd
> lsnrctl status on the oracle server to get the service names.
I wonder if the OP set up the service description in his personal
~/.odbc.ini file. If so, it would work for him from the command line,
but odbclink running in the postgres server wouldn't see it (unless the
server happened to be running as his userid, which wouldn't be a good
setup). The fix for that would be to put the info in the system-wide
/etc/odbc.ini file.
regards, tom lane
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: tgl@sss.pgh.pa.us, stellr@cns.vt.edu, jwchoi@modernlimes.com
Subject: Re: How I do from PostgreSQL to Oracle Db Link
In-Reply-To: <26102.1307368974@sss.pgh.pa.us>
* 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