Password sys and system

[former_member209959]

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.

[former_member188883 · Accepted solution]

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

[Former Member · Accepted solution]

Yes. However, please check with your DB Backup administrator...

Some backup tool might use SYSTEM user for authorization of backup.

Please let  us know why you want to change the password for these two users.

[former_member209959 · Accepted solution]

Hi Kori and thanks for your help,

I know that SAP doesn't use these users. But what about Oracle? Can be some Oracle scheduled task that use these users?.

Best Regards.

[former_member209959 · Accepted solution]

Hi Vimalan,

The backup is made with RMAN, and I think there are not another scheduled jobs (for example from crontab). Do you think RMAN use these users?

Regards.

[former_member209959 · Accepted solution]

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

[Former Member]

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

[Former Member]

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.