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.


This was last published in October 2004

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

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