Clarity Service Management

Expand all | Collapse all

Migrating to new Database server.

Jump to Best Answer
  • 1.  Migrating to new Database server.

    Posted 08-27-2014 02:31 PM

    Hello All,

     

    Our Database folks are needing to move our current production MDB to a new server.

    Is there anything else I should take in to consideration other than running 'pdm_configure' and changing the server host?

     

    Thanks in advance.



  • 2.  Re: Migrating to new Database server.
    Best Answer

    Posted 08-27-2014 05:52 PM

    After move the mdb to new server, you would need to make sure ServiceDesk user is created, and it has sysadmin role, then run the procedure  sp_change_users_login 'AUTO_FIX','ServiceDesk'. Once all these are done,

    then for SDM versions before 12.9, you can run pdm_configure from SDM primary side to point to the new mdb server.

    For 12.9,   before you run pdm_configure, you would need to follow the steps in tech doc TEC613359. For your conveience,

    I copy it here for you:"

    Tech Document
    Title:  Unable to run pdm_configure after copying an MDB from a Production Environment to Development or Test Environment


    Description:

    Whether building out a new Service Desk Manager 12.9 Test/Dev system, or refreshing the data on an existing Service Desk Manager 12.9 Test/Dev system by copying the MDB from Prod to Test/Dev, when you try to run pdm_configure after the MDB restore it will fail with an error stating: "Already following servers are using same Database: server-name-of-system-where-mdb-came-from. Make these servers as Inactive to proceed."

    Solution:

    Using either SQL Management Studio, or SQLPlus (or any other db mangement tool) for Oracle, set the value of the "del" field on all rows in the usp_servers table to have a value of "1".

    Then run pdm_configure on the Primary or Background server.
    This will add that server (which you ran pdm_configure on) to the usp_servers table.
    If you your Test/Dev environment has Secondary servers, or if you are using Advanced Availability, you will now need to log into Service Desk Manager on the Primary or Background server and re-add any Secondary servers, or Standby servers and App servers that you have in your Test/Dev environment.

    Next, you will need to edit the configuration that is being used to ensure you have the appropriate daemons configured on each of those servers.

    Once you have completed the server configuration, you will then need to run pdm_configure on any Secondary servers, or Standby servers and App servers that you have in your Test/Dev environment.

    "

    Here Test/Dev simply means from one install to another.

    Hope this helps. Thanks _Chi