ORA-01017: invalid username/password; logon denied

[Former Member]

Hi,

We have recently done system refresh from production to quality system. After refresh SAP is up and running well. We can schedule DB13 activities without any problem. But we face a problem "ORA-01017: invalid username/password; logon denied", when we try to schedule brtools from ORA<SID>, it's complaining about invalid username, and password. The R3trans works fine from <SID>ADM.

It should not ask password when we issue ORA<SID> SQLPLUS /, but it's aksing.

Anybody can advice on this issue?

Thanks,

Kris

[Former Member · Accepted solution]

Hi Volker,

Do I need to create OPS$ORA<SID> (SID is Quality system)? After system copy, I see there is only OPS$ORA<SID> (SID is Production system) exists on the Quality system after refresh.

Is there any note which can assist on creating the user OPS$ORA<SID> (SID is Quality system)? or Should I run the oradbusr.sql script again?

Thanks,

Kris

[volker_borowski2 · Accepted solution]

Should I run the oradbusr.sql script again?

Yes

This will give you additional OPS$-Users for your QAS-SID

Volker

[Former Member]

Hi Volker,

Thank you. I have executed oradbusr.sql, then the brtools start working fine. I can successfully SQLPLUS / as well.

Thanks,

Kris

[Former Member]

As user ORA<SID>, I can connect sqlplus "/as sysdba"

But when I issue the command ORA<SID> sqlplus /, throwing ora-01017 error.

Thanks,

Kris

[volker_borowski2]

Hi,

this is related to the script oradbusr.sql.

There are a couple of diffrent versions around, and from some point on,

the new scripts did not create the OPS$ORASID user any more.

I think the Script zip-attached to Note 50088 (allthough for Windows),

which is version 6, still creates the OPS$ORASID User.

/*----------------------------------------------------------------------------------*/
/*  oradbusr.sql creates the Oracle Default Users for Operating                     */
/*  system based DB authentication                                                  */
/*  @(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/ORADBUSR.SQL#6 $ */

Volker

[Former Member]

Hi Eric,

I have followed the same notes to create OPS$ and run sapdba role as well. The DB13 works fine, and brtools run well as <SID>ADM.

But the problem is happening for ORA<SID>?

Not sure what makes difference?

Thanks,

Kris

[former_member204746]

try:

sqlplus / as sysdba

do you have the same issue?

[former_member204746]

this is one of the most frequently asked question:

SAP notes 134592 and 400241.