CARDS IP Changes: Difference between revisions

From AquaWiki
Jump to navigation Jump to search
(Created page with "In the event that an IP address change is immenent, you will want to do the following: App Server 1.) D:\CWF\Apache\conf - httpd.conf - look for anything that might have an...")
 
No edit summary
 
(5 intermediate revisions by 2 users 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 ===


1.) 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)
2.) 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.
3.) 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)
4.) 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 ===


1.) 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
2.) 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  
1.) 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.