Overview

You are preparing to clone your Oracle database to a new server with a new instance name. You have updated the Oracle Client's TNSNames to point to the new database server and you'd like to know what changes are needed in your LM server to make it work correctly.

Solution

Stop ListManager Services

Stop your ListManager services in Windows as Services, in Windows from the webserver, or in Linux.

Stop ListManager Services in Windows as Services

1. As a Windows Administrator on your webserver, click Start and type "Services"
2. Right-click on the ListManager Service
3. Click Stop
4. Right-click on the ListManagerWeb Service
5. Click Stop

Stop ListManager Services in Windows From the Webserver

1. As a Windows Administrator on your webserver, open the ListManager window
2. Press CTRL+C and the window will close
3. Open the ListManager webserver window
4. Press CTRL+C and the window will close

Stop ListManager Services in Linux

1. As root on your ListManager webserver, navigate to your ListManager directory. e.g. /usr/local/lm/bin
2. Enter ./S96lm stop to stop ListManager
3. Enter ./S96httpd-lm stop to stop ListManager webserver

Backup and Migrate the Oracle Database

1. Backup the List Manager database
   
   
2. Move the database to the new server
   
   
3. Navigate to the List Manager install directory
   
   
4. Log on to your Production ListManager server and edit 'lmcfg.txt' located in the LM install directory:
   
   • Windows: C:\Program Files\ListManager\lmcfg.txt
   • Linux: ~/ListManager/bin/lmcfg.txt
   • Update the $sql_server value to point to the new database
   • Verify if any other parameters needs to be updated if applies, for example: user, password, database name
   • Save the file

Start ListManager Services

Start your ListManager services in Windows as Services, in Windows from the webserver, or in Linux.

Start ListManager Services in Windows as Services

If ListManager is running as Services, use this method.

1. As a Windows Administrator on your webserver, click Start and type "Services"
2. Right-click on the ListManager Service
3. Click Start
4. Right-click on the ListManagerWeb Service
5. Click Start

Start ListManager Services in Windows Manually

If ListManager is not installed as Windows Services, use this method.

1. As a Windows Administrator on your webserver, click Start and type "cmd" to open the Command Prompt
2. Navigate to the ListManager installation directory. e.g. C:\Program Files\ListManager\tclweb\bin
3. Enter httpd-lm.exe

Start ListManager Services in Linux

1. As root on your ListManager webserver, navigate to your ListManager directory. e.g. /usr/local/lm/bin
2. Enter ./S96lm start to start ListManager
3. Enter ./S96httpd-lm start to start ListManager webserver

After restarting ListManager connects to your new Oracle database server without errors.