注册 登录  
 加关注
   显示下一条  |  关闭
温馨提示!由于新浪微博认证机制调整,您的新浪微博帐号绑定已过期,请重新绑定!立即重新绑定新浪微博》  |  关闭

中华神鸟

QQ:935658701

 
 
 

日志

 
 

ORA-01017 invalid username/password;logon denied、ORA-28000: the account is locked( Oracle密码丢失,账号被锁解决方案)  

2013-03-16 17:08:23|  分类: 软件异常处理 |  标签: |举报 |字号 订阅

  下载LOFTER 我的照片书  |
Oracle账户密码忘了,试了几次账号被锁了,使用如下方法成功解决!

首先按如下格式输入,口令为空,直接回车。
请输入用户名:  conn /as sysdba
输入口令:

回车后显示如下信息

连接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

将scott用户的密码修改为tiger并解锁
	 img{f /empty.pngns< 发: rgb(255, 252, 246)eg.  >SQL
facl byer 975v clid直接回车。
<_ thes whe鈚i the acc='SCOTT'v cOracle Dar并解锁
<
<
<
<
<
<
<
<
<
<
<>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> cOracle DaSCOTT/div><
<
<
<<<<<<<<<

        

  scOracwa.  =  . v>
      div>O:12px;color:#ff0000 class="cp">   blov>
      .  =/span>milov>
      .  = =/th=liate=blog&cab.bst.126t{btxt/css" rstyles/mifraduozhpng?   " id=".  =  .  =/span>
      .  =/span>m11 转发至nbsp/span>
      . /span>
      scOracwaway">
lov>
      . v>
      nbw-blog-sta =/Orasp;“扫襤ttrge    s
	3loftf="ht800gn:ass=terv>
      nb =/span>ofol(絃OFTER" clasht iWiadC饩龇log24/span><)/span>3 m2a">緑>
      nb =/span>评论(絃OFTER" clasht iC   f>
C饩龇lo0/span><)/span>
      nbscOracwa.  =  . nbw-blog-sta =v>
      nbsOras:12px;c0 0 12p4nbsp="pleft">
	4nbsperv>
      nb =/Orasp;“扫褺tn_l rog-erv>
      nb = =/span>:12px;color:#ff0000 class="cpass=1 hp1 hp-{di"iblo7">3 m2a">緑>
      nb = =/Orasp;“扫襥d="$_shareBtn_lofter2" title="分享到LOFTER" class="shareitm loter f-bkicons"> 
                "> 
                 
                s"> 
                
                
div class="code2dimlayer fc06">

1s="thide nb-jsc mdl_t簧ā

将文章分享到朋友圈。

 
js"> . = . . =/inpu v:leef>" acc hirdId" 280uc 5074087" tar306tru9cus="="_bl80" 0" 7083069cu片  

首先按如下格式输<cOra
请输入用户名:  conn /as sy<cOra输入口令:
<<cOra连接到:
/span><3 phide . =/ ztag"><. = . . =. =/ . = . = /cOracwa. = . . /cOracwa. = . /cOracwa. = /cOracwa. = /Orasp;“扫襰n v> div>O:12px;color:#ff0000 class="cp
rdogon icn0 iOraRe 赢莡s="true nbw-blog ztag">
OR" cyo/a>nk"sp;“扫襱icntwrap"> s
20px;"> g"> /cOracwa /Orasp;“扫襱ruon= 握撕veblog v> =/h4sp;“扫襱icntwrap"> =blo7 clear历史上的今天 4 v> =/Orasp;“扫襜 bds2 bsp;nt zta1 nbw-blog. = . /cOracwa /Oras*(_hblock space ic;visibatity::leef>;order:0;0 0 12p0;comrfonw::leef>;"sp;“扫 > =/h4sp;“扫襱icntwrap"> =blo7 clear最近读者 4 v> /Orasp;“扫襜 bds2 bsp;nt zta1 nbw-blog /cOracwa /Oras*(_hblock space ic;visibatity::leef>;order:0;0 0 12p0;comrfonw::leef>;"sR" chor/s
=blo7 clear热度 4 v> /OrasR" chorlofo"sp;“扫襜 bdp;nt zta1 nbw-blog /cOracwa /Orasp;“扫褺nk_ *(_hbl_zoom:1ter/cOracwa > /Orasp;“扫襱tlmlee;ntk"s*(_hblock space ic2>> = =/ href="htad="pdin er="0" scrolling=R" clmle height="240" frameborder="0" scrollin59"no" allowt> /cOracwa > /Ora>> /h4sp;“扫襱icntwrap"> =blo7 cleas*(_hblap注 3nbspf="ht800gn:ass=ter在 fc03 的 cla 4 v> p phid*(_hblorder:;">> /ht="0" *(_hblmax-order:78nbsper="0":ttp://wttp:/5bspolor:#ff 握cdinR" clofts allowtransparencyript/messageww. 穖>> > =div>O:12px;c0 0 12p4nbsp="pleft"> 4nbsper="0":t5bs//w15bs//; 1bs/so000:#d5d5d5;/empty.png:#ffffe1pf="ht800gn:ass=ter> = =/;0 0 12plank"="pleft"> lank" href="http:/16p:/ttp://ion:noned7854e;curs发:poiductp2>naoaut
. div>O:12px;cap注 fc03 ,> ,人人有奖!/div>> =/cOracwa /cOracwa /Orasp;“扫襰< 赢穕o> =/h4sp;“扫襱icntwrap"> =blo7 clea"评论 4 v> =/ h acc 握薈 f> inR" c 握薈 f> i nb yo/a>nk_one;">八招_zoom:1ter/cOracwa. = /cOracwa. = /Orasp;“扫襝=kl iblock =/f="h/s his.p={ m:2,v> =. =b:2,v> =. = 穖>Perm800nk:'',v> =. =id:'5074087" tar306tru9cus="="_bl80" 0" 7083069cu片 =. = 握薃bstra2t:'/Ora\褂萌缦路椒ǔ晒饩觯

首先按如下格式输入,縗诹钗猏诹br\诹cOra\诹钗猏赿iv>
请输入用户名:  conn /as sy羉Ora\诹钗猏赿iv>输入口令:
<羉Ora\诹钗猏谠示如下信羉Ora\诹钗猏诹br\诹cOra\诹钗猏趘>连接到:
With the Partitioning, OLAP, Data Mi\诹钗猏趎d Real Application Testing options

将scott用户的密铝cOra\诹钗猏诹br\诹cOra\',v> =. = 握薱la:'oraied、O,oraiВ,ora20p,锁定,1808',v> =. = 握丝祭:entNo0&act=qbbkfxtj_20150420_05"> ',v> =. =isPublofhed:1,v> =. =i 瞤:fa; ,v> =. =%B3%:0,v> =. =moog-y); :13634277980"1,v> =. =lank"sh); :1363424903594,v> =. = m800nk:' 握0&act=qbbkfxtj_20150420_05"> ',v> =. =s< 赢稢饩龇:0,v> =. =mid=C f> C饩龇:0,v> =. =fts< 赢荂饩龇:0,v> =. =bsrk:- =. = ublofherId:0,v> =. =fts< B握薍┛:fa; ,v> =. =curyId(Rts< B握:fa; ,v> =. =at饶鉮 f> sFul>Ids:[],v> =. =m> =. =group =. =
  • =. =>  :'unFameow',v> =. =lanSucc:'',v> =. =visis=", Ovincb:'',v> =. =visis="C=ky:'',v> =. =visis="NewUthe:fa; ,v> =. =l Add =. =m吕:'tar',v> =. =ms =. =srk:- =. =remy='goodnallo 握:fa; ,v> =. =isBlackVisis=":fa; ,v> =. =is> Yo/a>Ad:fa; ,v> =. = IER緊:'',v> =. =hms =. =%8DfRts< B握薈饩龇:'r',v> =. = 穖>;"s?url=http://9_03&newloginenclalEER精/sta 握薬限& 握" margiBs lere">< nbht="0">'v> =. /scri /f="h/s {lofo a r> {if x.visis="Nacc==visis=". theNacc}v> /th=l un><{x.visis="N)" acc|escape}" terrrore" his.?url {'; if x..comFaom=='iphter'/script =. =/ href="ht63.cos="ter/selection?id= n {'; if x..comFaom==' {'; if x..comFaom=='mobatr'/script =. =/ href="ht63.cos="ter/selection?id=get="_blank" h 握薶ilin.blothevouts/ s 握薶html
  • s="m2a"wapIdiver/div> {bht/script = =/ hp;“扫襜loc1m =/ /cOracwa. =/cOracwa. ={bht/script{ st/scri /f="h/s / hr/selection?id=1p;“扫襜loc1m /Orasp;“扫襥dur"ziha微${ 8DfIER緊|escape}{if gs }{bht/羉Ora-v> /Orasp;“扫襛2ts号被锁了cOracwa /Orasp;“扫襪bga /#--最新b-js,群,-js/weba =/f="h/s {lofo a r> <="line-heblo易> he过这篇-js的人ogTa Ora-v> ={lofo a r> /th=l un><{x.fts< 赢莌eN)" acc|escape}" terrrore" his.?url =/ /Orasp;“扫襝wl aldivn-v> / href="htbloc1m . =${fn(x.fts< 赢莌eN:// acc,6)|escape}v> = / / Ora-v> =/ Ora-v> ={bht/scri = ={b st/scri / Ora-v> {if !!b&&b.length>0/script/p sp;“扫襜lo易兴腔> he/digTa ofterifra{lofo b r> "${yjs"s< 赢 bds2T f-b|escape}/ /#--引用糴 i/weba =/f="h/s转"糴 iogTagInfov> < t {lofo d r> =/Orasp;“扫襬 aldiv Btn_l< n = /Orasp;“扫襬 r Btn_l< n = v> {lofo a r> he/weba =/f="h/sv> {lofo a r> < >v> ={lofo a r> . = . v> /#--被> he-js/weba =/f="h/s {lofo a r>订阅<62"nr/div> ./Orasp;“扫褺tn_l aldivn-/ hp;“扫襪 .解tB握薖erm800nk} .解tB握薚 f-b|escape}/ {bht/script {if !!( 握薉> .n="hB握薖erm800nk)/script ==/span>订阅<6span> ./Orasp;“扫褺span> .n="hB握薖erm800nk} .n="hB握薚 f-b|escape}/ {bht/scri /#-- 热度iv> v> /f="h/s {lofo a r> {if x.lank"sherUthe acc==visis=". theNacc}v> /th=l un><{x.lank"sherN)" acc|escape}" terrrore" his.?url . =${fn(x.lank"sherN)" acc,8)|escape}v> . / / Ora-v> =/ href="htb-myLikeIdiv福hor%B3% {if x.%B3%E=1} js-﹊ke%B3%{'; if x.%B3%E=2} js-rm/ext%B3%{'; if x.%B3%E=3} js-id="$fB3%{'; }{bht/ter/selection?id=t:divf); s get="_blank" h 握薶ilin.blo<{x.lank"sherUthe acc} / Ora-v> {bht/script{b st/scri v> /#-- dth=新闻广告 iv> v> /f="h/s . =====/Orasp;“扫