Database Administration (MOSC)

MOSC Banner

How to change SYS and SYSTEM passwords on Oracle Database 11.2

edited Dec 3, 2013 2:08AM in Database Administration (MOSC) 7 commentsAnswered

Hi All,
I would like to ask you about a way to change SYS password.

I already read through Document#1051982.6, which tells you should run ALTER USER command to change SYS password on Oracle Database Version7.0.16.0 and later (including 11.2)
  --------------------------------------
  Document ID 1051982.6
    How to Change SYS and SYSTEM Passwords
  --------------------------------------

However "Oracle Database Security Guide 11.2" says about changing SYS password like below:
( 2-9 Managing Security for Oracle Database Users "Changin the SYS Uer Password" Section)
--------------------------------------
"you should use the ORAPWD command line utility
....
Do not use the ALTER USER statement or the PASSWORD command to change the SYS user password.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center