CARDS IP Changes: Difference between revisions

From AquaWiki
Jump to navigation Jump to search
No edit summary
No edit summary
 
(4 intermediate revisions by one other user not shown)
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)
* 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\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\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:\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:\oracle\product\11.2.0 (or 12 versions..)\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:\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
=== DB Server ===


* D:\oracle\product\11.2.0 (or 12 version)\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)
If the server needs reboot please see [[Oracle Best Practices]] to DB shutdown process
* D:\oracle\product\11.2.0 (or 12 version)\db_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 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  
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.
* 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.

Latest revision as of 11:04, 14 October 2022

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

App Server[edit]

  • 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[edit]

If the server needs reboot please see Oracle Best Practices to DB shutdown process

  • 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.