Обсуждение: How I do Configuration for Postgresql-oracle db link?

Поиск
Список
Период
Сортировка

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.

 

 

 




새로운 메일이 도착하면, 메신저로 바로 알려줍니다!
가비아 하이웍스 메일 - hiworks.co.kr
Вложения

Re: How I do Configuration for Postgresql-oracle db link?

От
"Mark Johnson"
Дата:
Did you configure a system DSN or user DSN?  If connections fail for postgres and succeed for other users, then look in the postgres user's home for hidden file ~/.odbc.ini.  Each user can have one of these hidden files.
-Mark
-----Original Message-----
From: 최재원 [mailto:jwchoi@modernlimes.com]
Sent: Tuesday, June 7, 2011 05:14 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] How I do Configuration for Postgresql-oracle db link?

v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);}

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.  

 




새로운 메일이 도착하면, 메신저로 바로 알려줍니다!
가비아 하이웍스 메일 - hiworks.co.kr
Вложения