Solution to oracle forgetting system sys username and password

 

Enable SQL plus

Find a user to log on

Finally, enter commit;

Microsoft Windows XP [version 5.1.2600]

(C) Copyright 1985-2001 Microsoft Corp.

C:-Documents and Settings-Administrator> sqlplus/nolog

SQL * Plus: Release 10.1.0.2.0-Production on Saturday June 26 11:08:34 2010

Copyright (c) 1982,200 4, Oracle. All rights reserved.

SQL> conn/as sysdba

Connected.

SQL> alter user system identified by "123456 ";

User altered.

SQL> alter user sys identified by "123456 ";

User altered.

SQL> alter user system identified by "123456 ";

User altered.

SQL> exit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.2.0-Pr

Oduction

With the Partitioning, OLAP and Data Mining options

C:-Documents and Settings-Administrator> sqlplus

SQL * Plus: Release 10.1.0.2.0-Production on Saturday June 26 11:11:34 2010

Copyright (c) 1982,200 4, Oracle. All rights reserved.

Enter user-name: system

Enter password:

Connected:

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0-Production

With the Partitioning, OLAP and Data Mining options

SQL> select instance_name from v $ instance;

INSTANCE_NAME

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

Myfirstoracledb