Invalid Oracle11g Password

Oraclesystem cannot be logged on. My own problems are summarized as follows: First, enter sqlpuls as SYSDBA to open sqlpulsSQL-gt; enter the username: sysass

Oracle system cannot be logged on. My own problems are summarized as follows: First, enter sqlpuls as sys dba to open sqlpulsSQL-gt; enter the User name: sys as s

Oracle system cannot log on. My own problems are summarized as follows:

First, access sqlpuls as SYS DBA

Enable sqlpuls

SQL-> enter the User name: sys as sysdba

SQL-> password (old password ):

Query the DBA user status after successful logon.

SQL-> select username, account_status from dba_users;

Check whether the common user statuses are EXPIRED or LOCKED.

Some are LOCKED.

If the sysman status is expired, change the password as follows:

1. Execute emctl stop dbconsole

After the execution is complete, stop the agent: emctl stop agent.

Run the following command to check whether the instance is missing or stopped:

Emctl status dbconsole

Emctl status agent

After you confirm that the password is stopped, you can change the password in sqlpuls.

2. Run the following command to change the system password:

SQL-> alter user sysman identified <你要改的密码> ;

First, check whether the system is locked.

SQL-> select username, account_status from dba_users;

Check the sysman status. If it is LOCKED, you must unlock it first:

SQL-> alter user system account unlock;

After unlocking, you can change the password or unlock it again. The steps can be reversed, but there must be no less.

After modification

SQL> system/Password

If the connection is successful, you can proceed to the next step.