CODEWITHSUNDEEP
oracle-databaseoracle11g
RNJ
RNJ

Reputation: 15552

System users password has expired

I have just tried to login to my db via sql developer as system so i can create a new user. It has come with an error that the password has expired.

I have googled a bit but cannot see how to reset the system user password. I guess this is a security issue.

My problem is how can I log in as system if the password has expired? How can I unexpire the password without logging in as System users. I seem to be stuck here in a loop where I cannot reset the password expiration.

Upvotes: 34

Views: 46115

Answers (3)

Sandro
Sandro

Reputation: 1845

If someone drops by from a Google search but uses IntelliJ: You can reset the system password in the connection properties' "Advanced" tab. There you can set the new one as a value for the oracle.jdbc.newPassword key.

Upvotes: 1

jDeveloper
jDeveloper

Reputation: 2126

Open up cmd.exe and type in SQLPLUS

 Enter user-name: SYSTEM
 Enter password: the expired password

It will now let you type in a new password for the SYSTEM user

Upvotes: 75

BA TabNabber
BA TabNabber

Reputation: 1356

If SQLPLUS is not available, you can also reset an expired password from within SQL Developer:

  • Save your connection information (if not done already)
  • Right click on your connection
  • Click on the “Reset Password” option in the menu, enter old/new password blah blah blah

Upvotes: 8

Related Questions