Skip site navigation (1) Skip section navigation (2)

How I do Configuration for Postgresql-oracle db link?

From: 최재원 <jwchoi(at)modernlimes(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: How I do Configuration for Postgresql-oracle db link?
Date: 2011-06-07 09:14:24
Message-ID: 002d01cc24f3$4bdcb4b0$e3961e10$@com@gabia@pgsql-admin@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-admin
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.

 

 



 

pgsql-admin by date

Next:From: A JDate: 2011-06-07 16:32:31
Subject: Switchover of Master and Slave roles
Previous:From: Kevin GrittnerDate: 2011-06-06 20:17:15
Subject: Re: any tricks to get foreign key constraint builds faster

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group