I am getting this error when trying to login into Oracle SQL * Plus with system user . I tried to connect with a different user as sysdba and executed the following statement.
alter user system identified by <pwd>account unlock;
The statement returns "user altered". In the same window I am able to disconnect the current user and connect with system user.
But when I again start a new Oracle sQL * pLUS window I am not able to login with "system" user. It gives the same account locked error.
Any help is greatly appreciated.
Thank you,
Praveen