Hi DBA's
I need to connect my Oracle DB to a db server Cache Intersystem
somebody can tell me how to create a DBlink beetween the two system?
After the db link creation i receive this message:
SQL> create database link dbl_cachedb connect to sysadmin identified by using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = XXXXX )(PORT = 1972))) (CONNECT_DATA = (SID=xxxxstat)) (HS = OK))';
Database link created.
SQL> Select count (*) from ccms.nbace@dbl_cachedb;
Select count (*) from ccms.nbace@dbl_cachedb
*
ERROR at line 1:
ORA-28545: error diagnosed by Net8 when connecting to an agent
Unable to retrieve text of NETWORK/NCR message 65535
ORA-02063: preceding 2 lines from DBL_CACHEDB
in the alert log i find:
HS: Unable to establish RPC connection to HS Agent...
HS: ... Agent SID = (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xxxx)(PORT=xxx)))(CONNECT_DATA=(SID=xxs_))), NCR error = 65535 Unable to retrieve text of NETWORK/NCR message 65535
Any Idea?
Many thanks