Managing admin and database passwords
If you change passwords for the admin user (Settings > User Management) or change passwords for specific users in the Oracle database, you must also run the er_password.pl script. This script updates the user password in the Oracle database, Cognos, Enterprise Reporter, and the processes that extract, transform, and load data. If you do not run this script, users might encounter errors when they run reports or access data.
Use this script if you change the password on the following Enterprise Reporter and Oracle user accounts.
Table: User accounts requiring the er_password.pl script
|
User
|
Description |
|
admin
|
Enterprise Reporter user. Accepts updated packages and namespaces. Changing passwords for this user without running the er_password.pl script causes all package and namespace changes to fail. The er_password.pl script updates the admin password in VxAT and stores those credentials in the ERUsers.ini configuration file.
|
|
SAHARA_APP
|
Oracle user. Accessed to import business view data from Oracle, to export to Oracle, and to perform data rollups in the Extract, Transform, and Load (ETL) process. Changing passwords for this user directly in Oracle without running the script causes all three of these functions to fail. The er_password.pl script updates both the kettle shared.xml configuration file and the database pool configuration files.
|
|
SAHARA_REPORTS
|
Oracle user. Accessed by Cognos when users generate reports. Changing passwords for this user directly in Oracle without running the script causes reports to fail. The er_password.pl script updates the Cognos content store.
|
|
SAHARA_COGNOS
|
Oracle user. Accessed by Cognos to store data in the Oracle database. Changing passwords for this user directly in Oracle without running the script causes Cognos to fail. The er_password.pl script closes Cognos, updates the cogstartup.xml configuration file, and restarts Cognos.
|
|
SAHARA
|
Oracle user. Accessed by Enterprise Reporter. |
To run the change password script
-
On the Management Server, open an operating system console and log in as root (Solaris) or as a user with administrator-level privileges (Windows).
-
Change to the Enterprise Reporter bin directory. By default, this directory is:
-
To set environment variables, type the following command:
-
Type the following command to update the password for the user whose password you changed:
perl er_password.pl -u username
where username is the name of the user whose password requires an update
