连接scott/tiger 报错问题

最新推荐文章于 2022-08-24 11:10:56 发布

congtuying9914

最新推荐文章于 2022-08-24 11:10:56 发布

阅读量455

点赞数

文章标签：数据库

问题：连接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博客 ” ，链接：http://blog.itpub.net/28264124/viewspace-746582/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/28264124/viewspace-746582/