Solved

DB Links creation steps for DMM to work properly

  • 19 October 2023
  • 1 reply
  • 128 views

Userlevel 3
Badge +9

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.

icon

Best answer by NiyomalN 20 October 2023, 15:54

View original

1 reply

Userlevel 3
Badge +9

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