Database Administrators Meta
If you want to change the password then you would need to recreate the password file … Anybody can answer
The Overflow Blog
A password profile is a mechanism in the database that forces a user to follow guidelines when creating or changing passwords. What query to use to obtain that?You cannot; Oracle does not store user passwords, only their hash values, which you can retrieve by Quite properly, Oracle Database does not store passwords in any recoverable form. It only takes a minute to sign up.How to obtain the password of a specified user in Oracle?
By using our site, you acknowledge that you have read and understand our Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community.
Detailed answers to any questions you might have
starting from Oracle 12cR2 you need to configure password file to change SYS account password.
SYS and SYSTEM accounts are incorrectly listed in DBA_USERS_WITH_DEFPWD in 12c (Doc ID 2173962.1) SYS and SYSTEM have that flag set a database create time, and the flag doesn't clear until the first password change AFTER the database is created.
Ensure that the client software with which the users are connecting has the Recovering from lost sys password using NTS authentication on Windows. However, a default password is stored in the data dictionary so if you have a security compliance justification to change it…
Recovering the lost sys password using passwordfile authentication on Windows.
You cannot; Oracle does not store user passwords, only their hash values, which you can retrieve by select password from dba_users where username = 'WHATEVER'. If you have ever tried to change the SYS of a normal or ASM database instance Password, you would get errors.
Password for all three (not recommended).
That user will be able to re-set the SYS password. During installation, it asks you to set password for sys, system and pdbadmin or set the same.
Stack Exchange network consists of 176 Q&A communities including
Database Administrators Stack Exchange works best with JavaScript enabled
Learn more about Stack Overflow the company
The reason behind these failures are - The password should be the one provided when the password file was created,also REMOTE_LOGIN_PASSWORDFILE should be set to EXCLUSIVE on all instances. ALTER USER username PASSWORD EXPIRE; Ask these users to log in to their accounts. 2: The orapwd utility may help in re-setting a lost SYS password, see here: using orapwd to re-set a password 3: If your ID's are identified externally you can sign-on to Oracle without a password and then change the SYS password.
SELECT USERNAME FROM DBA_USERS WHERE PASSWORD_VERSIONS LIKE '%10G%' AND USERNAME <> 'ANONYMOUS'; Expire the accounts that still have the 10G password version.