CARDS IP Changes: Difference between revisions

From AquaWiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 1: Line 1:
In the event that an IP address change is immenent, you will want to do the following:
In the event that an IP address change is immenent, you will want to do the following:


App Server
=== App Server ===


*  '''D:\CWF\Apache\conf''' - httpd.conf - look for anything that might have an ip address such as there might be a 'Listen 80' where nothing needs to be changed or it might be 'Listen 12.123.12.123:80' where the IP needs to be changed. (set to application server IP)
*  '''D:\CWF\Apache\conf''' - httpd.conf - look for anything that might have an ip address such as there might be a 'Listen 80' where nothing needs to be changed or it might be 'Listen 12.123.12.123:80' where the IP needs to be changed. (set to application server IP)
Line 9: Line 9:
* '''D:\oracle\product\19.0.0.0\client_1\network\admin''' - there are two files the '''listener.ora''' and the '''tnsnames.ora'''.  You will want to check to see fi the HOST entry has an IP or a hostname.  If its a hostname, leave it alone and if its an IP change accordingly (this is the DB IP address)
* '''D:\oracle\product\19.0.0.0\client_1\network\admin''' - there are two files the '''listener.ora''' and the '''tnsnames.ora'''.  You will want to check to see fi the HOST entry has an IP or a hostname.  If its a hostname, leave it alone and if its an IP change accordingly (this is the DB IP address)


DB Server
=== DB Server ===


*  '''D:\oracle\product\19.0.0.0\client_1\network\admin''' - there is one file that needs adjusting, '''tnsnames.ora'''.  You will want to check to see fi the HOST entry has an IP or a hostname.  If its a hostname, leave it alone and if its an IP change accordingly (this is the DB IP address)
*  '''D:\oracle\product\19.0.0.0\client_1\network\admin''' - there is one file that needs adjusting, '''tnsnames.ora'''.  You will want to check to see fi the HOST entry has an IP or a hostname.  If its a hostname, leave it alone and if its an IP change accordingly (this is the DB IP address)

Revision as of 16:53, 4 April 2022

In the event that an IP address change is immenent, you will want to do the following:

App Server

  • D:\CWF\Apache\conf - httpd.conf - look for anything that might have an ip address such as there might be a 'Listen 80' where nothing needs to be changed or it might be 'Listen 12.123.12.123:80' where the IP needs to be changed. (set to application server IP)
  • D:\CWF\Apache\conf\cwf\cwf.conf do a Ctrl+f for 'ProxyPass' and update the the IPs there to that of the APP IP address.
  • D:\CWF\Apache\conf\cwf\ssl.conf - again look for any IP address, if the servername is FQDN, leave it as such. If its an IP address, change it accordingly. (set to application server IP)
  • D:\CWF\tomcat\lib - There are various *.properties files in here where the connect string may be referencing the IP address. Mainly looking for anything that has a connectstring such as 123.12.123.12:5006:cards. (This is the DB IP address)
  • D:\oracle\product\19.0.0.0\client_1\network\admin - there are two files the listener.ora and the tnsnames.ora. You will want to check to see fi the HOST entry has an IP or a hostname. If its a hostname, leave it alone and if its an IP change accordingly (this is the DB IP address)

DB Server

  • D:\oracle\product\19.0.0.0\client_1\network\admin - there is one file that needs adjusting, tnsnames.ora. You will want to check to see fi the HOST entry has an IP or a hostname. If its a hostname, leave it alone and if its an IP change accordingly (this is the DB IP address)
  • D:\oracle\product\19.0.0.0\dbhome_1\network\admin - there are two files the listener.ora and the tnsnames.ora. You will want to check to see fi the HOST entry has an IP or a hostname. If its a hostname, leave it alone and if its an IP change accordingly (this is the DB IP address)

PL/SQL Developer

  • Log into PL/SQL developer and 'select p.*, p.rowid from param_values where key='APP_SERVER_URL'; This should be set to your FQDN, if so leave it alone if its an IP...update it.