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

Last updated on JULY 05, 2017

Applies to:

Oracle Database Extensions for .NET - Version 11.2.0.2 and later
Microsoft Windows (32-bit)
Microsoft Windows x64 (64-bit)

*** Checked for relevance on 30-Sep-2016 ***

Symptoms

 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
---------------------------------------------------------------------------------------
SELECT * FROM ALL_DIRECTORIES where directory_name='ORACLECLRDIR';
-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)

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms