search

Home >Database >Mysql Tutorial >Oracle 11g解锁scott

Oracle 11g解锁scott

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-06-07 16:57:081439browse

scott 是我接触oracle的第一个用户名。无论是那个版本的数据库，9i、10g，我都喜欢用scott做些测试。但是安装好oracle 11g后，sc

scott 是我接触Oracle的第一个用户名。无论是那个版本的数据库，9i、10g，我都喜欢用scott做些测试。但是安装好oracle 11g后，scott用户却无法使用，，让我觉得心里有个疙瘩。

在PL/SQL中用scott登录，会报ORA-2800:the account is locked。既然帐号被锁，那我们就解锁。用system登录，输入命令alter user scott account unlock; 解锁帐号。再次尝试登录，报ORA-28001: The password has expired 。密码到期。输入命令alter user scott identified by tiger; 修改密码。再次登陆，搞定！

终于又可以用我的scott了！

linux

Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：Oracle数据库一致性读的原理Next article：Linux下安装Django1.2和MySQL-Python

Related articles

See more