Skip to main content
Solved

DB Links creation steps for DMM to work properly

  • October 19, 2023
  • 1 reply
  • 280 views

NiyomalN
Hero (Partner)
Forum|alt.badge.img+11

Hi Experts,

 

at the moment we are trying to configure DMM too to do the migration for a new implementation. The customer hosting the 23R1 version on premise and we are having some hard time to get the DB links works for  non production environment. 

We have setup the Template project in PROD and then created a project based on the template projects. However, not clear about how we can create DB links to add non production environments as connected environments. 

 

can someone help me to find out the proper way of doing it  like what user we need to use here and stuff like that.

 

Kind Regards!

Niyomal.

Best answer by NiyomalN

Solved  it..!!

We need to create DB links logging as IFSAPP, remember you need to activate the IFSMIG user in target environment first.

you can use below script to get the DB links created 

 

CREATE DATABASE LINK <<DB LINK NAME>> CONNECT TO IFSMIG IDENTIFIED BY <password> USING <<target DB name>>;

 

 hope this will help someone in future.

View original
Did this topic help you find an answer to your question?

1 reply

NiyomalN
Hero (Partner)
Forum|alt.badge.img+11
  • Author
  • Hero (Partner)
  • 103 replies
  • Answer
  • October 20, 2023

Solved  it..!!

We need to create DB links logging as IFSAPP, remember you need to activate the IFSMIG user in target environment first.

you can use below script to get the DB links created 

 

CREATE DATABASE LINK <<DB LINK NAME>> CONNECT TO IFSMIG IDENTIFIED BY <password> USING <<target DB name>>;

 

 hope this will help someone in future.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings