pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedHow I do Configuration for Postgresql-oracle db link?
2+ messages / 2 participants
[nested] [flat]
* How I do Configuration for Postgresql-oracle db link?
@ 2011-06-07 09:14 ÃÖÀç¿ø <jwchoi@modernlimes.com>
0 siblings, 0 replies; 2+ messages in thread
From: ÃÖÀç¿ø @ 2011-06-07 09:14 UTC (permalink / raw)
To: 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.
Attachments:
image001.jpg (image/jpeg, 9.1K) download
view image
* Re: How I do Configuration for Postgresql-oracle db link?
@ 2011-06-07 16:36 Mark Johnson <mark@remingtondatabasesolutions.com>
0 siblings, 0 replies; 2+ messages in thread
From: Mark Johnson @ 2011-06-07 16:36 UTC (permalink / raw)
To: ÃÖÀç¿ø <jwchoi@modernlimes.com>; pgsql-admin
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
Attachments:
image001.jpg (image/jpeg, 9.1K) download
view image
end of thread, other threads:[~2011-06-07 16:36 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-06-07 09:14 How I do Configuration for Postgresql-oracle db link? ÃÖÀç¿ø <jwchoi@modernlimes.com>
2011-06-07 16:36 Re: How I do Configuration for Postgresql-oracle db link? Mark Johnson <mark@remingtondatabasesolutions.com>
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