Q
Problem solve Get help with specific problems with your technologies, process and projects.

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.


Dig Deeper on Oracle database design and architecture

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close