Oracle prompts what to do if the login password expires.

This article mainly shows you "oracle prompt login password expired how to do", the content is simple and easy to understand, organized clearly, I hope to help you solve doubts, let Xiaobian lead you to study and learn "oracle prompt login password expired how to do" this article bar.

Oracle prompt login password expired solution

1. Log in to oracle's server

2. Switch to oracle user

3. Instance name set to current operation: export ORACLE_SID=XXX

4. Command line mode for connecting databases: sqlplus /nolog

5.sql: conn /as sysdba; log in as dba

6. Modify expired user password settings:

Alter user XXX identified by XXX

After modifying user password, use the user password connection database of modification afresh ok, if still have lock user operation,

Remember to execute the unlock command: alter user XXX unlock;

Oracle uses scott user login prompt password expiration

--------------------------------------------------------------------------------

When installing oracle for the first time, many people forget to initialize the password for scott user while unlocking scott user, but oracle will set a default password for scott user that is tiger, but after successful installation, use scott user to log into oracle database but prompt password expiration.

When this happens, we can type:

sqlplus /nolg ;

(Log in without a username)

Then type in SQL> command:

conn sys/password as sysdba;

(The sys user password here is the password we set for the database)

After successful login, you will be prompted to connect

Alter user scott identified by tiger;

(Change Scott user password)

alter user scott account unlock;

(Unlock SCOTT)

Then we can log in as scott user.

The above is "oracle prompt login password expired how to do" all the contents of this article, thank you for reading! I believe that everyone has a certain understanding, hope to share the content to help everyone, if you still want to learn more knowledge, welcome to pay attention to the industry information channel!