由于装数据库不是我装的,因此我不知道我电脑的数据库密码,请问有什么方式可以改变原来的密码吗?
ä¿®æ¹ç¨æ·å¯ç ã
æ°æ®åºè¿æ¥æååï¼å¨SQL>æ示åè¾å ¥ï¼ALTER USER ç¨æ·å IDENTIFIED BY æ°å¯ç ;ï¼å车ï¼
åè¾å ¥ï¼commitï¼ï¼å车ï¼æ交æä½ä¿®æ¹å³å¯ã
è¡¥å æ¹æ³ï¼
å ·ä½æä½è¿ç¨å¦ä¸ï¼
SQL*Plus: Release 9.2.0.5.0 - Production on æææ¥ 11æ 21 13:32:34 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect sys/oracle as sysdba
å·²è¿æ¥ã
SQL> select username,password from dba_users;
USERNAME PASSWORD
------------------------------ ------------------------------
SYS 8A8F025737A9097A
SYSTEM 2D594E86F93B17A1
DBSNMP E066D214D5421CCC
TOAD A1BA01CF0DD82695
OUTLN 4A3BA55E08595C81
WMSYS 7C9BA362F8314299
å·²éæ©6è¡ã
SQL> connect system/oracle
å·²è¿æ¥ã
SQL> connect sys/oracle as sysdba
å·²è¿æ¥ã
ä¿®æ¹ç¨æ·systemå¯ç 为manager
SQL> alter user system identified by manager;
ç¨æ·å·²æ´æ¹ã
解éç¨æ·
SQL> alter user system account unlock;
ç¨æ·å·²æ´æ¹ã
SQL> select username,password from dba_users;
USERNAME PASSWORD
------------------------------ ------------------------------
SYS 8A8F025737A9097A
SYSTEM D4DF7931AB130E37
DBSNMP E066D214D5421CCC
TOAD A1BA01CF0DD82695
OUTLN 4A3BA55E08595C81
WMSYS 7C9BA362F8314299
å·²éæ©6è¡ã
SQL> connect system/manager
å·²è¿æ¥ã
ç¶åæ¤æ¶å¯ä»¥åæ³è¦åçä»»ä½æä½äº
SQL> connect sys/oracle as sysdba
å·²è¿æ¥ã
ä¿®æ¹ç¨æ·systemå¯ç 为以åçå¼
SQL> alter user system identified by values '2D594E86F93B17A1';
ç¨æ·å·²æ´æ¹ã
SQL> connect system/oracle
å·²è¿æ¥ã
SQL> connect sys/oracle as sysdba
å·²è¿æ¥ã
SQL> connect system/manager
ERROR:
ORA-01017: invalid username/password; logon denied
è¦å: æ¨ä¸åè¿æ¥å° ORACLEã
æ°æ®åºè¿æ¥æååï¼å¨SQL>æ示åè¾å ¥ï¼ALTER USER ç¨æ·å IDENTIFIED BY æ°å¯ç ;ï¼å车ï¼
åè¾å ¥ï¼commitï¼ï¼å车ï¼æ交æä½ä¿®æ¹å³å¯ã
è¡¥å æ¹æ³ï¼
å ·ä½æä½è¿ç¨å¦ä¸ï¼
SQL*Plus: Release 9.2.0.5.0 - Production on æææ¥ 11æ 21 13:32:34 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect sys/oracle as sysdba
å·²è¿æ¥ã
SQL> select username,password from dba_users;
USERNAME PASSWORD
------------------------------ ------------------------------
SYS 8A8F025737A9097A
SYSTEM 2D594E86F93B17A1
DBSNMP E066D214D5421CCC
TOAD A1BA01CF0DD82695
OUTLN 4A3BA55E08595C81
WMSYS 7C9BA362F8314299
å·²éæ©6è¡ã
SQL> connect system/oracle
å·²è¿æ¥ã
SQL> connect sys/oracle as sysdba
å·²è¿æ¥ã
ä¿®æ¹ç¨æ·systemå¯ç 为manager
SQL> alter user system identified by manager;
ç¨æ·å·²æ´æ¹ã
解éç¨æ·
SQL> alter user system account unlock;
ç¨æ·å·²æ´æ¹ã
SQL> select username,password from dba_users;
USERNAME PASSWORD
------------------------------ ------------------------------
SYS 8A8F025737A9097A
SYSTEM D4DF7931AB130E37
DBSNMP E066D214D5421CCC
TOAD A1BA01CF0DD82695
OUTLN 4A3BA55E08595C81
WMSYS 7C9BA362F8314299
å·²éæ©6è¡ã
SQL> connect system/manager
å·²è¿æ¥ã
ç¶åæ¤æ¶å¯ä»¥åæ³è¦åçä»»ä½æä½äº
SQL> connect sys/oracle as sysdba
å·²è¿æ¥ã
ä¿®æ¹ç¨æ·systemå¯ç 为以åçå¼
SQL> alter user system identified by values '2D594E86F93B17A1';
ç¨æ·å·²æ´æ¹ã
SQL> connect system/oracle
å·²è¿æ¥ã
SQL> connect sys/oracle as sysdba
å·²è¿æ¥ã
SQL> connect system/manager
ERROR:
ORA-01017: invalid username/password; logon denied
è¦å: æ¨ä¸åè¿æ¥å° ORACLEã
温馨提示:答案为网友推荐,仅供参考
第1个回答 2018-08-03
操作如下:
以Windows操作系统为例,打开命令提示符,输入命令sqlplus /nolog ,进入oracle控制台,并输入 conn /as sysdba;以DBA角色进入。
连接成功后,输入“select username from dba_users”查看用户列表
若修改某一个用户密码, 修改用户口令 格式为:
alter user 用户名 identified by 新密码;
以system 为例,密码修改为 123456. 可输入
alter user system identified by 123456;
常用命令:查看Oracle数据库中的所有用户名
查看数据库里面所有用户,前提是你是有dba权限的帐号,如sys,system
select * from dba_users;
查看你能管理的所有用户!
select * from all_users;
查看当前用户信息 !
select * from user_users;
本回答被网友采纳第2个回答 推荐于2017-11-28
在命令行下使用sqlplus登陆数据库,使用alter user来改密码,比如说修改sys用户密码为oracle命令如下:
sqlplus "/as sysdba"
alter user sys identified by oracle;本回答被网友采纳
sqlplus "/as sysdba"
alter user sys identified by oracle;本回答被网友采纳
第3个回答 2012-02-07
楼上正解。
第4个回答 2012-02-06
来晚了,楼上正解