From: | 최재원 <jwchoi(at)modernlimes(dot)com> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | How I do Configuration for Postgresql-oracle db link? |
Date: | 2011-06-07 09:14:24 |
Message-ID: | 002d01cc24f3$4bdcb4b0$e3961e10$@com@gabia@pgsql-admin@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | A J | 2011-06-07 16:32:31 | Switchover of Master and Slave roles |
Previous Message | Kevin Grittner | 2011-06-06 20:17:15 | Re: any tricks to get foreign key constraint builds faster |