SAP Note 1519872
Symptom
This note describes the configuration of an SAP installation with the SAP-pecific database user profile SAPUPROF.
Symptom:
SAP system does not start any more.
SAP workprocesses can not connect to the database any more.
SAP trace files contain errors similar to the following:
TRACE-INFO: 101: [ dbsloci.,00000] *** ERROR => CONNECT failed with sql error ‘28001’
TRACE-INFO: 102: [ dev trc,00000] set_ocica() -> SQL error code 28001
TRACE-INFO: 103: [ dev trc,00000] >oci_get_errmsg (con_hdl=0,rc=28001)
TRACE-INFO: 104: [ dev trc,00000] OCIErrorGet -> SQL error code: 28001
TRACE-INFO: 105: [ dev trc,00000] ORA-28001: the password has expired
Other symptoms:
You get ORA-28000 or ORA-28001 or ORA-28002 errors when you try to connect to the database (i.e. as database user SYSTEM).
Reason:
- Oracle Database Release 11.2.0.X.
- Database user profile SAPUPROF is not configured. Check this with the following query (for user SAPSR3):
SQL> select profile from dba_users where username = ‘SAPSR3’;
- With 11.2, passwords of database users must be changed every 180 days for security reasons.
For full solution, Please go through this note 1519872.