E-Notebook: Needed configuration changes when E-Notebook application server is cloned

1. Introduction

Here are the steps to be performed for configuration changes when application server is cloned as a new system as well as the database is cloned and restored as a new oracle instance.

2. Configuration Steps for Cloned Servers

2.1. Prerequisites

a) The cloned Application server shall be available with admin credentials.

b) The Database shall be cloned completely and the TNS entries should be available.

2.2. Application server configuration changes

a) Add the new service in the TNS file on the cloned system

• Open the tnsnames.ora file and add the details for the new oracle service.
• Save the tnsnames.ora file.
• Perform tnsping to the new service to ensure that it is reaching to the required server.
• Test the connecting through SQL plus window and ensure, it is not pointing to the old application server’s database.

b) Edit the OracleConfig.xml file

• Go to ELN installation folder (c:\Program Files (x86)\PerkinElmer\E-Notebook)
• Take backup of OracleConfig.xml
• Open OracleConfig.xml file
• Set the ‘Data Source=’ value and set the new TNS value.
• Save and close the file
• Perform IIS reset on new application server

c) Update Web.config file

• Go to ELN installation folder (c:\Program Files (x86)\PerkinElmer\E-Notebook)
• Take backup of Web.Config
• Open Web.Config file
• Look for the application server name and replace it with the new server name (the server name might be at multiple places in the file)
• Save and close the file
• Perform IIS reset on new application server

d) Update Clickonce – ENClientConfig.xml file

• Go to Clickonce folder under ELN installation location (c:\Program Files (x86)\PerkinElmer\E-Notebook>\ClickOnce\)
• Create a copy of latest clickonce folder, For example if the latest folder is ENotebook_17_1_1_0 create a copy of the folder and name it ENotebook_17_1_1_1.
• Open the new folder and open the ENClientConfig.xml file and update the server names
• Save and close the file

e) Update Clickonce – mage_eln.bat

• Go to ClickOnce folder under ELN installation location (c:\Program Files (x86)\PerkinElmer\E-Notebook>\ClickOnce\)
• Take backup of mage_eln.bat file
• Edit the mage_eln.bat file to reflect the new ClickOnce version. For example, if the ClickOnce version is 17.1.1.1, you must update all the occurrences of 17_1_1_0 to 17_1_1_1 and 17.1.1.0 to 17.1.1.1
• Save and close the file
• Run mage_eln.bat using the Run as Administrator option.
• Once completed, press enter key to close command prompt.
• Uninstall the clickonce client and reinstall it
• Test the application.

f) Update ELN parameters table

• Go to ELN Parameter table and update the new application server name