Tuesday, 27 May 2014

Unable to login RWMS application after fresh installation

====================================================

I have installed Oracle Retail Warehouse Management System(RWMS) on RHEL 6.2. Installation had done successfully but when I tried to login RWMS application , it was showing error "Invalid User / or Password".
I searched a lot on google but didn't get solution. Finally I came to know the following facts:

1. RWMS installation user and application users are different.

2. When we pass credentials and try to login , application validate the user from DMS_USER table.

3. RWMS application's user are stored in DMS_USER table. These tables are owned by RWMS schema user.

4. With fresh installation of RWMS , only PR(Production) facility comes.

Cause: DMS_USER table of RWMS schema is blank.

Solution: 

1. cd <INSTALL_DIR>/rwms14/Install_Data/Source.
    Example: /u01/SIM_INSTALL_DIR/rwms/installer/rwms14/Install_Data/Source/base_dms_user.sql

2. export ORACLE_SID=<rwmsDB> // database of RWMS 

3. export ORACLE_HOME=<oracle_home_path>

4. Login to RWMS schema as: sqlplus <rwms_user>/<rwms_user_password>

5. Run base_dms_user.sql

    SQL>@base_dms_user.sql

6. Provide the username and password as 



7. Password must contain Alphabet and Numbers.

8. Check DMS_USER table, you will get one new record with assigned  username.

Now login into RWMS application with above created username/password and facility should be PR.

Good luck!!!!




No comments:

Post a Comment