Blogroll

Get a website with Godaddy


Logo designer Fiverr Frelancer

Tuesday, October 1, 2013

Win based OEE database password change

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



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

Amazon store

alidropship plugin

alidropship plugin
alidropship plugin

Total Pageviews

About