Discussion:
DBMS_CLRDBLINK
Schauss, Peter (ESS)
2014-03-21 15:24:09 UTC
Permalink
This turned up in an audit of one of my databases (11.2.0.3 on 32 bit Windows). Select * from dba_db_links returns the following:

Owner = PUBLIC
DB_LINK = DBMS_CLRDBLINK
USERNAME = null
HOST= ORACLR_CONNECTION_DATA

The link obviously does not work. The creation date and time coincide roughly with when the database was created. The only reference I can find on the Oracle support site is KB article 1455368.1 which implies that it is somehow associated with a product called ODE.NET.

Any idea what this link is for?

Thanks,
Peter Schauss
--
http://www.freelists.org/webpage/oracle-l
Powell, Mark
2014-03-21 18:11:14 UTC
Permalink
Peter, look at $ORACLE_HOME/rdbms/admin/ script dbmsclr.plb I think the create might be there based on Oracle support note: Unable to use ODE.NET after database upgrade from previous version (Doc ID 1455368.1) which mentions recreating an ODE related database link.


-----Original Message-----
From: oracle-l-bounce-***@public.gmane.org [mailto:oracle-l-bounce-***@public.gmane.org] On Behalf Of Schauss, Peter (ESS)
Sent: Friday, March 21, 2014 11:24 AM
To: oracle-l
Subject: DBMS_CLRDBLINK

This turned up in an audit of one of my databases (11.2.0.3 on 32 bit Windows). Select * from dba_db_links returns the following:

Owner = PUBLIC
DB_LINK = DBMS_CLRDBLINK
USERNAME = null
HOST= ORACLR_CONNECTION_DATA

The link obviously does not work. The creation date and time coincide roughly with when the database was created. The only reference I can find on the Oracle support site is KB article 1455368.1 which implies that it is somehow associated with a product called ODE.NET.

Any idea what this link is for?

Thanks,
Peter Schauss
--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l

Loading...