上次的操作中，修改了登錄密碼，只可惜dbsnmp這個(gè)用戶不是admin，好多操作做不了（下次一定要看清楚了再改-_-），下面介紹下在system無(wú)法登錄時(shí)，怎么修改密碼。
在CMD中啟用SQLPLUS，用conn / as sysdba 登錄
連接到:
Oracle Database 10g Express Edition Release 10.2.0.1.0 – Production
SQL> connect sys/oracle as sysdba
已連接。
SQL> select username,password from dba_users;
USERNAME
------------------------------------------------------------
PASSWORD
------------------------------------------------------------
SYS
93A0727B64A4926C
SYSTEM
E049D4E52B9218ED
ANONYMOUS
anonymous
USERNAME
------------------------------------------------------------
PASSWORD
------------------------------------------------------------
DBSNMP
E066D214D5421CCC
MDSYS
72979A94BAD2AF80
OUTLN
4A3BA55E08595C81
USERNAME
------------------------------------------------------------
PASSWORD
------------------------------------------------------------
DIP
CE4A36B8E06CA59C
TSMSYS
3DF26A8B17D0F29F
FLOWS_FILES
364B78B9EABB9E56
USERNAME
------------------------------------------------------------
PASSWORD
------------------------------------------------------------
CTXSYS
D1D21CA56994CAB6
FLOWS_020100
16E4C012E98710D0
XDB
E76A6BD999EF9FF1
USERNAME
------------------------------------------------------------
PASSWORD
------------------------------------------------------------
HR
4C6D73C3E8B0F0DA
已選擇13行。
SQL> connect system/oracle
ERROR:
ORA-01017: invalid username/password; logon denied
警告: 您不再連接到 ORACLE。
SQL> connect sys/oracle as sysdba
已連接。
SQL> alter user system identified by manager;
用戶已更改。
SQL> select username,password from dba_users;
USERNAME
------------------------------------------------------------
PASSWORD
------------------------------------------------------------
SYS
93A0727B64A4926C
SYSTEM
D4DF7931AB130E37
ANONYMOUS
anonymous
USERNAME
------------------------------------------------------------
PASSWORD
------------------------------------------------------------
DBSNMP
E066D214D5421CCC
MDSYS
72979A94BAD2AF80
OUTLN
4A3BA55E08595C81
USERNAME
------------------------------------------------------------
PASSWORD
------------------------------------------------------------
DIP
CE4A36B8E06CA59C
TSMSYS
3DF26A8B17D0F29F
FLOWS_FILES
364B78B9EABB9E56
USERNAME
------------------------------------------------------------
PASSWORD
------------------------------------------------------------
CTXSYS
D1D21CA56994CAB6
FLOWS_020100
16E4C012E98710D0
XDB
E76A6BD999EF9FF1
USERNAME
------------------------------------------------------------
PASSWORD
------------------------------------------------------------
HR
4C6D73C3E8B0F0DA
已選擇13行。
SQL> connect system/manager
已連接。
SQL> connect sys/oracle as sysdba
已連接。
SQL> alter user system identified by values 'D4DF7931AB130E37';
用戶已更改。
SQL> connect system/oracle
ERROR:
ORA-01017: invalid username/password; logon denied
警告: 您不再連接到 ORACLE。
SQL> connect sys/oracle as sysdba
已連接。
SQL> connect system/manager
已連接。
到此已連接成功，可以做其他操作了
SQL> connect dbsnmp/dbsnmp
已連接。