Wonder how to change E1 E900 OEE database system password ? Below are the guide:
1. Stop the 2 windows services called 'OracleServiceE1Local' and 'OracleE1LocalTNSListener'
2. Change the sqlnet.ora for the SQLNET.AUTHENTICATION_SERVICES=(NTS)
3. Start the 2 services.
4. Go to command prompt, type below :
SQLplus / as sysdba;
alter user sys identified by adminpassword (sysdba role)
5. Change the sqlnet.ora back for the SQLNET.AUTHENTICATION_SERVICES=(NONE)
6. Restart the 2 services.
note: Applicable to version E910 only
After you have changed the password, you need to use reconfigureMSDE.exe to encrypt the password:
Key in the password as shown above and change to the encrypted E1 passowrd.
Lastly login to E1 fat client as normal..Eg. DEMO : DEMO
Hope this help...
1. Stop the 2 windows services called 'OracleServiceE1Local' and 'OracleE1LocalTNSListener'
2. Change the sqlnet.ora for the SQLNET.AUTHENTICATION_SERVICES=(NTS)
3. Start the 2 services.
4. Go to command prompt, type below :
SQLplus / as sysdba;
alter user sys identified by adminpassword (sysdba role)
5. Change the sqlnet.ora back for the SQLNET.AUTHENTICATION_SERVICES=(NONE)
6. Restart the 2 services.
note: Applicable to version E910 only
After you have changed the password, you need to use reconfigureMSDE.exe to encrypt the password:
Key in the password as shown above and change to the encrypted E1 passowrd.
Lastly login to E1 fat client as normal..Eg. DEMO : DEMO
note: just in case above method failed, you may skip above and decrypt the password by using reconfigureMSDE.exe and encrypt once again.
Hope this help...
No comments:
Post a Comment