[NOVICE] dblink extension to Oracle is it passable

Поиск
Список
Период
Сортировка
От Garry Chen
Тема [NOVICE] dblink extension to Oracle is it passable
Дата
Msg-id ECA1748F-169C-4256-94FD-D9CBB4724658@cornell.edu
обсуждение исходный текст
Ответы Re: [NOVICE] dblink extension to Oracle is it passable  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: [NOVICE] dblink extension to Oracle is it passable  (legrand legrand <legrand_legrand@hotmail.com>)
Список pgsql-novice

Hi All,

                Is dblink extension can connect to an Oracle instance?  My stapes as following.

  1. Create extension dblink
  2. CREATE SERVER myserviec FOREIGN DATA WRAPPER dblink_fdw OPTIONS (host 'hostname', dbname 'dbname', port '1521');
  3. CREATE USER MAPPING FOR dmtools SERVER myservice OPTIONS (user 'gc92', password 'mypasswd');
  4. SELECT dblink_connect('mydbink,'myservice');

Got follow error message:

ERROR:  could not establish connection

DETAIL:  server closed the connection unexpectedly

        This probably means the server terminated abnormally

        before or while processing the request.

 

 

Thank you very much,

Garry

 

В списке pgsql-novice по дате отправления:

Предыдущее
От: Garry Chen
Дата:
Сообщение: Re: [NOVICE] Re: using LDAP for connection information lookup to doremote database connection
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: [NOVICE] dblink extension to Oracle is it passable