Update the Database Host, Password, Instance, Service Name, or Port

To comply with changes in your environment or for other reasons, you can change the following database settings: host name, port number, instance name, or service name. CA Service Catalog components use these settings to communicate with each other and the database.
casm1401
To comply with changes in your environment or for other reasons, you can change the following database settings: host name, port number, instance name, or service name. CA Service Catalog components use these settings to communicate with each other and the database.
Follow these steps:
  1. Perform the following prerequisite tasks:
    1. To update the database host name, update the operating system computer name of the computer which has the database. For more information, see your operating system documentation.
    2. Update the database settings in your DBMS software (Oracle or SQL Server). For more information, see your DBMS documentation.
    3. Verify that the updated DBMS is accessible from every DBMS client on every CA Service Catalog computer. Use your DBMS client software (not CA Service Catalog) to perform this step.
  2. Enter the following URL in your browser for the CA Service Catalog installation that you want to update:
    http://
    hostname:portnumber
    /usm/config
  3. Enter the password to log in to the setup utility.
    The setup utility opens on the Database tab.
  4. Enter the new password for the database user in the Application User Settings section only if
    both
    of the following conditions exist.
    • You are using SQL Server.
    • The database was backed up and restored on a new computer.
    Confirm the password and save your changes.
  5. (Optional) When you are prompted for your password, specify your existing password to continue using it.
  6. Specify new values for the settings that you want to change, as follows:
    SQL Server
    If applicable update the instance name for the MDB.
    Default:
    MSSQLSERVER
    Oracle
    If applicable, update the service name. Every Oracle database or service has a service name. The service name of an Oracle database is typically its global database name. Enter the service name of the Oracle database or other service that you want to access.
  7. If applicable, update the port number.
  8. Save your changes.
  9. Restart the Windows services for CA Service Catalog to make your updates take effect.
  10. Make the same updates on all remaining CA Service Catalog computers in your environment.
  11. Verify that CA Service Catalog is running correctly, as follows:
    1. Log in to CA Service Catalog.
    2. Perform administrative tasks. Create services. Also, create and process requests.