How to change the the Default Oracle Login and Password in Applications Manager

[Legacy User]

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:

• Theso_idstable in the database.
• TheMasters.propertiesfile in thedatadirectory.
• TheISAIMPORTfile in themapdirectory.

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 theInstallation 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 theso_idstable. 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 theMasters.propertiesfile in thedatadirectory. 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 theYfor encrypted toN.
   • 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 theO~DBLOGIN~line in theISAIMPORT.datfile in themapdirectory. 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

[Kristopher_Thomas_221]

Some customers have found it easier to delete the Masters.properties

file and let the awinstall utility recreate it and encrypt.

To do this follow steps 1 through 3 as noted above.

Instead of

manually editing the Masters.propeties file as mentioned in step 4. You can

make a backup copy of the Masters.propeties and then delete the original file.

Next run awinstall, select "yes" to the "is

everything correct?" prompt, enter in the new password when prompted,

selection option 1 for install/update, and allow process to finish.

The awinstall process will automatically recreate the

Masters.properties file and encrypt the password information.


Start up all processes.

[Mohd Zain Akbar]

Hi doug,

 

We are getting so_ids table in 3 schemas three schemas in DEVOPS1 database, do we need to change the password in all three.

 

OWNER                          OBJECT_NAM OBJECT_TYPE

------------------------------ ---------- -------------------

SYSTEM                         SO_IDS     TABLE

AWQA                           SO_IDS     TABLE

APPWORX                     SO_IDS     TABLE

 

SQL> select name from V$database;

 

NAME

---------

DEVOPS1

[Douglas Hammon]

You just need to change the password on the schema for the Applications Manage database. You can look in the master's $AW_HOME/site/awenv.ini for which one of the three that is.

Look under the [install] section of that file for the following line:

DB_ID=

it will contain the schema you should log into to run the sql statements in this post.

[Phearith_Mao_417]

Just to elaborate and simplify this process, I've listed the steps below with a number of screenshots as well.

1. Stop all processes
   
   https://us.v-cdn.net/5019921/uploads/editor/wo/ai454u7kkcpk.jpg" width="344">
   
   
2. Change the password in Oracle
3. Sqlplus into Oracle with the new password
   
   https://us.v-cdn.net/5019921/uploads/editor/ad/qnh9tmzlw7hf.jpg" width="675">
   
   
4. Run the following sql:
   update so_ids set so_encrypted = 'N' where so_login = '<AM Oracle user>';
   commit;
   
   https://us.v-cdn.net/5019921/uploads/editor/ty/77pteb1q67h6.jpg" width="687">
   
   
5. Exit Sqlplus and make a backup of the Masters.properties file
   
   https://us.v-cdn.net/5019921/uploads/editor/6v/c7rvygu0z993.jpg" width="789">
   
   
6. Run awinstall until AFTER you enter in the new password. Then you can go ahead and quit. You will see below that a new Masters.properties file is created.
   
   https://us.v-cdn.net/5019921/uploads/editor/qm/0mxi75apqhx5.jpg" width="866">
   
   
7. Startso all
8. Run the command 'awexe id_recrypt' to re-encrypt password that was unencrypted in step 4
   
   
   
   
9. Password change complete