System Usernames and Passwords {USERS-21}

As can be seen in this option, usernames and passwords are contained in an Oracle table, where the passwords can be changed by the user. It is absolutely essential that the utmost care be taken in giving access to this option, as well in the way in which these passwords are changed! 

• Changes to the following user password is not allowed in this option.
• ITSCOMP
• OC4JADMIN - Must be changed manually via OC4J (10131 - Enterprise Manager)
• ORCLADMIN - Must be changed manually via OIDADMIN GUI.

• Log onto the ITS system, access the menu option USERS-21.
• Change the password for the desired users to your new selected value.
• After you have saved the new data, log onto your Oracle database with the system user and execute the following command for the user 
  

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production

With the Partitioning, OLAP and Data Mining options

SQL> alter user web identified by web123;  (note, this will then be the password that you have chosen for the specific user)

User altered. 

• User "WEB" is being utilized for the ITS iEnabler systems and therefore you need to change the password for the Database Access Descriptor as well to ensure that the products using this schema also works correctly.

• This can be done in two ways.

• Log onto the application server on Unix as Oracle user and run the following  script.
• sh $ITS_PATH/g05uni $ITS_PATH/gen/g03uni

• g03uni – lookup password that was changed in gdmoun – modify password in $ORACLE_BAS/Apache/modplsql/conf/dads.conf as per gdmoun for WEB and calls lscript g04uni – this obfuscates the password in $ORACLE_BAS/Apache/modplsql/conf/dads.conf and restarts opmnctl process HTTP

• Log onto Oracle Enterprise Manager with your administrator username (normally IAS_ADMIN) and your administrator password.

• Access the midtier instance. (you will need to supply the midtier username (also IAS_ADMIN) and the password.
  

• Click on the HTTP Server system component.

• Click to administration tab

  
  

• Click on PL/SQL Properties

• Scroll down to the section containing the DAD’s configuration.
  

• Click on the DAD as define for your institution, normally /pls/its.

• Now change the password for the web user accordingly and apply your changes.
  

• Ensure that your Connection is verified.  This is indicated by the green arrow on the right hand side.