Internal‎ > ‎

Resetting Oracle Passwords

If you ever get this error from a forms URL e.g. forms.422x.com

           

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Oracle][ODBC][Ora]ORA-28001: the password has expired

/appsynthesis/appmanager/includes/classes/data/clsDBHelper.asp, line 46

           

Login to forms.422x.com using Remote Desktop, launch TOAD

Log into the system account in Oracle, launch an editor window

Execute the following code :

           

alter profile default limit 
PASSWORD_LIFE_TIME UNLIMITED 
PASSWORD_REUSE_MAX UNLIMITED  
  

alter user APPMANAGER_D_EDUCLIENT identified by password; 
alter user ORIGINMANAGER_D_EDUCLIENT identified by password; 
alter user CUSTOMERMANAGER_D_EDUCLIENT identified by password; 
alter user BACKENDMANAGER_D_EDUCLIENT identified by password; 
alter user SUPERMANAGER_D_EDUCLIENT identified by password;

alter user APPMANAGER_S_EDUCLIENT identified by password; 
alter user ORIGINMANAGER_S_EDUCLIENT identified by password; 
alter user CUSTOMERMANAGER_S_EDUCLIENT identified by password; 
alter user BACKENDMANAGER_S_EDUCLIENT identified by password; 
alter user SUPERMANAGER_S_EDUCLIENT identified by password;   

alter user APPMANAGER_L_EDUCLIENT identified by password; 
alter user ORIGINMANAGER_L_EDUCLIENT identified by password; 
alter user CUSTOMERMANAGER_L_EDUCLIENT identified by password; 
alter user BACKENDMANAGER_L_EDUCLIENT identified by password; 
alter user SUPERMANAGER_L_EDUCLIENT identified by password;

   

Fortunately, this error will never actually ever happen again as no systems will ever be built from scratch without this being run as it has been added to the installation scripts for all clients.


Comments