oracle用户解锁
查看oracle实例有哪些用户？ 涉及的表为dba_users [oracle@rtest ~]$ sqlplus /nologSQL*Plus: Release 11.2.0.3.0 Production on Mon Sep 2 11:05:49 2013Copyright (c) 1982, 2011, Oracle. All rights reserved.idle conn /as sysdbaConnected.sys@TESTDB
查看oracle实例有哪些用户？
涉及的表为dba_users
[oracle@rtest ~]$ sqlplus /nolog SQL*Plus: Release 11.2.0.3.0 Production on Mon Sep 2 11:05:49 2013 Copyright (c) 1982, 2011, Oracle. All rights reserved. idle> conn /as sysdba Connected. sys@TESTDB> desc dba_users Name Null? Type ----------------------------------------------------- -------- ------------------------------------ USERNAME NOT NULL VARCHAR2(30) USER_ID NOT NULL NUMBER PASSWORD VARCHAR2(30) ACCOUNT_STATUS NOT NULL VARCHAR2(32) LOCK_DATE DATE EXPIRY_DATE DATE DEFAULT_TABLESPACE NOT NULL VARCHAR2(30) TEMPORARY_TABLESPACE NOT NULL VARCHAR2(30) CREATED NOT NULL DATE PROFILE NOT NULL VARCHAR2(30) INITIAL_RSRC_CONSUMER_GROUP VARCHAR2(30) EXTERNAL_NAME VARCHAR2(4000) PASSWORD_VERSIONS VARCHAR2(8) EDITIONS_ENABLED VARCHAR2(1) AUTHENTICATION_TYPE VARCHAR2(8)
查看用户状态：
sys@TESTDB> select username,account_status from dba_users; USERNAME ACCOUNT_STATUS ------------------------------ -------------------------------- SYS OPEN SYSTEM OPEN OUTLN EXPIRED & LOCKED MGMT_VIEW EXPIRED & LOCKED FLOWS_FILES EXPIRED & LOCKED MDSYS EXPIRED & LOCKED ORDSYS EXPIRED & LOCKED EXFSYS EXPIRED & LOCKED DBSNMP EXPIRED & LOCKED WMSYS EXPIRED & LOCKED APPQOSSYS EXPIRED & LOCKED APEX_030200 EXPIRED & LOCKED OWBSYS_AUDIT EXPIRED & LOCKED ORDDATA EXPIRED & LOCKED CTXSYS EXPIRED & LOCKED ANONYMOUS EXPIRED & LOCKED SYSMAN EXPIRED & LOCKED XDB EXPIRED & LOCKED ORDPLUGINS EXPIRED & LOCKED OWBSYS EXPIRED & LOCKED SI_INFORMTN_SCHEMA EXPIRED & LOCKED OLAPSYS EXPIRED & LOCKED SCOTT EXPIRED & LOCKED ORACLE_OCM EXPIRED & LOCKED XS$NULL EXPIRED & LOCKED BI EXPIRED & LOCKED PM EXPIRED & LOCKED MDDATA EXPIRED & LOCKED IX EXPIRED & LOCKED SH EXPIRED & LOCKED DIP EXPIRED & LOCKED OE EXPIRED & LOCKED APEX_PUBLIC_USER EXPIRED & LOCKED HR EXPIRED & LOCKED SPATIAL_CSW_ADMIN_USR EXPIRED & LOCKED SPATIAL_WFS_ADMIN_USR EXPIRED & LOCKED 36 rows selected.
比如解锁sh账户，sh账户为OCP考试需要用到的用户，SH账户里涉及的多张表在OCP有涉及考试。
目前SH的账户的状态为：EXPIRED & LOCKED
用以下命令给SH账户解锁：
sys@TESTDB> alter user sh account unlock; --解开LOCKED
sys@TESTDB> alter user sh identified by sh;--解开EXPIRED
sys@TESTDB> alter user sh account unlock; User altered. sys@TESTDB> select username,account_status from dba_users; USERNAME ACCOUNT_STATUS ------------------------------ -------------------------------- SYS OPEN SYSTEM OPEN SH EXPIRED OUTLN EXPIRED & LOCKED MGMT_VIEW EXPIRED & LOCKED FLOWS_FILES EXPIRED & LOCKED MDSYS EXPIRED & LOCKED ORDSYS EXPIRED & LOCKED EXFSYS EXPIRED & LOCKED DBSNMP EXPIRED & LOCKED WMSYS EXPIRED & LOCKED APPQOSSYS EXPIRED & LOCKED APEX_030200 EXPIRED & LOCKED OWBSYS_AUDIT EXPIRED & LOCKED ORDDATA EXPIRED & LOCKED CTXSYS EXPIRED & LOCKED ANONYMOUS EXPIRED & LOCKED SYSMAN EXPIRED & LOCKED XDB EXPIRED & LOCKED ORDPLUGINS EXPIRED & LOCKED OWBSYS EXPIRED & LOCKED SI_INFORMTN_SCHEMA EXPIRED & LOCKED OLAPSYS EXPIRED & LOCKED SCOTT EXPIRED & LOCKED ORACLE_OCM EXPIRED & LOCKED XS$NULL EXPIRED & LOCKED BI EXPIRED & LOCKED PM EXPIRED & LOCKED MDDATA EXPIRED & LOCKED IX EXPIRED & LOCKED DIP EXPIRED & LOCKED OE EXPIRED & LOCKED APEX_PUBLIC_USER EXPIRED & LOCKED HR EXPIRED & LOCKED SPATIAL_CSW_ADMIN_USR EXPIRED & LOCKED SPATIAL_WFS_ADMIN_USR EXPIRED & LOCKED 36 rows selected. sys@TESTDB> alter user sh identified by sh; User altered. sys@TESTDB> select username,account_status from dba_users; USERNAME ACCOUNT_STATUS ------------------------------ -------------------------------- SYS OPEN SYSTEM OPEN SH OPEN OUTLN EXPIRED & LOCKED MGMT_VIEW EXPIRED & LOCKED FLOWS_FILES EXPIRED & LOCKED MDSYS EXPIRED & LOCKED ORDSYS EXPIRED & LOCKED EXFSYS EXPIRED & LOCKED DBSNMP EXPIRED & LOCKED WMSYS EXPIRED & LOCKED APPQOSSYS EXPIRED & LOCKED APEX_030200 EXPIRED & LOCKED OWBSYS_AUDIT EXPIRED & LOCKED ORDDATA EXPIRED & LOCKED CTXSYS EXPIRED & LOCKED ANONYMOUS EXPIRED & LOCKED SYSMAN EXPIRED & LOCKED XDB EXPIRED & LOCKED ORDPLUGINS EXPIRED & LOCKED OWBSYS EXPIRED & LOCKED SI_INFORMTN_SCHEMA EXPIRED & LOCKED OLAPSYS EXPIRED & LOCKED SCOTT EXPIRED & LOCKED ORACLE_OCM EXPIRED & LOCKED XS$NULL EXPIRED & LOCKED BI EXPIRED & LOCKED PM EXPIRED & LOCKED MDDATA EXPIRED & LOCKED IX EXPIRED & LOCKED DIP EXPIRED & LOCKED OE EXPIRED & LOCKED APEX_PUBLIC_USER EXPIRED & LOCKED HR EXPIRED & LOCKED SPATIAL_CSW_ADMIN_USR EXPIRED & LOCKED SPATIAL_WFS_ADMIN_USR EXPIRED & LOCKED 36 rows selected.
查看SH用户有哪些表？
sh@TEST0924> select * from tab; TNAME TABTYPE CLUSTERID ------------------------------ ------- ---------- 1_EMP TABLE BIN$51XUts/lTCDgQwEAAH/BlA==$0 TABLE CAL_MONTH_SALES_MV TABLE CHANNELS TABLE COSTS TABLE COUNTRIES TABLE CUSTOMERS TABLE DIMENSION_EXCEPTIONS TABLE DR$SUP_TEXT_IDX$I TABLE DR$SUP_TEXT_IDX$K TABLE DR$SUP_TEXT_IDX$N TABLE DR$SUP_TEXT_IDX$R TABLE EMP_1 TABLE EMP_2 TABLE EMP_3 TABLE FWEEK_PSCAT_SALES_MV TABLE INVOICE TABLE NEW_SALES TABLE PRICE_LIST TABLE PRODUCTS TABLE PROFITS VIEW PROMOTIONS TABLE SALES TABLE SALES_TRANSACTIONS_EXT TABLE SUPPLEMENTARY_DEMOGRAPHICS TABLE TIMES TABLE TRANSACTIONS TABLE TRANSACTIONS1 TABLE 28 rows selected.
热AI工具
Undresser.AI Undress
人工智能驱动的应用程序，用于创建逼真的裸体照片
AI Clothes Remover
用于从照片中去除衣服的在线人工智能工具。
Undress AI Tool
免费脱衣服图片
Clothoff.io
AI脱衣机
AI Hentai Generator
免费生成ai无尽的。
热门文章
热工具
记事本++7.3.1
好用且免费的代码编辑器
SublimeText3汉化版
中文版，非常好用
禅工作室 13.0.1
功能强大的PHP集成开发环境
Dreamweaver CS6
视觉化网页开发工具
SublimeText3 Mac版
神级代码编辑软件(SublimeText3)
热门话题
oracle如何查表空间大小
Apr 11, 2025 pm 08:15 PM
要查询 Oracle 表空间大小，请遵循以下步骤：确定表空间名称，方法是运行查询：SELECT tablespace_name FROM dba_tablespaces;查询表空间大小，方法是运行查询：SELECT sum(bytes) AS total_size, sum(bytes_free) AS available_space, sum(bytes) - sum(bytes_free) AS used_space FROM dba_data_files WHERE tablespace_
oracle如何获取时间
Apr 11, 2025 pm 08:09 PM
在 Oracle 中获取时间有以下方法：CURRENT_TIMESTAMP：返回当前系统时间，精确到秒。SYSTIMESTAMP：比 CURRENT_TIMESTAMP 更准确，精确到纳秒。SYSDATE：返回当前系统日期，不含时间部分。TO_CHAR(SYSDATE, 'YYYY-MM-DD HH24:MI:SS'): 将当前系统日期和时间转换为特定格式。EXTRACT：从时间值中提取特定部分，如年份、月份或小时。
oracle如何查看实例名
Apr 11, 2025 pm 08:18 PM
在 Oracle 中查看实例名的方法有三种：命令行中使用 "sqlplus" 和 "select instance_name from v$instance;" 命令。在 SQL*Plus 中使用 "show instance_name;" 命令。通过操作系统的任务管理器、Oracle Enterprise Manager 或检查环境变量 (Linux 上的 ORACLE_SID)。
oracle视图如何加密
Apr 11, 2025 pm 08:30 PM
Oracle 视图加密允许您加密视图中的数据，从而增强敏感信息安全性。步骤包括：1) 创建主加密密钥 (MEk)；2) 创建加密视图，指定要加密的视图和 MEk；3) 授权用户访问加密视图。加密视图工作原理：当用户查询加密视图时，Oracle 使用 MEk 解密数据，确保只有授权用户可以访问可读数据。
Oracle安装失败如何卸载
Apr 11, 2025 pm 08:24 PM
Oracle 安装失败的卸载方法：关闭 Oracle 服务，删除 Oracle 程序文件和注册表项，卸载 Oracle 环境变量，重新启动计算机。若卸载失败，可使用 Oracle 通用卸载工具手动卸载。
oracle无效数字如何排查
Apr 11, 2025 pm 08:27 PM
Oracle 无效数字错误可能由数据类型不匹配、数字溢出、数据转换错误或数据损坏引起。排查步骤包括检查数据类型、检测数字溢出、检查数据转换、排查数据损坏，并探索其他可能的解决方案，如配置 NLS_NUMERIC_CHARACTERS 参数和启用数据验证日志记录。
oracle游标关闭怎么解决
Apr 11, 2025 pm 10:18 PM
解决 Oracle 游标关闭问题的方法包括：使用 CLOSE 语句显式关闭游标。在 FOR UPDATE 子句中声明游标，使其在作用域结束后自动关闭。在 USING 子句中声明游标，使其在关联的 PL/SQL 变量关闭时自动关闭。使用异常处理确保在任何异常情况下关闭游标。使用连接池自动关闭游标。禁用自动提交，延迟游标关闭。
oracle如何设置用户
Apr 11, 2025 pm 08:21 PM
在 Oracle 中创建用户需遵循以下步骤：使用 CREATE USER 语句创建新用户。使用 GRANT 语句授予必要权限。可选：使用 RESOURCE 语句设置配额。配置其他选项，如默认角色和临时表空间。
