ora-01017 invalid username/password logon denied

[former_member290907]

Hi Folks,

We have installed ECC 6.0 EHP 6 system (SID – ECD) on distributed environment. After completing the installation we are getting return code 12 error while executing R3trans –d command (screenshot attached for your reference). In trans.log we found that SAPSR3 user is not able to login to DB and giving invalid userid/password error and SAPUSER table/view does not exist though I checked and found that table exist with help of queries SELECT COUNT(*) FROM ALL_OBJECTS WHERE OBJECT_TYPE IN ('TABLE','VIEW')AND OBJECT_NAME='SAPUSER';

SELECT OWNER FROM DBA_TABLES WHERE TABLE_NAME = 'SAPUSER';. Also I reset the SAPSR3 password with the help of query ALTER USER SAPSR3 IDENTIFIED BY   but still getting the same error. I have also referred sap note 400241 - Problems with ops$ or sapr3 connect to Oracle and executed all general checks which went fine.

Please help to resolve this issue.

Thanks

[fidel_vales · Accepted solution]

Hi,

the first thing to know (apart of the trans.log requested) is if you are using the "clasic" OP$ connection or the new SSFS as the solutions are different and (I think) not covered on the note