问题：连接SCOTT/TIGER报错问题
SQL> conn SCOTT/TIGER
ERROR:
ORA-01017: invalid username/password; logon denied
1. 查看数据库内所有的用户：
SQL> select username from dba_users;
USERNAME
------------------------------
MGMT_VIEW
SYS
SYSTEM
DBSNMP
SYSMAN
SCOTT
ACCOUNTING
SALES
HR
OUTLN
MDSYS
USERNAME
------------------------------
ORDSYS
EXFSYS
DMSYS
WMSYS
CTXSYS
ANONYMOUS
XDB
ORDPLUGINS
SI_INFORMTN_SCHEMA
OLAPSYS
TSMSYS
USERNAME
------------------------------
BI
PM
MDDATA
IX
SH
DIP
OE
2. 查看SCOTT用户的信息
SQL> select * from dba_users where username='SCOTT';
USERNAME USER_ID PASSWORD
------------------------------ ---------- ------------------------------
ACCOUNT_STATUS LOCK_DATE EXPIRY_DATE
-------------------------------- -------------- --------------
DEFAULT_TABLESPACE TEMPORARY_TABLESPACE CREATED
------------------------------ ------------------------------ --------------
PROFILE INITIAL_RSRC_CONSUMER_GROUP
------------------------------ ------------------------------
EXTERNAL_NAME
--------------------------------------------------------------------------------
SCOTT 54 4DD35D67F0372586
OPEN
USERS TEMP 30-8月 -05
USERNAME USER_ID PASSWORD
------------------------------ ---------- ------------------------------
ACCOUNT_STATUS LOCK_DATE EXPIRY_DATE
-------------------------------- -------------- --------------
DEFAULT_TABLESPACE TEMPORARY_TABLESPACE CREATED
------------------------------ ------------------------------ --------------
PROFILE INITIAL_RSRC_CONSUMER_GROUP
------------------------------ ------------------------------
EXTERNAL_NAME
--------------------------------------------------------------------------------
DEFAULT DEFAULT_CONSUMER_GROUP
3. 解决方法：
conn /as sysdba
alter user scott identified by tiger;
conn scott/tiger
已连接
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/28264124/viewspace-746582/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
oracle 数据库的关闭过程
请登录后发表评论
登录
全部评论
