10g的scott账户解锁

最新推荐文章于 2021-04-07 21:52:41 发布
最新推荐文章于 2021-04-07 21:52:41 发布
阅读量515 收藏
点赞数
分类专栏： Oracle
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/jackenjun/article/details/8901895
版权
  • 方法一：
1）prepare for active
SQL> col username format a20
SQL> col account_status format a20
SQL> set pages 300
2）check the scott's status
SQL> select username,account_status from dba_users;

USERNAME                         ACCOUNT_STATUS
-------------------- --------------------
MGMT_VIEW                        OPEN
SYS                                    OPEN
SYSTEM                             OPEN
DBSNMP                             OPEN
SYSMAN                             OPEN
JACK                                 OPEN
OUTLN                                EXPIRED & LOCKED
MDSYS                                EXPIRED & LOCKED
ORDSYS                             EXPIRED & LOCKED
EXFSYS                             EXPIRED & LOCKED
DMSYS                                EXPIRED & LOCKED
WMSYS                                EXPIRED & LOCKED
CTXSYS                             EXPIRED & LOCKED
ANONYMOUS                        EXPIRED & LOCKED
XDB                                    EXPIRED & LOCKED
ORDPLUGINS                     EXPIRED & LOCKED
SI_INFORMTN_SCHEMA     EXPIRED & LOCKED
OLAPSYS                            EXPIRED & LOCKED
SCOTT                                EXPIRED & LOCKED
TSMSYS                             EXPIRED & LOCKED
BI                                     EXPIRED & LOCKED
PM                                     EXPIRED & LOCKED
MDDATA                             EXPIRED & LOCKED
IX                                     EXPIRED & LOCKED
SH                                     EXPIRED & LOCKED
DIP                                    EXPIRED & LOCKED
OE                                     EXPIRED & LOCKED
HR                                     EXPIRED & LOCKED

28 rows selected.

SQL>
3）alter the scott's status
SQL> alter user scott account unlock;

User altered.

SQL>
4）confirm the scott's status
SQL> select username,account_status from dba_users;            

USERNAME                         ACCOUNT_STATUS
-------------------- --------------------
MGMT_VIEW                        OPEN
SYS                                    OPEN
SYSTEM                             OPEN
DBSNMP                             OPEN
SYSMAN                             OPEN
JACK                                 OPEN
SCOTT                                EXPIRED
OUTLN                                EXPIRED & LOCKED
MDSYS                                EXPIRED & LOCKED
ORDSYS                             EXPIRED & LOCKED
EXFSYS                             EXPIRED & LOCKED
DMSYS                                EXPIRED & LOCKED
WMSYS                                EXPIRED & LOCKED
CTXSYS                             EXPIRED & LOCKED
ANONYMOUS                        EXPIRED & LOCKED
XDB                                    EXPIRED & LOCKED
ORDPLUGINS                     EXPIRED & LOCKED
SI_INFORMTN_SCHEMA     EXPIRED & LOCKED
OLAPSYS                            EXPIRED & LOCKED
TSMSYS                             EXPIRED & LOCKED
BI                                     EXPIRED & LOCKED
PM                                     EXPIRED & LOCKED
MDDATA                             EXPIRED & LOCKED
IX                                     EXPIRED & LOCKED
SH                                     EXPIRED & LOCKED
DIP                                    EXPIRED & LOCKED
OE                                     EXPIRED & LOCKED
HR                                     EXPIRED & LOCKED

28 rows selected.

SQL>
5）Give a passwd for scott;
SQL> alter user scott identified by tiger;

User altered.

SQL>
6）Confirm the scott's status
SQL> select username,account_status from dba_users;

USERNAME                                                 ACCOUNT_STATUS
-------------------- --------------------
MGMT_VIEW                                                OPEN
SYS                                                                        OPEN
SYSTEM                                                         OPEN
DBSNMP                                                         OPEN
SYSMAN                                                         OPEN
SCOTT                                                                OPEN
JACK                                                                 OPEN
OUTLN                                                                EXPIRED & LOCKED
MDSYS                                                                EXPIRED & LOCKED
ORDSYS                                                         EXPIRED & LOCKED
EXFSYS                                                         EXPIRED & LOCKED
DMSYS                                                                EXPIRED & LOCKED
WMSYS                                                                EXPIRED & LOCKED
CTXSYS                                                         EXPIRED & LOCKED
ANONYMOUS                                                EXPIRED & LOCKED
XDB                                                                        EXPIRED & LOCKED
ORDPLUGINS                                         EXPIRED & LOCKED
SI_INFORMTN_SCHEMA         EXPIRED & LOCKED
OLAPSYS                                                        EXPIRED & LOCKED
TSMSYS                                                         EXPIRED & LOCKED
BI                                                                         EXPIRED & LOCKED
PM                                                                         EXPIRED & LOCKED
MDDATA                                                         EXPIRED & LOCKED
IX                                                                         EXPIRED & LOCKED
SH                                                                         EXPIRED & LOCKED
DIP                                                                        EXPIRED & LOCKED
OE                                                                         EXPIRED & LOCKED
HR                                                                         EXPIRED & LOCKED

