Обсуждение: oracle_fdw with oracle os authentication

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

oracle_fdw with oracle os authentication

От
Papiernik Anna-AAP053
Дата:

I have Oracle with OS authentication.

And I have installed PostgreSQL and I want to migrate data from Oracle to PostgreSQL database.

 

I have performed steps:

CREATE EXTENSION oracle_fdw;

CREATE SERVER oradb FOREIGN DATA WRAPPER oracle_fdw OPTIONS (dbserver '');

GRANT USAGE ON FOREIGN SERVER oradb TO postgres;

CREATE USER MAPPING FOR postgres SERVER oradb OPTIONS (user '', password '');

 

Then I have created foreign table and I want to select from it.

Unfortunatelly, oracle_fdw is unable to connect using OS authentication and it doesn’t work.

 

Is it possible to use oracle_fdw to have OS authentication?

 

Regards,
Anna

Re: oracle_fdw with oracle os authentication

От
"Xiong He"
Дата:
Not sure. But you can always avoid the OS authentication with empty user and password to access Oracle.
You can use other authentication mode to access oracle instead.

------------------
Thanks&Regards,
Xiong He

 


------------------ Original ------------------
From:  "Papiernik Anna-AAP053"<anna.papiernik@motorolasolutions.com>;
Date:  Tue, Oct 23, 2012 06:07 PM
To:  "pgsql-general@postgresql.org"<pgsql-general@postgresql.org>;
Subject:  [GENERAL] oracle_fdw with oracle os authentication

<!-- @font-face{font-family:"Cambria Math";panose-1:2 4 5 3 5 4 6 3 2 4;} @font-face{font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} @font-face{font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;} p.MsoNormal, li.MsoNormal, div.MsoNormal{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:"Calibri","sans-serif";} p.MsoAcetate, li.MsoAcetate, div.MsoAcetate{mso-style-priority:99;mso-style-link:"Balloon Text Char";margin:0in;margin-bottom:.0001pt;font-size:8.0pt;font-family:"Tahoma","sans-serif";} span.EmailStyle17{mso-style-type:personal-compose;font-family:"Calibri","sans-serif";color:windowtext;} span.BalloonTextChar{mso-style-name:"Balloon Text Char";mso-style-priority:99;mso-style-link:"Balloon Text";font-family:"Tahoma","sans-serif";} .MsoChpDefault{mso-style-type:export-only;} @page WordSection1{size:8.5in 11.0in;margin:1.0in 1.0in 1.0in 1.0in;} div.WordSection1{page:WordSection1;} -->

I have Oracle with OS authentication.

And I have installed PostgreSQL and I want to migrate data from Oracle to PostgreSQL database.

 

I have performed steps:

CREATE EXTENSION oracle_fdw;

CREATE SERVER oradb FOREIGN DATA WRAPPER oracle_fdw OPTIONS (dbserver '');

GRANT USAGE ON FOREIGN SERVER oradb TO postgres;

CREATE USER MAPPING FOR postgres SERVER oradb OPTIONS (user '', password '');

 

Then I have created foreign table and I want to select from it.

Unfortunatelly, oracle_fdw is unable to connect using OS authentication and it doesn’t work.

 

Is it possible to use oracle_fdw to have OS authentication?

 

Regards,
Anna

Re: oracle_fdw with oracle os authentication

От
"Albe Laurenz"
Дата:
[added CC to oracle-fdw-general, where this should be]

Papiernik Anna-AAP053 wrote:
> I have Oracle with OS authentication.
>
> And I have installed PostgreSQL and I want to migrate data from Oracle
to PostgreSQL database.
>
>
>
> I have performed steps:
>
> CREATE EXTENSION oracle_fdw;
>
> CREATE SERVER oradb FOREIGN DATA WRAPPER oracle_fdw OPTIONS (dbserver
'');
>
> GRANT USAGE ON FOREIGN SERVER oradb TO postgres;
>
> CREATE USER MAPPING FOR postgres SERVER oradb OPTIONS (user '',
password '');
>
>
>
> Then I have created foreign table and I want to select from it.
>
> Unfortunatelly, oracle_fdw is unable to connect using OS
authentication and it doesn't work.
>
>
>
> Is it possible to use oracle_fdw to have OS authentication?

It should work, although I admit that I never tested it (I used
External Password Store for external authentication).

Can you show me the error message?
Does it work if you connect as PostgreSQL OS user with "sqlplus /"?
If not, you have to fix that first.

Yours,
Laurenz Albe