Skip to main content

Hi,

What are all the thins to check in IFS application after a DB refresh.

How can I identify that it is perfectly refreshed?

Please help...

Thanks in advance.

 

Thanks and regards,

Hari

Hi @proharikg,

It depend on your environment settings and configurations you use. But in general terms I would recommend below points to check before and after the refresh whether it has the same parameters.

  1. batch queue configuration
  2. delivery differences (installed Components window)
  3. system parameters, plsqlap environment tab & IFS Connect Configurations
  4. License Management window information
  5. Connect server’s listener port (Setup IFS Connect window)
  6. database backup method configuration and archive logs parameters
  7. undo tablespace names 
  8. oracle directory names and paths

These are the basic which came to my mind to be verified after the database refresh and this is what we follow as a standard as well. But there's a catch if you are using customized tables and information on the environment those need to be verified as well.

Hope this clears your question! If this comment satisfies you please mark it as the best answer so others will also get benefited from this post.


Hi @proharikg,

It depend on your environment settings and configurations you use. But in general terms I would recommend below points to check before and after the refresh whether it has the same parameters.

  1. batch queue configuration
  2. delivery differences (installed Components window)
  3. system parameters, plsqlap environment tab & IFS Connect Configurations
  4. License Management window information
  5. Connect server’s listener port (Setup IFS Connect window)
  6. database backup method configuration and archive logs parameters
  7. undo tablespace names 
  8. oracle directory names and paths

These are the basic which came to my mind to be verified after the database refresh and this is what we follow as a standard as well. But there's a catch if you are using customized tables and information on the environment those need to be verified as well.

Hope this clears your question! If this comment satisfies you please mark it as the best answer so others will also get benefited from this post.

Hi Ragav,

Thanks a lot.

 

Regards,

Hari


Write a script, and don’t rely on a manual process. Avoiding the embarrassment when your nonproduction system sends an email to a customer or a supplier will make such an effort worth your time.

Our postdbcopy.sql script is now over 1200 lines long. There’s just too much to remember to do.


Hi,

 

Do we have postdbcopy.sql and can you share if possible?