28 rows selected.

SQL>
方法二：
1)修改scott用户密码并解锁
SQL> alter user scott identified by tiger account unlock;

User altered.

SQL>
2)查看scott账号状态
SQL> select username,account_status from dba_users;

USERNAME                                                                                                         ACCOUNT_STATUS
------------------------------------------------------------ ----------------------------------------------------------------
MGMT_VIEW                                                                                                        OPEN
SYS                                                                                                                    OPEN
SYSTEM                                                                                                             OPEN
DBSNMP                                                                                                             OPEN
SYSMAN                                                                                                             OPEN
SCOTT                                                                                                                OPEN
OUTLN                                                                                                                EXPIRED & LOCKED
MDSYS                                                                                                                EXPIRED & LOCKED
ORDSYS                                                                                                             EXPIRED & LOCKED
EXFSYS                                                                                                             EXPIRED & LOCKED
DMSYS                                                                                                                EXPIRED & LOCKED
WMSYS                                                                                                                EXPIRED & LOCKED
CTXSYS                                                                                                             EXPIRED & LOCKED
ANONYMOUS                                                                                                        EXPIRED & LOCKED
XDB                                                                                                                    EXPIRED & LOCKED
ORDPLUGINS                                                                                                     EXPIRED & LOCKED
SI_INFORMTN_SCHEMA                                                                                     EXPIRED & LOCKED
OLAPSYS                                                                                                            EXPIRED & LOCKED
TSMSYS                                                                                                             EXPIRED & LOCKED
BI                                                                                                                     EXPIRED & LOCKED
PM                                                                                                                     EXPIRED & LOCKED
MDDATA                                                                                                             EXPIRED & LOCKED
IX                                                                                                                     EXPIRED & LOCKED
SH                                                                                                                     EXPIRED & LOCKED
DIP                                                                                                                    EXPIRED & LOCKED
OE                                                                                                                     EXPIRED & LOCKED
HR                                                                                                                     EXPIRED & LOCKED

27 rows selected.

SQL>

本文出自 “Focus on Oracle” 博客，请务必保留此出处http://alexy.blog.51cto.com/6115453/1037169

Onlineforeve
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
Oracle数据库第一课——Oracle数据库基础知识、Oracle Database 11g的体系结构、登录Oracle数据库
王迪
08-23 1335
知识点：初步认识Oracle数据库，了解OracleDatabase 11g的体系结构、掌握登录Oracle数据库的方法、理解Oracle数据库中用户、角色与权限之间的关系、能够创建、修改和删除用户，并给用户授予权限。 1、认识Oracle 1.1 Oracle公司 甲骨文公司，全称甲骨文股份有限公司(甲骨文软件系统有限公司)，是全球最大的企业级软件公司，总部...
关于oracle首次登陆出现scott/tiger的locked or expired的问题
zhoubo200的专栏
06-26 823
1.cmd下oracle10g_path_bin>sqlplus.exe / as sysdba; SQL> alter user scott account unlock;          User altered. SQL> commit;          Commit complete. SQL> conn scott/tiger//请输入新密码，并确认后OK Password
如何查看oracle的scott用户使用表空间及对象情况
Patrick
12-23 5048
 SQL>select db.tablespace_name,db.segment_name from dba_extents db where db.owner=SCOTT; ##就这么简单的SQL语句(dba enter)1 SYSTEM DEPT2 SYSTEM EMP3 SYSTEM BONUS4 SYSTEM SALGRADE5 SYSTEM TEST6 SYSTEM T_SPM_B
