Solved

Things to check in IFS application after DB refresh

  • 4 August 2021
  • 4 replies
  • 509 views
proharikg
Rank
Userlevel 5
Badge +9

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

icon

Best answer by Ragaventhan Sathananda 4 August 2021, 09:27

View original
This topic has been closed for comments

4 replies

Ragaventhan Sathananda
Rank
Userlevel 7
Badge +15

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.

Ragaventhan S - https://www.linkedin.com/in/ragaventhan-sathananda/
proharikg
Rank
Userlevel 5
Badge +9

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

durette
Rank
Userlevel 7
Badge +18

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.

If you find this forum useful, please consider paying back to the community in your own areas of expertise. -- Kevin Durette - https://www.linkedin.com/in/kevindurette
T
Rank
Userlevel 3
Badge +5

Hi,

 

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

Terms & ConditionsCookie settings