My Oracle Support Banner

Unable to use ODE.NET after database upgrade from previous version (Doc ID 1455368.1)

Last updated on MARCH 26, 2019

Applies to:

Oracle Database Extensions for .NET - Version and later
Microsoft Windows (32-bit)
Microsoft Windows x64 (64-bit)
*** Checked for relevance on 26-Mar-2019 ***


 After upgrading a database from 11202 to 11203, via out out-of-place upgrade but pointing to the old datafiles, attempting to use the Oracle Database Extensions for .NET (ODE.NET) results in one of the following:

During the deployment wizard:
Oracle Deployment Wizard for .NET: The sub-directory you specified doesn't exist, or the file is read only.
or the file may be copied to the "old" Oracle home instead of the new home.

or , after copying the file manually to the %ORACLE_HOME%\bin\clr directory:
ORA-02019: connection description for remote database not found

The following data dictionary queries show the setup is not correct
-result points to the old database location

select * from dba_db_links where db_link='DBMS_CLRDBLINK';
- returns no rows found.

select * from dual@DBMS_CLRDBLINK
- results in ORA-02019: connection description for remote database not found (the call is not expected to succeed, but is expected to fail in other ways)


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.