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