Skip to Content

Password sys and system

Hi everybody,

I don't know the user password for sys and system in Oracle, so I want to change them. Could have any issues in the database or in SAP due to this change? Are there any task I would have to take in count?

Regards.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    Mar 13, 2013 at 11:45 AM

    Hi Maximino,

    You can change the password for both sys and system.

    Use the command

    SQL> Alter user system identified by <newpasswd>;

    SQL> alter user sys identified by <newpasswd>;

    SAP will not use both of these users for normal operations. It will use SAP schema user which will be either SAPSR3 or SAPSID .

    Hope this helps.

    Regards,

    Deepak Kori

    Add comment
    10|10000 characters needed characters exceeded

    • I want to change the password to use the sqldeveloper (it asks me a powerful user like system), and I realized that I didn't have these passwords.

      I suppose that there will no be any problems and I'll change the password from sql wiht Alter user system identified by...

      Regards to everybody

  • avatar image
    Former Member
    Mar 13, 2013 at 12:04 PM

    Hi Maximino Suárez Arboleya

    Try this for changing sys ans system password

    SQL> passw sys
    Changing password for sys
    New password:
    Retype new password:
    Password changed
    SQL> quit

    SQL> passw system
    Changing password for system
    New password:
    Retype new password:
    Password changed
    SQL> quit

    No issues at all:go ahead with this.

    regards

    alen

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 13, 2013 at 11:50 AM

    Hi,

    By my knowledge there should be no significent impact.

    User "SYSTEM" default password by my encounter has been: sap

    SYS password I do not know. However when changing them, please use brtools (not oracle sqlplus nor commandline!)

    Also in some cases after changeing via brtools the sap wont start because of duplicate entries in database user file. So search SCN for changing sytstem password via sqlplus also for backup.

    But this is only my knowledge - maybe experts have different opinion.

    Br,

    KT.

    Add comment
    10|10000 characters needed characters exceeded