System users password has expired

oracle oracle11g
RNJ picture RNJ · Jul 9, 2013 · Viewed 35k times · Source

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.

Answer

jDeveloper picture jDeveloper · Dec 10, 2013

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

Related questions

ORA-12514 TNS:listener does not currently know of service requested in connect descriptor

We have an application running locally where we're experiencing the following error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor I've tested the connection using TNSPing which resolved correctly and I tried SQLPlus to try …

Read More
How do I do top 1 in Oracle?

How do I do the following? select top 1 Fname from MyTbl In Oracle 11g?

Read More
ORA-01017 Invalid Username/Password when connecting to 11g database from 9i client

I'm trying to connect to a schema on 11g (v11.2.0.1.0) from a PC with 9i (v9.2.0.1) client. It seems to connect fine to some schemas, but not this one - it comes back with a ORA-01017 Invalid Username/Password error …

Read More