Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

password expired error

3155808Jul 16 2017 — edited Jul 19 2017

I installed oracle database 12c .. now when i open sql developer and connect to HR with

hr username and hr password

then this shows warning

A database warning was encountered performing the requested operation:

ORA-28002: the password will expire within 7 days

28002. 00000 - "the password will expire within %s days"

*Cause: The user's account is about to about to expire and the password

       **needs to be changed**

*Action: change the password or contact the DBA

Vendor code 28002

I search on google for solutions but they all said run this query

SELECT PROFILE FROM dba_users WHERE username = 'hr';

when i connect to hr and run this query then error occurred table or view does not exist so i search again and i found go to "Other users" and select your user but here i did not find "hr" user

and also when i try to connect to sys this shows incorrect password i did not remember what password is so how to solve this issue ?

when i connect to hr and select "other user" this shows like this

pastedImage_0.png

pastedImage_5.png

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 16 2017
Added on Jul 16 2017
3 comments
2,559 views