Oracle帐号基本管理


 1. Oracle安装完成后的用户名和密码

  sys/change_on_install

  system/manager

  scott/tiger

  sysman/oem_temp

  internal/oracle

  2.修改oracle用户的密码

  SQL> conn sys/change_on_install as sysdba

  Connected.

  SQL> alter user sys identified by ******;

  User altered.

  3.解锁oracle用户

  SQL> conn scott/tiger

  ERROR:

  ORA-28000: the account is locked

  Warning: You are no longer connected to ORACLE.

  SQL>conn sys/change_on_install as sysdba

  Connected.

  SQL> alter user scott account unlock;

  User altered.


« 
» 
快速导航

Copyright © 2016 phpStudy | 豫ICP备2021030365号-3