My Oracle Support Banner

'No Repository on this connection' Message After Detaching Then Attaching An SQLServer Instance In ODI Topology Manager. (Doc ID 424568.1)

Last updated on JUNE 16, 2022

Applies to:

Oracle Data Integrator - Version 3.2.03.01 and later
Information in this document applies to any platform.
This problem can occur on any platform.


Symptoms

As a result of increasing disk requirements for the Master and Work Repositories, it is necessary to move the database files of the Microsoft SQLServer instance storing the Master and Work Schemas.

However, after the Microsoft SQLServer DBA has detached the database, moved the database file to another disk drive and then attached the database, it is impossible to connect from ODI Designer, Topology Manager or any other module with the display of the following message :

No Repository on this connection

However, no modification to any connection parameters (URL, Driver ...) has been performed.

What is the source of the problem and how to resolve it ?

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution

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