Play with E1Local

My client calls me and told that he deleted JDE user from E1local by mistake and now not able to login to E1. Phew !!!

First option is uninstall E1local, delete all from registry and install again.  And it's painful takes whole lot of time.

Here is a smart way to do that.

These steps require a knowledge of Oracle Database
1.    Add domain user to Local Oracle DBA Group

2.    Change SQLNET.ORA
x:\oracle\E1Local\network\admin
or
x:\app\E1local\network\admin
SQLNET.AUTHENTICATION_SERVICES=(NTS)
 
3.    Login to SQLPLUS of E1local
x:\oracle\E1Local\bin\sqlplus  / as sysdba
or
x:\app\E1local\bin\sqlplus / as sysdba
 
4.    SQL> select username, account_status, expiry_date, lock_date from dba_users;
 
5.    If JDE user is deleted then do below steps else goto step 6
SQL>Create user JDE identified by password
(password should be same E1  JDE password.  Oracle 11g password are case sensitive)
SQL>GRANT CREATE SESSION, UNLIMITED TABLESPACE, CREATE TABLE, CREATE CLUSTER, CREATE SEQUENCE, CREATE PROCEDURE, CREATE TRIGGER, ANALYZE ANY, CREATE TYPE, CREATE OPERATOR, CREATE INDEXTYPE, SELECT ANY DICTIONARY to JDE
6.    If JDE user is expired(locked) then do below step else goto step 7
SQL> Alter user JDE Account Unlock;
SQL> Alter user JDE identified by password;
(password should be same E1  JDE password.  Oracle 11g password are case sensitive)
 
7.    If System user is expired(locked) then do below step else goto step 8
Cmd> x:\E910\system\bin32\reconfiguremsde.exe -tORACLE –u
SQL > Alter user System Account Unlock;
SQL> Alter user System identified by admin
Cmd> x:\E910\system\bin32\reconfiguremsde.exe -tORACLE –padmin
 
8.    Check the profile value for PASSWORD_LIFE_TIME:
SQL>select * from DBA_PROFILES where PROFILE='DEFAULT';
SQL>ALTER PROFILE DEFAULT LIMIT FAILED_LOGIN_ATTEMPTS UNLIMITED PASSWORD_LIFE_TIME UNLIMITED;
 
9.    SQLNET.AUTHENTICATION_SERVICES=(NONE)
 
10.    Log off and log In ( Not required but recommended)
 
11.    Login to Fat Client


This takes 5 minute and I am able to login to E1.