Solution for Oracle 11g forgetting SYS and SYSTEM passwords

Solution for Oracle 11g forgetting SYS and SYSTEM passwords

Oracle 11g forgets the SYS and SYSTEM passwords. The answer is simple: change the password!

1. First, log on to the SYS account using the operating SYSTEM authentication method and change the SYSTEM account password.

$ Sqlplus/as sysdba

SQL * Plus: Release 11.2.0.4.0 Production ction on Fri Mar 20 14:23:41 2015

Copyright (c) 1982,201 3, Oracle. All rights reserved.

Connected:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
 
SQL> show user;
USER is "SYS"
SQL> alter user SYSTEM identified by "oracle123 ";
 
User altered.
 

SQL> exit

2. Use SQLPLUS to log on to the SYSTEM account remotely and change the SYS account password.

$ Sqlplus SYSTEM @ orcl

SQL * Plus: Release 11.2.0.4.0 Production ction on Fri Mar 20 14:22:35 2015

Copyright (c) 1982,201 3, Oracle. All rights reserved.

Enter password:

Connected:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
 
SQL> show user;
USER is "SYSTEM"
SQL> alter user SYS identified by "Oracle123 ";
 
User altered.

SQL> exit

At this point, we are done. log on to the Apsara stack console using remote logon ~