SQL> alter user hr identified by hr;User altered.SQL> conn hr/hr; ERROR: ORA-28000: the account is locked Warning: You are no longer connected to ORACLE. SQL> alter user hr unlock; SP2-0640: Not connected SQL> connect sys/oracle as sysdba Connected. SQL> alter user hr account unlock;User altered.SQL> conn hr/hr; Connected. SQL>
Oracle9i Release 9.0.1.1.1 - Production JServer Release 9.0.1.1.1 - ProductionSQL> conn sys/change_on_install as sysdba 已连接。 SQL> alter user hr account unlock;用户已更改。SQL> conn hr/hr ERROR: ORA-01017: invalid username/password; logon denied 警告: 您不再连接到 ORACLE。 SQL> 奇怪我怎么不行呀?????????????????
主要是买的那本书是要用到hr下的employee表,所以才要用hr
Oracle9i Release 9.0.1.1.1 - Production JServer Release 9.0.1.1.1 - ProductionSQL> conn sys/change_on_install as sysdba 已连接。 SQL> alter user hr account unlock;用户已更改。--********加一句: alter user hr identified by hr; SQL> conn hr/hr ERROR: ORA-01017: invalid username/password; logon denied 警告: 您不再连接到 ORACLE。 SQL> 奇怪我怎么不行呀?????????????????jsnicle(js_nicle)说的已经很清楚了!
设一个自己的密码吧 用sysdba用户登陆 执行 alter user hr identified by yourpassword;
ERROR:
ORA-28000: the account is locked
Warning: You are no longer connected to ORACLE.
SQL> alter user hr unlock;
SP2-0640: Not connected
SQL> connect sys/oracle as sysdba
Connected.
SQL> alter user hr account unlock;User altered.SQL> conn hr/hr;
Connected.
SQL>
JServer Release 9.0.1.1.1 - ProductionSQL> conn sys/change_on_install as sysdba
已连接。
SQL> alter user hr account unlock;用户已更改。SQL> conn hr/hr
ERROR:
ORA-01017: invalid username/password; logon denied
警告: 您不再连接到 ORACLE。
SQL>
奇怪我怎么不行呀?????????????????
JServer Release 9.0.1.1.1 - ProductionSQL> conn sys/change_on_install as sysdba
已连接。
SQL> alter user hr account unlock;用户已更改。--********加一句:
alter user hr identified by hr;
SQL> conn hr/hr
ERROR:
ORA-01017: invalid username/password; logon denied
警告: 您不再连接到 ORACLE。
SQL>
奇怪我怎么不行呀?????????????????jsnicle(js_nicle)说的已经很清楚了!
用sysdba用户登陆
执行 alter user hr identified by yourpassword;