pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: ÃÖÀç¿ø <jwchoi@modernlimes.com>
To: pgsql-admin@postgresql.org
Subject: How I do Configuration for Postgresql-oracle db link?
Date: Tue, 7 Jun 2011 18:14:24 +0900
Message-ID: <002d01cc24f3$4bdcb4b0$e3961e10$@com@gabia@pgsql-admin@postgresql.org> (raw)

Hi,

 

I was checked and checked my Odbc.ini File.

 

I tried connection unixODBC(isql) to oracle with ¡°root¡± user in linux OS.

I got TNS permission problem.

 

So, I tried connection unixODBC(isql) to oracle with ¡°oracle¡± user in
linux OS.

Then connected.

 

And I tried connection postgresql to oracle with ¡°postgres¡± user in linux
OS.

It was error about this.

 

- error -

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

 

Look my odbc.ini file

 

Odbc.ini

----------------------------------------

[SNIOV2]

Decription=Oracle ODBC

Driver=OracleDriver

Trace=yes

TraceFile=/tmp/odbc_oracle.log

ServerPost=192.168.10.25:1521

Database=SNIOV2 << added

UserID=vsmon

Password=dusrnth

SID=SNIOV2 << added

----------------------------------------

 

My Issue is that

[Success] UnixODBC - Oracle 

[Unsuccess] Postgresql-unixODBC-Oracle

 

 

I was checking spell completed¡¦¡¦¡¦.

 

This case is what???

 

My odbc.ini parameter is not enough?

What I Configuring?????

Please helping.

 

 



 

Attachments:

image001.jpg (image/jpeg, 9.1K) download
  view image

view thread (2+ messages)  latest in thread

Message-ID: <002d01cc24f3$4bdcb4b0$e3961e10$@com@gabia@pgsql-admin@postgresql.org>
Permalink:  ../002d01cc24f3$4bdcb4b0$e3961e10$@com@gabia@pgsql-admin@postgresql.org/
Also on:    postgresql.org/message-id/002d01cc24f3$4bdcb4b0$e3961e10$@com@gabia@pgsql-admin@postgresql.org

copy link · copy postgr.es

reply

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: jwchoi@modernlimes.com
  Subject: Re: How I do Configuration for Postgresql-oracle db link?
  In-Reply-To: <002d01cc24f3$4bdcb4b0$e3961e10$@com@gabia@pgsql-admin@postgresql.org>

* 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