How I do Configuration for Postgresql-oracle db link?

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.