Reconfiguring Enterprise Reporter after a domain name change
Prev Reconfiguring CommandCentral Enterprise Reporter 5.1 Next

Reconfiguring Enterprise Reporter after a domain name change

If you change the domain name of the domain on which Enterprise Reporter runs, you need to reconfigure Enterprise Reporter so it runs properly.

Table: Process to reconfigure Enterprise Reporter after a domain name change outlines the process to reconfigure Enterprise Reporter after a domain name change.

Table: Process to reconfigure Enterprise Reporter after a domain name change

Step

Description

1

Back up your reports. If you do not back up the reports, they will be lost.

See “To back up your reports”.

2

Delete the UserManagement.xml file.

See “To delete UserManagement.xml”.

3

Edit the ERUsers.ini file.

See “To edit ERUsers.ini”.

4

Recreate the cognos database user.

See “To recreate the cognos database user”.

5

Edit the ABAuthSource and RBAuthSource files.

See “To edit the ABAuthSource and RBAuthSource files”.

6

If the Oracle database instance is on the same host as Enterprise Reporter, do one of the following:

7

Reconfigure Enterprise Reporter.

See Reconfiguring Enterprise Reporter 5.1.

8

If you use business views, add them to Enterprise Reporter's metamodel.

See “To add business views to Enterprise Reporter's metamodel”.

9

If you use custom attributes, add them to Enterprise Reporter's metamodel.

See “To add custom attributes to Enterprise Reporter's metamodel”.

10

Import the reports that you backed up in step 1.

See “To import reports”.

To back up your reports

To delete UserManagement.xml

  1. On the Enterprise Reporter host, navigate to the following directory:

    Solaris

    /opt/VRTSsmweb/webgui/sm/config

    Windows

    install_location\VRTSsmweb\webgui\sm\config

    where install_location is the directory in which you installed Enterprise Reporter. The default directory for Windows is C:\Program Files\VERITAS

  2. Delete the file UserManagement.xml

To edit ERUsers.ini

  1. On the Enterprise Reporter host, navigate to the following directory:

    Solaris

    configuration_directory/VRTSccer/conf

    Windows

    configuration_directory\VRTSccer\conf

    where configuration_directory is the directory in which you chose to store Enterprise Reporter configuration files. The default directories are /var for Solaris and C:\Program Files\VERITAS for Windows.

  2. Open the file ERUsers.ini in a text editor.

  3. In the file, under the section [function cognos_updates] change the domain name to the new domain name.

To recreate the cognos database user

  1. On the Enterprise Reporter host, stop Cognos as follows:

    Solaris

    • Go to /opt/VRTSccer/bin

    • To set your environment variable, type the following command:

      . setenv.sh

    • To stop Cognos, type the following command:

      ./ccercog stop

    Windows

    Use Windows' Service Control Manager to stop the service Cognos8.

  2. On the host where the Oracle database instance resides, run the following commands at the SQL*Plus prompt:

    SQL> CONNECT SYS/password AS SYSDBA

    where sys and password are the database credentials.

    SQL> drop user SAHARA_COGNOS cascade;

    SQL> create user SAHARA_COGNOS identified by sahara default tablespace SAHARA_CGNS_01 quota unlimited on SAHARA_CGNS_01;

    SQL> grant create procedure,create sequence,create session,create table,create trigger,create view,SAHARA_READ to SAHARA_COGNOS;

    SQL> COMMIT;

    SQL> QUIT;

To edit the ABAuthSource and RBAuthSource files

  1. On the Enterprise Reporter host, navigate to the following directory:

    Solaris

    configuration_directory/VRTSat

    Windows

    configuration_directory\Security\Authentication\systemprofile

    where configuration_directory is the directory in which you chose to store Enterprise Reporter configuration files. The default directories are /var for Solaris and C:\Program Files\VERITAS for Windows.

  2. Open the files ABAuthSource and RBAuthSource in a text editor.

  3. In the files, change the domain name to the new domain name.

To modify the ccer_conf file (Solaris)

  1. On the Enterprise Reporter host, navigate to /etc/vx/ccer/

  2. Open the file ccer_conf in a text editor.

  3. Change the entry for CCER_ORAHOST to the new domain name.

To update the ER_HOST_FQHN registry entry (Windows)

To add business views to Enterprise Reporter's metamodel

  1. On the Enterprise Reporter host, open an operating system console and change to the following directory:

    Solaris

    install_location/VRTSccer/bin

    Windows

    install_location\VRTSccer\bin

    where install_location is the directory in which you installed Enterprise Reporter. The default directories are /opt for Solaris and C:\Program Files\VERITAS for Windows.

  2. Type the following command:

    Solaris

    update_metamodel.sh

    Windows

    update_metamodel.bat

To add custom attributes to Enterprise Reporter's metamodel

  1. On the Enterprise Reporter host, open an operating system console and change to the following directory:

    Solaris

    install_location/VRTSccer/bin

    Windows

    install_location\VRTSccer\bin

    where install_location is the directory in which you installed Enterprise Reporter. The default directories are /opt for Solaris and C:\Program Files\VERITAS for Windows.

  2. Type the following command:

    Solaris

    update_attributes.sh

    Windows

    update_attributes.bat

To import reports

Prev Up Next
Reconfiguring Enterprise Reporter 5.1 Home Uninstalling CommandCentral Enterprise Reporter 5.1