Home » RDBMS Server » Networking and Gateways » Error while using Oracle Transparent Gateways
Error while using Oracle Transparent Gateways [message #255698] Wed, 01 August 2007 09:09 Go to next message
Messages: 198
Registered: March 2006
Senior Member

I installed Oracle Transparent Gateways 10g Release 2 in Oracle 10g Release 2 ( Home Windows Platform.

I configured the init file in tg4msql directory and configured listener and tnsnames.ora and database link and i am able to fetch data from sql server.

My issue is i want to use the same listener in another database. the details of the second database in which i want to use the listener

Database Version :
Platform : Red Hat Enterprise Linux ES release 4 (Nahant Update 5)

What i had done is i copied the tnsnames entry of the hetrogeneous connection to the tnsnames.ora of Oracle on linux.

I tried pinging of tnsnames and it is working fine.

While selecting from table i am getting the following error.

ORA-28522: error initializing heterogeneous capabilities
ORA-28522: error initializing heterogeneous capabilities
ORA-28559: FDS_CLASS_NAME is MSSQL10., FDS_INST_NAME is tg4msql
ORA-02063: preceding 3 lines from SYMPHONY1
ORA-00604: error occurred at recursive SQL level 1
ORA-24274: no row exists in the HS$_FDS_CLASS table for these parameters
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_HS_UTL", line 431
ORA-06512: at "SYS.DBMS_HS_CHK", line 147
ORA-06512: at "SYS.DBMS_HS_UTL", line 46
ORA-06512: at "SYS.DBMS_HS", line 38
ORA-06512: at line 1

Thanking you,
Salih KM
Re: Error while using Oracle Transparent Gateways [message #255719 is a reply to message #255698] Wed, 01 August 2007 10:27 Go to previous message
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
ORA-28522:	error initializing heterogeneous capabilities
Cause:	ORACLE was unable to retrieve capability definitions for the non-Oracle system instance,
 probably because the underlying data dictionary table does not exist or is formed incorrectly.
Action:	Verify that the ORACLE server's 
Heterogeneous Services data dictionary was installed correctly. 
If the Heterogeneous Services data dictionary is not installed, execute the CATHS.SQL
 script in the $ORACLE_HOME/rdbms/admin 
directory. If the connected agent, identified by FDS_CLASS_NAME,
 requires a custom installation script for the ORACLE server, 
verify that the script has been run. If both scripts were
 executed and the error persists, contact the customer support representative of the agent vendor.

[Updated on: Wed, 01 August 2007 10:27]

Report message to a moderator

Previous Topic: gateways error,help me~
Next Topic: tnsping unable to resolve
Goto Forum:

Current Time: Sun Feb 19 13:00:24 CST 2017

Total time taken to generate the page: 0.13038 seconds