SAP Note 1519872
This note describes the configuration of an SAP installation with the SAP-pecific database user profile SAPUPROF.
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
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).
- 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.