Changing the Default Oracle Login and Password in Applications Manager

The steps below explain how to change the login name and password for the Oracle database login.

When Applications Manager is installed, a database login is created by default for logging in to the Applications Manager database account (the repository). The database login is usually named the same as the database account name you provide during the installation process.

There are three places the Oracle login is stored in Applications Manager:

• The so_ids table in the database.
• The Masters.properties file in the data directory.
• The ISAIMPORT file in the map directory.

All paths are relative to the Applications Manager home directory.

Procedure

To change the Oracle password in Applications Manager:

1. Stop all the Applications Manager processes.

For directions on stopping and starting the processes, see the Installation Guide.

2. Before changing the password on the Oracle side, change the name/password for your database login in Applications Manager. If the password is already changed, you will need to go into SQL*Plus and update the so_ids table. To change the database login, issue the following SQL statements. You may not need to set a connect string.

update so_ids set so_login = '<new_DB_login>' where so_login = '<old_DB_login>';

update so_ids set so_passwd = '<new_DB_password>' where so_login = '<new_DB_login>';

update so_ids set so_encrypted = 'N' where so_login = '<new_DB_login>';

3. Change the password in Oracle.
4. Edit the automation engine line in the Masters.properties file in the data directory. The automation engine line uses the format <master name>=<IP address> <login name> <port> <service name or PDB service name for Oracle 12c> <Encrypted Y/N> ENC:<encrypted user name>\=\= ENC:<encrypted password>\=\=.
   • Change the Y for encrypted to N.
   • Replace the encrypted user name (ENC:<encrypted user name>=/=/) and password (ENC:<encrypted password>=/=/) with an unencrypted user name and password.
5. If the database login name was changed, edit the O~DBLOGIN~ line in the ISAIMPORT.dat file in the map directory. A sample is shown below:

 N~NODE~<agent name>

 O~DBLOGIN~<login name>

6. Start the Applications Manager processes.
7. From the command prompt, issue the following command:

Awexe id_recrypt