Обсуждение: 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.
|
Вложения
-----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