%ORACLE_HOME%\hs\admin\initPGSQL.ora
# This is a sample agent init file that contains the HS parameters that are
# needed for the Database Gateway for ODBC

#
# HS init parameters
#
HS_FDS_CONNECT_INFO = pg4test
#HS_FDS_TRACE_LEVEL = <trace_level>


#
# Environment variables required for the non-Oracle system
#
#set <envvar>=<value>

%ORACLE_HOME%\NETWORK\ADMIN\listener.ora
# listener.ora Network Configuration File: D:\DB\Oracle\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)

SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=PGSQL)
(ORACLE_HOME=D:\DB\Oracle\product\11.2.0\dbhome_1)
(PROGRAM=dg4odbc)
)
)


ADR_BASE_LISTENER = D:\DB\Oracle

%ORACLE_HOME%\NETWORK\ADMIN\tnsnames.ora
POSTGRES =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.lan)(PORT = 1521))
)
(CONNECT_DATA =
(SID = PGSQL)
)
(HS = OK)
)

sqlplus scott@xxx.world
SQL*Plus: Release 11.2.0.3.0 Production on Sat Feb 16 00:09:19 2013

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Enter password:

Connected to:
Oracle Database 11g Release 11.2.0.1.0 - Production

SQL> select * from dual@postgres;
select * from dual@postgres
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
ОШИБКА: отношение "DUAL" не существует;
No query has been executed with that handle {42P01,NativeErr = 1}
ORA-02063: preceding 3 lines from POSTGRES


SQL>

SQL> select * from all_tab_columns@postgres;
select * from all_tab_columns@postgres
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
ОШИБКА: отношение "ALL_TAB_COLUMNS" не существует;
No query has been executed with that handle {42P01,NativeErr = 1}
ORA-02063: preceding 3 lines from POSTGRES

SQL> select * from DataTable@postgres;
select * from DataTable@postgres
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
ОШИБКА: отношение "DATATABLE" не существует;
No query has been executed with that handle {42P01,NativeErr = 1}
ORA-02063: preceding 3 lines from POSTGRES

SQL> select * from "DataTable"@postgres;

Id v_num v_str
---------- ---------- --------------------
1 123 str1
2 456 str2
3 789 str3

SQL>