• Oracle用户解锁的三种办法及默认的用户与密码


    ORA-28000: the account is locked-的解决办法

    2009-11-11 18:51

    ORA-28000: the account is locked

    第1步:使用PL/SQL,登录名为system,数据库名称不变,选择类型的时候把Normal修改为Sysdba;

    第2步:选择myjob,查看users;

    第3步:选择system,右击点击“编辑”;

    第4步:修改密码,把“帐户被锁住”的勾去掉;

    第5步:点击“应用”再点击“关闭”;

    第6步:重新登录就可以通过验证了;

    第二种

    ALTER USER username ACCOUNT UNLOCK;

    第三种

    在plsql developer中要是以scott/tiger登录时提示ora-28000 the account is locked。

    解决办法:

    新装完Oracle10g后,用scott/tiger测试,会出现以下错误提示:

            oracle10g the account is locked

            oracle10g the password has expired

    原因:默认Oracle10g的scott不能登陆。

    解决:

    (1)conn sys/sys as sysdba; //以DBA的身份登录

    (2)alter user scott account unlock;// 然后解锁

    (3)conn scott/tiger //弹出一个修改密码的对话框,修改一下密码就可以了

    在运行里面输入cmd在DOS模式下输入sqlplus,以system用户名登录,密码是刚装oracle时自己填写的密码orcl,登录进去以后。

    SQL> conn sys/sys as sysdba;       (分号是必须的但是我是以system登录的所在这不应该写conn sys/sys as sysdba应该写conn system/orcl as sysdba;)

             Connected.

    SQL> alter user scott account unlock;

             User altered.

    SQL> commit;

             Commit complete.

    SQL> conn scott/tiger//请输入新密码,并确认后OK

    Password changed

    Connected.

    这时再到plsql developer里面以scott/tiger登录就可以了。。。。。

    Oracle 10g 默认安装带来的用户名/密码

       Username

    Password

    Description

    See Also

    CTXSYS

    CTXSYS

    The Oracle Text account

    Oracle Text Reference

    DBSNMP

    DBSNMP

    The account used by the Management Agent component of Oracle Enterprise Manager to monitor and manage the database

    Oracle Enterprise Manager Grid Control Installation and Basic Configuration

    LBACSYS

    LBACSYS

    The Oracle Label Security administrator account

    Oracle Label Security Administrator's Guide

    MDDATA

    MDDATA

    The schema used by Oracle Spatial for storing Geocoder and router data

    Oracle Spatial User's Guide and Reference

    MDSYS

    MDSYS

    The Oracle Spatial and Oracle interMedia Locator administrator account

    Oracle Spatial User's Guide and Reference

    DMSYS

    DMSYS

    The Oracle Data Mining account.

    Oracle Data Mining Administrator's Guide

    Oracle Data Mining Concepts

    OLAPSYS

    MANAGER

    The account used to create OLAP metadata structures. It owns the OLAP Catalog (CWMLite).

    Oracle OLAP Application Developer's Guide

    ORDPLUGINS

    ORDPLUGINS

    The Oracle interMedia user. Plug-ins supplied by Oracle and third party format plug-ins are installed in this schema.

    Oracle interMedia User's Guide

    ORDSYS

    ORDSYS

    The Oracle interMedia administrator account

    Oracle interMedia User's Guide

    OUTLN

    OUTLN

    The account that supports plan stability. Plan stability enables you to maintain the same execution plans for the same SQL statements. OUTLN acts as a role to centrally manage metadata associated with stored outlines.

    Oracle Database Performance Tuning Guide

    SI_INFORMTN_SCHEMA

    SI_INFORMTN_SCHEMA

    The account that stores the information views for the SQL/MM Still Image Standard

    Oracle interMedia User's Guide

    SYS

    CHANGE_ON_INSTALL

    The account used to perform database administration tasks

    Oracle Database Administrator's Guide

    SYSMAN

    CHANGE_ON_INSTALL

    The account used to perform Oracle Enterprise Manager database administration tasks. Note that SYS and SYSTEM can also perform these tasks.

    Oracle Enterprise Manager Grid Control Installation and Basic Configuration

    SYSTEM

    MANAGER

    Another account used to perform database administration tasks

  • 相关阅读:
    计数
    表单验证
    获取位置
    jq事件
    jq选择器
    PHP超文本预处理器(通用开源脚本语言)
    文字超出两行显示省略号
    Vim配置:在win10下用vim编译运行C/C++(异步插件管理,一键运行)
    实验楼HTML基础入门学习
    博客园美化:添加目录,标题设置,代码高亮,主题设置
  • 原文地址:https://www.cnblogs.com/rusking/p/4670477.html
Copyright © 2020-2023  润新知