SSTS Blog

Some news and tidbits that we share

11G upgrade Heterogeneous Services quirk

by SSTS
SSTS
Server Side Technology Solutions is a consulting firm that specializes in databa
User is currently offline
on May 28 in Blog 0 Comments
11G upgrade Heterogeneous Services quirk
Last week I went through an upgrade from 10G to 11G and had a problem with some dblinks I had setup to use the generic ODBC gateway. The links stopped working. The fix was to check the Enable Quoted Identifiers option in the DSN Advanced tab.
Also, as I was searching I found some suggestions to add the following line to the hs/admin/init.ora file(s)
...
11G upgrade Heterogeneous Services quirk
Last week I went through an upgrade from 10G to 11G and had a problem with some dblinks I had setup to use the generic ODBC gateway. The links stopped working. The fix was to check the Enable Quoted Identifiers option in the DSN Advanced tab.
Also, as I was searching I found some suggestions to add the following line to the hs/admin/init.ora file(s)
HS_FDS_SUPPORT_STATISTICS=FALSE


Read more http://billennis-ssts.blogspot.com/2008/05/11g-upgrade-heterogeneous-services.html

Tags: Untagged
Hits: 40343

About the author

SSTS

Server Side Technology Solutions is a consulting firm that specializes in database design, development and support.

Comments

Please login first in order for you to submit comments