can someone tell how to connect the e1local through sqldeveloper in 9.2 standalone release?
Hi Rahul,
For connecting to E1local you have to decrypt the DB User (sys or system) password using ReconfigureDB.exe.
Follow the below steps to Decrypt the DB User password
1. Navigate to bin32 Location For example "C://E920_1/system/bin32".
2. Open the ReconfigureDB.exe
3. Left Side select the Option "Enhanced Encryption" and Right side provide the password you want to reset ( i.e admin)
4. Confirm the Password in next screen
5. Now you will receive the Message Saying that E1local password successfully reset"
Now open a command prompt and type sqlplus
Username : sys@E1local as sysdba
Password : admin
Now you will be able to connect to DB. However now you cant login into JDE, because JDE requires DB password should be Encrypted. For Login into JDE you need to encrypt the password using same ReconfigureDB.exe
1. Navigate to bin32 Location For example "C://E920_1/system/bin32".
2. Open the ReconfigureDB.exe
3. Left side provide the password (admin) and Right side select the option "Enhanced Encryption" and click ok
Now try to login into Standalone E920, It will work fine. So for login into DB using sqlplus or sql developer you have to decrypt the password and Once you are done with your Database activity encrypt the password so that you will be able to login into JD Edwards Standalone 9.2.
Best Regards
JDEE1Tips