| Error while using Oracle Transparent Gateways [message #255698] |
Wed, 01 August 2007 09:09  |
kmsalih
Messages: 197
Registered: March 2006
|
Senior Member |
|
|
Hi,
I installed Oracle Transparent Gateways 10g Release 2 in Oracle 10g Release 2 (10.2.0.1.0) 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 : 10.1.0.5.0
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.
ERROR:
ORA-28522: error initializing heterogeneous capabilities
ORA-28522: error initializing heterogeneous capabilities
ORA-28559: FDS_CLASS_NAME is MSSQL10.2.0.1.0_200, 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  |
DreamzZ
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
