Forgot Password for user id SAP* in client 000

You need to log in to client 000 to apply support packages but you forgot your SAP* pasword in client 000 and you don’t know what to do now.

1. You can logon as DDIC and change the SAP* password

2. You can delete the userid, SAP*, from the database, SAP has this userid defined in its kernel (the SAP executable code that sits at the operating system level, i.e., disp+work). When this situation exists, the password defined in the SAP code for SAP* is PASS.

# su – orasid
hostsid:orasid 1> sqlplus /nolog

SQL*Plus: Release 9.2.0.4.0 – Production on Thu Jan 24 10:34:20 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> connect /as sysdba
Connected.
SQL> select * from <SchemaOwner>.usr02 where bname=’SAP*’ and mandt=’000′;

Run query to check return. Change Select to Delete and run again.

SQL> delete from <SchemaOwner>.usr02 where bname=’SAP*’ and mandt=’000′;
1 row deleted.
SQL> commit;
Commit complete.