ORA-01017 - Username/password logon denied.

[Former Member]

Hi Experts,

I am getting the below error message

OS : Solaris

Database : Oracle 10.2

SAP PI 7.0

When i Start the SAP, i receive a below error message(Startsap log) like

ORA-01017: Invalid username/password; logon denied.

I understand that there was communication problem between SAP and DB.

1, Which user id communicate between SAP and DB (Oracle)

is it OPS$ user.

2,I ran R3trans -d, and receive the above error message. ( I am sure that we can run R3trans -d for Ms SQL and DB2 database), I am not sure we can R3trans -d for Orcale DB.

Could you please someone give details and steps to fix the issue.

Thanks

Thirumal

[Former Member]

Hi,

Which user id communicate between SAP and DB (Oracle) is it OPS$ user.

In Solaris OPS$<SID>adm & OPS$ORA<SID> are used.

Please chek if recently change the password of the these users.

,I ran R3trans -d, and receive the above error message. ( I am sure that we can run R3trans -d for Ms SQL and DB2 database), I am not sure we can R3trans -d for Orcale DB.

Yes,we can user R3trans-d for the oracle database.

Could you please someone give details and steps to fix the issue

.

To fix this you have to deal at the oracle level by logging to database by SQLPLUS.

Shambo

[fidel_vales]

Hi,

Lets go step by step.

So the first one is to ask you

> have you read the already mentioned note 400241?

I bet you that the solution to your problem is there.

You also should understand how the ops$ mechanism work in a SAP environment.

second step, as I do not have access to your system/logs/database...

- execute R3trans -x as user <sid>adm

this command will generate a log file called "trans.log" in the same directory

post here the 20 lines before the error (including the error).

Please, format the lines with the "code" as indicated on the right.

Then we will be able to point you exactly where you are having the error (may be even the line in the note 400241 that explains it) instead of guessing

[Former Member]

Hi

OPS$<SID> user connect with oracle and communicate with oracle database

only sapr3 user can use database server authoriztion

tht may be any database server ie any RDBMS ok

got it

Regards

Bhaskar

[Former Member]

Yes we can use R3trans -d for Oracle also.It creates a trans.log in the current directory.

What is the change you have done recently on system ? Is it a new installation or a system copy ?

Have you changed db user passwords recently ?

Vinayak

[Former Member]

Hi,

check SAP Note 400241 - Problems with ops$ or sapr3 connect to Oracle

regards,

kaushal