How to reset username and password for oracle

Question

I am using

Run SQL Command Line

to connect with database, previously I am able to connect with username 'system' and password 'root' but when I tried to connect using SQL>connect system/root

it is showing error

ERROR:
ORA-01017: invalid username/password; logon denied

All services are running, after long time I am trying to connect may be I forgot my credentials can anyone help me how to change or reset both username and password I am on windows platform,

Possible duplicate of changing password with oracle's SQL Developer — Florin Ghita
– Florin Ghita, Commented Mar 16, 2016 at 7:33

FallAndLearn · Accepted Answer · 2016-03-16 06:49:52Z

0

I too reset my password few days back. You can reset your password by this

ALTER USER username IDENTIFIED BY password

Connect to db first

SQL> conn /as sysdba

More information Docs

edited Mar 16, 2016 at 6:49

answered Mar 16, 2016 at 6:44

FallAndLearn

4,1351 gold badge20 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

subbu royal Over a year ago

thank you very much for your reply, when I tried to run the command you recommended, getting 'SP2-0640: Not connected'

FallAndLearn Over a year ago

You are not connected to the db. Run this command SQL> conn /as sysdba

subbu royal Over a year ago

may be I tried too many attempts my account i locked "ERROR: ORA-28000: the account is locked", but with your command I altered details, Is it possible to unlock the locked account?

FallAndLearn Over a year ago

yes. you can unlock using : alter user username account unlock;

Collectives™ on Stack Overflow

How to reset username and password for oracle

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related