ORA-28000: the account is locked-的解决办法
2009-11-11 18:51
ORA-28000: the account is locked
第一步:使用PL/SQL,登录名为system,数据库名称不变,选择类型的时候把Normal修改为Sysdba;
第二步:选择myjob,查看users;
第三步:选择system,右击点击“编辑”;
第四步:修改密码,把“帐户被锁住”的勾去掉;
第五步:点击“应用”再点击“关闭”;
第六步:重新登录就可以通过验证了;
第二种
ALTER USER username ACCOUNT UNLOCK;
第三种
在plsql developer中要是以scott/tiger登录时提示ora-28000 the account islocked。
解决办法:
新装完Oracle10g后,用scott/tiger测试,会出现以下错误提示:
<wbr><wbr><wbr><wbr><wbr><wbr><wbr>oracle10g the account is locked<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr>oracle10g the password has expired<br>
原因:默认Oracle10g的scott不能登陆。<br>
解决:<br>
(1)conn sys/sys as sysdba; //以DBA的身份登录<br>
(2)alter user scott account unlock;// 然后解锁<br>
(3)conn scott/tiger //弹出一个修改密码的对话框,修改一下密码就可以了</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
在运行里面输入cmd在DOS模式下输入sqlplus,以system用户名登录,密码是刚装oracle时自己填写的密码orcl,登录进去以后。
SQL> conn sys/sys assysdba;<wbr><wbr><wbr><wbr><wbr><wbr>(分号是必须的但是我是以system登录的所在这不应该写conn sys/sys as sysdba应该写connsystem/orcl as sysdba;)<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>Connected.<br>
SQL> alter user scott account unlock;<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>User altered.<br>
SQL> commit;<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>Commit complete.<br>
SQL> conn scott/tiger//请输入新密码,并确认后OK<br>
Password changed<br>
Connected.</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
<wbr></wbr>
这时再到plsql developer里面以scott/tiger登录就可以了。。。。。
<wbr></wbr>
Oracle 10g 默认安装带来的用户名/密码
<wbr><wbr> Username<br>
Password<br>
Description<br>
See Also</wbr></wbr>
CTXSYS
CTXSYS
The Oracle Text account
Oracle Text Reference
DBSNMP
DBSNMP
The account used by the Management Agent component of OracleEnterprise Manager to monitor and manage the database
Oracle Enterprise Manager Grid Control Installation and BasicConfiguration
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 routerda<wbr>ta<br>
Oracle Spatial User's Guide and Reference</wbr>
MDSYS
MDSYS
The Oracle Spatial and Oracle interMedia Locator administratoraccount
Oracle Spatial User's Guide and Reference
DMSYS
DMSYS
The Oracle Da<wbr>ta Mining account.<br>
Oracle Da<wbr>ta Mining Administrator's Guide</wbr></wbr>
Oracle Da<wbr>ta Mining Concepts</wbr>
OLAPSYS
MANAGER
The account used to create OLAP metadata structures. It owns theOLAP Catalog (CWMLite).
Oracle OLAP Application Developer's Guide
ORDPLUGINS
ORDPLUGINS
The Oracle interMedia user. Plug-ins supplied by Oracle and thirdparty 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 enablesyou to maintain the same execution plans for the same SQLstatements. OUTLN acts as a role to centrally manage metadataassociated 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 StillImage 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 databaseadministration tasks. Note that SYS and SYSTEM can also performthese tasks.
Oracle Enterprise Manager Grid Control Installation and BasicConfiguration
SYSTEM
MANAGER
Another account used to perform database administration tasks
分享到:
相关推荐
ora-01033:oracle initialization or shutdown in progress 解决方法 ora-01033:oracle initialization or shutdown in progress 解决方法 ora-01033:oracle initialization or shutdown in progress 解决方法 ora-...
在运行查询SELECT * FROM V$SESSION 会出现ORA-29275:部分多字节字符的错误,这是什么原因开始我不得其解,网上也没有介绍什么好办法。本文给出答案。
ORA-32001:write to spfile requested but no spfile is in use请求写入spfile,但没有使用spfile的解决方法 在输入以下语句中报了这样的错误: SQL>alter system set control_files=’/u01/app/oracle/oradata/prod/...
ORA-12154: TNS: 无法解析指定的连接标识符的解决方法
ORA-00031:标记要终止的会话解决方案; ORA-00031:标记要终止的会话解决方案;
调整参数后引起,ORA-00838: Specified value of MEMORY_TARGET is too small, needs to be at least 3 2768M 的解决方案
ORA-01036:非法的变量名/编号 oracle特有的错误
错误描述:oracle远程连接服务器出现 ORA-12170 TNS:连接超时 错误检查:有很多是oracle自身安装的问题,但是我这里服务器配置正常,监听正常,服务正常,远程可以ping通服务器。 这里主要是防火墙问题,解决办法: ...
-- 解决ORA-00904: "WMSYS"."WM_CONCAT": 标识符无效 的文件包....... -- 解决ORA-00904: "WMSYS"."WM_CONCAT": 标识符无效 的文件包....... -- 解决ORA-00904: "WMSYS"."WM_CONCAT": 标识符无效 的文件包....... ...
Oracle 回收站功能,彻底删除表ORA-00933:SQL command not properly ended,由于删除触发器引起的。数据交换不能再建触发器。
oracle 12 c ORA-01017: 用户名/口令无效; 登录被拒绝
NULL 博文链接:https://3w1h.iteye.com/blog/1211779
ORA-12541 TNSno listener 的解决方案 ORA-12541 TNSno listener 的解决方案
oracle报错ora-12541:TNS无监听程序
解决ORACLE TNS: 无法解析指定的连接标识符; 里面有步骤
最近在工作中遇到了一个问题,错误是Oracle dbca时报错:ORA-12547: TNS:lost contact,通过查找相关的资料终于找到了解决的方法,下面分享给大家,话不多说了,来一起看看详细的介绍吧。 环境: OS:RHEL6.5 x86-...
CLOB字段类型报错 ORA-01704:文字字符串过长的解决
ORA-12518 TNS:监听程序无法分发客户机连接,在您安装好数据库后配置连接数据库的过程中遇到这类问题应该很头疼吧,不过,当您还是四处查资料来解决您遇到的另你头疼的问题时,如果不经意间看到了这则贴子,那请您升...