I am facing an issue as follows:
I login to em using SYS
as SYSDBA
. Enterprise Manager shows information screen saying my password is going to expire. SYS
Password will expire on 7th Feb 2017 as confirmed with Sql Plus:
Now on EM side, when I go to preferences -> General -> Password
and try to change my password, it says Current Password - Current password is invalid.
I am providing same password I used to login to EM as SYSDBA
but no luck.
Can someone advice what the problem is? How can I access database from EM in this situation. Also, please briefly advice about how to extend password expiry date.
DB Version: Oracle 11g
Best Answer
That's not the best practice to use
SYS
user to use in Enterprise Manager. And you can change password for the user likeSYSTEM
orSYSMAN
using OEM but not forSYS
user.You can change the password of
SYS
user using SQL*PLUS command calledpassword
which send the password in encrypted form instead of plain text.First of all find out which profile is assigned to the user-
-then you can user ALTER PROFILE to change password life time.
Also password doesn't cause effect on
SYS
user(I couldn't find documentation link) as demonstrated below.But I still can connect to the database using old password.
However, if your password for
sys
user has expired and unable to login then-sqlplus / as sysdba
from the terminal of the user who owns the Oracle software.