You need to use the identified by clause in order to get rid of the expired password problem. Account unlock clause will unlock the user account.
SQL> ALTER USER SYSMAN IDENTIFIED BY PASSWORD ACCOUNT UNLOCK;
user10401961 wrote:The oem agent is locking it because it doesn't know the new password. Chinar has tried three times to point you to the additional documentation needed for changing the password of SYSMAN. Not only do you have to change the password with the SQL command, but you have to put the new password into an oem configuration file so the agent will know what it is. Until you read and follow those docs, you will continue to lock the account.
Okay I figured out how to change the password in SQLPlus, even how to get a special character or I think I did it right.
ALTER USER SYSMAN IDENTIFIED BY "xxxx!!!" ACCOUNT UNLOCKED:
This will allow another instance of SQLPlus to log on. I then tried OEM, it came up once with the password screen I signed on, it started to come up then failed and returned to the screen that said the "Agent Connection To Instance" had Status Failed with the details of the title of this thread.
A this point if I go back into SQLPlus again it will say the account is locked. I will unlock it with the instance I have open and again you can log into SQLPlus with sysman. I tried the OEM again and no longer will it show the password screen again.
What is locking the password?
user10401961 wrote:Metalink (now known as My Oracle Support) is not the same as Oracle.com, and MetaLink content is not available from other sources.
Thanks, I see, I am searching Oracle.com for How To Change the Password of the Database User Sysman (DB Control Repository Schema) [ID 259379.1] is there a different place for this document? Is Metalink the same as Oracle.com or within the same. Thanks, Rick