Oracle帐号基本管理

核心提示：1. Oracle安装完成后的用户名和密码sys/change_on_install system/manager scott/tiger sysman/oem_tempinternal/oracle2.修改oracle用户的密码SQL> conn sys/change_on_install as sysdbaC

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.

文章来源：http://laziocht.blog.51cto.com/107289/159264