ORA-1403 when accessing table SAPUSER

Symptom

When you trying to execute command tp connect SID pf=TP-PROFILE, you getting below error,

ORA-1403 when accessing table SAPUSER

Caused

Table SAPUSER does not contain any entries / incorrect entries.
Table SAPUSER does not contain SAPSR3 or SAP user.

Solution

1. Login to operating system as ORASID.View the table SAPUSER. Confirm all
entries is correct.

select * from OPS$<sid>ADM.SAPUSER;

2. If there is no SAPSR3 or SAP is created. You need to create manually. First, you need to know
the password maintained for the SAPSR3 or SAP.

INSERT into "OPS$</sid><sid>ADM".SAPUSER values ('SAPSR3 or SAP</sid><sid>','<password>');
commit;

You May Also Like

Leave a Reply?