Skip to Content
author's profile photo Former Member
Former Member

Change password on SAPR3 user

Hello,

I got request from our Security department to change the standard password of user SAPR3 to other different password.

Can you tell me is this the right procedure?

ALTER USER SAPR3 IDENTIFIED BY sap;

When I tried to change it using the Oracle Enterprise manager, after I got many logs in SM21 transaction:

"> ORA-01017: invalid username/password; logon denied

Database error 1017 at UPD access to table SWT_LOGCAT"

Or there is another way of changing this password without providing error message?

Thank you in advance.

Many regards,

Ruzica

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 21, 2007 at 05:22 PM

    You can use brtools ( it call brconnect ) to change the password

    Thanks

    Prince Jose

    Edited by: Prince Jose on Dec 21, 2007 11:22 AM

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi,

      One clarification:

      1) you MUST use brconnect ( or brtools ) to change the password of the SAPR3 user

      2) You MUST configure the OPS$ mechanism BEFORE changing the password

      Refer to:

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

      SAP Note 361641 Creating OPS$ users on UNIX

      SAP Note 50088 Creating OPS$ users on Windows NT/Oracle

  • author's profile photo Former Member
    Former Member
    Posted on Dec 24, 2007 at 08:34 AM

    Thank you all,

    Regards,

    Ruzica

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.