Community
Learn
Tools Library
AI Tools
Leisure
search
English
Home > Database > Mysql Tutorial > Oracle 11g解锁scott

Oracle 11g解锁scott

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release： 2016-06-07 16:57:08
Original
1440 people have browsed it

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

Related labels：
o oracle database
Previous article：Oracle数据库一致性读的原理 Next article：Linux下安装Django1.2和MySQL-Python
Statement of this Website
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
Latest Articles by Author
Latest Issues
How to connect PHP toolbox to oracle database
From 1970-01-01 08:00:00
0
0
0
Laravel - lumen introduces a third-party package to connect to Oracle, but the configuration file to connect to Oracle does not take effect, and it still connects to MySQL by default. What should I do?
From 1970-01-01 08:00:00
0
0
0
wamp environment connects to oracle database
From 1970-01-01 08:00:00
0
0
0
Who has written PHP (thinkphp5) to share the class library for connecting to Oracle?
From 1970-01-01 08:00:00
0
0
0
Why can't the oracle database be opened in phpstudy5.6?
From 1970-01-01 08:00:00
0
0
0
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template