Re: How I do Configuration for Postgresql-oracle db link? - Mailing list pgsql-admin

-----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