Problems accessing SQL Server from Oracle

Thanks for the tip on enclosing the column/table name in double quotes, but in my case, I'm still running into some problems accessing the SQL Server tables from Oracle. I get the following errors:

 
SQL> select "SystemAcronym" from
"7E7_Arch.dbo.vw_7e7_apps"@ARCH7E7RO;
select "SystemAcronym" from "7E7_Arch.dbo.vw_7e7_apps"@ARCH7E7RO
* ERROR at line 1:
ORA-28536: error in processing Heterogeneous Services initialization 
parameters
ORA-28507: error in data dictionary view sys.hs$_class_init
ORA-02063: preceding 2 lines from ARCH7E7RO
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist

The suggestion does not work because the table or view that does not exist is not in the remote database. Rather, it is a data dictionary view that is having problmems. This is an example of why all error messages are important, not just one.

I would suggest running the $ORACLE_HOME/rdbms/admin/caths.sql script again as SYS to recreate the Heterogeneous Services views.