查看SCOTT账户下 所有表及索引
hugh 的博客
03-08 9718
会mysql的人在第一次接触oracle的时候，或多或少有那么点不适应，就例如我，，， 刚开始妄想用show tables; 来显示所有表，结果 不堪回首。 下面说正确方法：（以 SCOTT用户为例）查看该用户下的所有表 第三行是正确的语句注意 用户名为大写的 SCOTT，上面的第一个 犯的就是这个错查看该用户下的所有索引查看SCOTT账户 下有哪些对象及其对象的类型：
解锁scott用户，以及查看oracle中scott用户所拥有的四张表。
leilei7407的博客
09-15 4060
scott是一个系统已经新建好的普通用户。默认状态是被锁定，DBA用户执行alter user scott account unlock;可以将其解锁。 scott用户是一个示例用户，实际开发没有意义。我们可以用其做一些练习。 连接数据库，此时直接用scott登录，会显示该用户未解锁。 我们用管理员账户登录数据库，将其解锁。 解锁scott用户。 再次使用scott用户进行登录数据库，可发现连...
oracle scott账户解锁,安装完了Oracle数据库，给scott账户解锁方法
weixin_39914732的博客
04-07 403
安装完了Oracle数据库，给scott账户解锁方法装完了Oracle 10g数据库，忘了给scott账户解锁。这时可以在sql plus工具里(开始|所有程序||应用程序开发|SQL Plus)，也可以在控制台通过命令行给scott账户解锁。在第一种情况下，以system账户登录SQL Plus，然后使用命令“alter user scott account unlock;”来解锁。解完以后，使...
Oracle中scott账户解锁方法
harold2007的专栏
12-26 1099
装完了Oracle 10g数据库，忘了给scott账户解锁。这时可以在sql plus工具里（开始|所有程序||应用程序开发|SQL Plus），也可以在控制台通过命令行给scott账户解锁。 　　在第一种情况下，以system账户+自己安装时设置的密码，登录SQL Plus， 然后使用命令“alter user scott account unlock;”来解锁。 解完以后，使用下面的命令
安装完Oracle数据库，给scott账户解锁方法
萧十一郎博客
09-24 761
安装完Oracle数据库，给scott账户解锁方法 标签： oracle数据库安装 2015-10-13 22:45 2424人阅读 评论(0) 收藏 举报 分类： oracle（3） 装完了Oracle 10g数据库，忘了给scott账户解锁。这时可以在sql plus工具里（开始|所有程序||应用程序开发|SQL Plus），也可以在控制台通过命令行给scott账户解锁。 　　在
解决Oracle 11g中scott用户默认被锁定的问题
07-31
### 解决Oracle 11g中scott用户默认被锁定的问题 #### 背景介绍 在使用Oracle数据库的过程中，用户经常会遇到系统预设的一些示例用户被锁定的情况，其中最为人熟知的就是`scott`用户。`scott`用户是在安装Oracle...
oracle用户解锁三种方法.doc
最新发布
10-27
本文将详细介绍三种解锁Oracle用户账户的方法。 首先，我们可以通过PL/SQL Developer工具来解锁用户。如果你收到"ORA-28000: the account is locked"的错误信息，可以按照以下步骤操作： 1. 使用具有DBA权限的用户...
Oracle_10g中关于如何修改被锁定的scott用户的方法
12-06
本文详细介绍了在Oracle 10g环境下如何解锁被锁定的scott用户的具体步骤，包括确定锁定状态、重置密码、解锁账户以及验证解锁状态等。此外，还介绍了如何进一步管理scott用户，如更改默认表空间和设置配额限制等。...
oracle用户解锁
07-18
在本文中，我们将介绍三种不同的方法来解锁 Oracle 用户账户。 方法一：使用 PL/SQL 解锁 首先，使用 PL/SQL 登录名为 system，数据库名称不变，选择类型的时候把 Normal 修改为 Sysdba。然后，选择 myjob，查看 ...
ORACLE账户提示EXPIRED(GRACE)问题解决
热门推荐
Focus on Minds
05-08 1万+
最近一个奇怪现象为账户为EXPIRED(GRACE)，查阅资料得知这是oracle11g安全的一个更新，类似系统账号过期一样。 1）查询用户状态为 col username for a20  col account_status for a20 SQL> select username,account_status,LOCK_DATE,EXPIRY_DATE from user
10g的exp出数据出现“Export terminated successfully with warnings”
Focus on Minds
05-08 4089
1、导出exp用法[oracle@ocmserver]exp help=yExport: Release 10.2.0.1.0 - Production on Mon Nov 26 22:53:41 2012Copyright (c) 1982, 2005, Oracle.    All rights reserved.You can let Export prompt you for param
IMPDP出现ORA-39083、ORA-14102 Or ORA-39083、ORA-2158、ORA-39112
Focus on Minds
05-08 3513
这是ORACLE在11.2.0.1.0，11.2.0.1.1，11.2.0.1.2三个版本的BUG问题，需下载补丁处理。 补丁号：8795792 ORACLE官网查看地址： https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=PROBLEM&id=1066635.1 案例讲的非常清楚，希望有帮助。
plsql9.0.6.1665版本注册码
Focus on Minds
05-08 1339
code:j6stndb9tk72xfbhbqczcdqnjd8lyj466nnumber:882851ps：xs374ca本文出自 “Focus on Oracle” 博客，请务必保留此出处http://alexy.blog.51cto.com/6115453/1067344
10g安装出现oraInventory目录问题
Focus on Minds
05-08 1224
问题背景因之前安装过数据库11.2.0.1.0和11.2.0.3.0数据库，在环境变量倒换之间出现错误，通过kill进程的方法删除了数据库。然后删除了datafile等文件。在第二次安装的时候，出现如下情况[oracle@aisms]./runInstaller You do not have sufficient permissions to access the inventory '/dat
Oracle 11g安装步骤详解
建议解锁常用账户如`scott`，以便后续使用。解锁账户时，同样可以设置一个简单的密码，不必遵循Oracle的复杂密码规则。 最后，验证安装是否成功，你可以通过“开始”菜单，找到Oracle 11g的程序组，然后启动“Sql...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值