We need to create DB-link from Oracle DB to Sybase (DB supports and changes on Sybase, but we need to get reports from the DB from Oracle)
I`ve tried:
1. I use two machines: gateway and DB server.
2. On gateway: install Oracle Gateway for Sybase with right parameters(hostName,port,databaseName)
3. On gateway: infill listener.ora
LISTENER_GW =
(ADDRESS_LIST =
(ADDRESS= (PROTOCOL=tcp)
(HOST = localhost)
(PORT = 1521)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(PROGRAM = dg4sybs)
(ORACLE_HOME = D:\oracle\11.2.0\gw)
(SID_NAME = GW)
)
)
4. On gateway: restart listener
5. On gateway: infill initdg4sybs.ora:
HS_FDS_CONNECT_INFO=[10.250.67.166]:2640/dwhdb
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
6. On DBServer: add to tnsnames.ora:
GSMLD=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=<Hostname>)(PORT=<Port>))
(CONNECT_DATA=(SID=GW))
(HS=OK) ) )
7. On DBServer: test
tnsping gsmld
…
OK (10 msec)
…
8. On DBServer: Create db-link:
create public database link gsmld connect to <UserName> identified by "<Password>" using 'GSMLD';
9. Test db-link:
select * from dba_tab_columns@gsmld;
Error is occurred:
ERROR at line 1:
ORA-28513: internal error in heterogeneous remote agent
ORA-02063: preceding line from GSMLD
10. From DBServer:
$sqlplus /NOLOG
…
SQL> conn dcbo@gsmld
Enter password:
ERROR:
ORA-28547: connection to server failed, probable Oracle Net admin error
11. From gateway:
sqlplus /NOLOG
SQL> conn <UserName>@gsmld
Enter password:
ERROR:
ORA-28547: connection to server failed, probable Oracle Net admin error
SQL> quit
Help me please to understand where my mistake is.
Thank you in advance.