oracle 11g的ORA-28001 处理
oracle 11g的ORA-28001 处理
<P class=xspace-smalltxt><a href="http://space.itpub.net/batch.common.php?action=viewspace&op=up&itemid=708223&uid=22503721" target="_blank">上一篇</A> / <a href="http://space.itpub.net/batch.common.php?action=viewspace&op=next&itemid=708223&uid=22503721" target="_blank">下一篇</A> 2011-09-24 01:16:28 / 个人分类：<a href="http://space.itpub.net/22503721/spacelist-blog-itemtypeid-87202" target="_blank">Oracle</A> </P>
<DIV class=xspace-itemdata><a href="http://space.itpub.net/22503721/viewspace-708223#xspace-tracks" target="_blank">查看( 382 )</A> / <a href="http://space.itpub.net/22503721/viewspace-708223#xspace-itemreply" target="_blank">评论( 1 )</A> / <a href="http://space.itpub.net/22503721/viewspace-708223#xspace-itemform" target="_blank">评分( <SPAN class=xspace-rategood title=好评>0</SPAN> / <SPAN class=xspace-ratebad title=差评>0</SPAN> )</A> </DIV>
<DIV id=xspace-showmessage class=xspace-itemmessage>
<DIV style="BACKGROUND-COLOR: rgb(254,254,253); COLOR: rgb(0,1,2)"><FONT face=宋体><SPAN style="LINE-HEIGHT: 19px" class=Apple-style-span><FONT size=2>收到一个监控用户无法连接</FONT><A href=".:;" target=_self><U><STRONG><FONT size=2>数据库</FONT></STRONG></U></A><FONT size=2>的告警，</FONT></SPAN></FONT><FONT size=2><SPAN style="LINE-HEIGHT: 22px; FONT-FAMILY: 宋体; FONT-SIZE: small" class=Apple-style-span>Oracle提示错误消息ORA-28001: the password has expired，</SPAN><SPAN style="LINE-HEIGHT: 19px; FONT-FAMILY: 宋体; FONT-SIZE: small" class=Apple-style-span>上去查看用户状态竟然是expired，获取用户基本信息脚本如下：</SPAN></FONT></DIV>
<DIV><SPAN style="LINE-HEIGHT: 19px; BACKGROUND-COLOR: rgb(255,1,2)" class=Apple-style-span><FONT class=Apple-style-span face=宋体>
<DIV><FONT class=Apple-style-span color=#ff0102 size=2>connect / as sysdba;</FONT></DIV>
<DIV><FONT class=Apple-style-span color=#ff0102 size=2>col username for a16</FONT></DIV>
<DIV><FONT class=Apple-style-span color=#ff0102 size=2>col password for a18</FONT></DIV>
<DIV><FONT class=Apple-style-span color=#ff0102 size=2>col user_id for 999999</FONT></DIV>
<DIV><FONT class=Apple-style-span color=#ff0102 size=2>col account_status heading 'Account|Status' for a20</FONT></DIV>
<DIV><FONT class=Apple-style-span color=#ff0102 size=2>col default_tablespace heading 'Default|Tablespace' for a25</FONT></DIV>
<DIV><FONT class=Apple-style-span color=#ff0102 size=2>col temporary_tablespace heading 'Temporary|Tablespace' for a12</FONT></DIV>
<DIV><FONT class=Apple-style-span color=#ff0102 size=2>set lines 125</FONT></DIV>
<DIV><FONT class=Apple-style-span color=#ff0102 size=2>set pages 100</FONT></DIV>
<DIV><FONT class=Apple-style-span color=#ff0102 size=2>select username,user_id,password,account_status,default_tablespace,temporary_tablespace,to_char(created,'yyyy-mm-dd hh24:mi:ss') created</FONT></DIV>
<DIV><FONT class=Apple-style-span color=#ff0102 size=2>from dba_users</FONT></DIV>
<DIV><FONT class=Apple-style-span color=#ff0102 size=2>order by username;</FONT></DIV></FONT></SPAN></DIV><FONT class=Apple-style-span><FONT class=Apple-style-span color=#000102>
<DIV style="BACKGROUND-COLOR: rgb(254,254,253)">
<TABLE style="LINE-HEIGHT: 19px; WIDTH: 800px; TABLE-LAYOUT: fixed">
<TBODY><FONT size=2 face=宋体></FONT></TBODY></TABLE></DIV><FONT size=2><FONT face=宋体><SPAN style="BACKGROUND-COLOR: rgb(254,254,253)" class=Apple-style-span>这是</SPAN><SPAN style="LINE-HEIGHT: 22px; BACKGROUND-COLOR: rgb(254,254,253)" class=Apple-style-span>Oracle11G的一个新特性， Oracle11G创建用户时缺省密码过期限制是180天，</SPAN></FONT></FONT></FONT></FONT><SPAN style="LINE-HEIGHT: 22px; BACKGROUND-COLOR: rgb(254,254,253); FONT-FAMILY: 宋体; FONT-SIZE: small" class=Apple-style-span><FONT size=2>如果超过180天用户密码未做修改则该用户无法登录。</FONT></SPAN><FONT size=3 face=宋体> </FONT>
<DIV><SPAN style="LINE-HEIGHT: 22px; BACKGROUND-COLOR: rgb(254,254,253); FONT-FAMILY: 宋体; FONT-SIZE: small" class=Apple-style-span><FONT size=2>查看PROFILE设置</FONT></SPAN></DIV>
<DIV><FONT class=Apple-style-span face=宋体><SPAN style="LINE-HEIGHT: 22px" class=Apple-style-span><FONT size=2><FONT class=Apple-style-span color=#ff0102>select * from dba_profiles where profile='DEFAULT' and resource_name='PASSWORD_LIFE_TIME';</FONT><BR></FONT></SPAN></FONT>
<DIV style="BACKGROUND-COLOR: rgb(254,254,253); COLOR: rgb(0,1,2)">
<TABLE style="LINE-HEIGHT: 19px; WIDTH: 800px; TABLE-LAYOUT: fixed">
<TBODY style="LINE-HEIGHT: 19px">
<TR style="LINE-HEIGHT: 19px">
<TD style="FILTER: none; ZOOM: 1 !important; WORD-WRAP: break-word; VISIBILITY: visible !important; WORD-BREAK: break-all">
<DIV style="POSITION: static; FILTER: none; OVERFLOW-X: hidden; OVERFLOW-Y: hidden; ZOOM: 1 !important; WORD-WRAP: break-word; VISIBILITY: visible !important; WORD-BREAK: normal" id=blog_text>
<P style="PADDING-BOTTOM: 0px; MARGIN: 0px 0px 10px; PADDING-LEFT: 0px; PADDING-RIGHT: 0px; PADDING-TOP: 0px"><FONT size=2><SPAN style="LINE-HEIGHT: 22px; FONT-FAMILY: 宋体; COLOR: rgb(255,1,2); FONT-SIZE: small" class=Apple-style-span>DEFAULT PASSWORD_LIFE_TIME PASSWORD 180</SPAN><SPAN style="LINE-HEIGHT: normal; BACKGROUND-COLOR: rgb(255,255,255); FONT-SIZE: 12px" class=Apple-style-span><SPAN style="LINE-HEIGHT: 19px; BACKGROUND-COLOR: rgb(254,254,253); FONT-FAMILY: 宋体; COLOR: rgb(255,1,2); FONT-SIZE: small" class=Apple-style-span> </SPAN></SPAN><SPAN style="LINE-HEIGHT: normal; BACKGROUND-COLOR: rgb(255,255,255); FONT-SIZE: 12px" class=Apple-style-span><SPAN style="BACKGROUND-COLOR: rgb(254,254,253)" class=Apple-style-span></SPAN></SPAN></FONT></P>
<P style="PADDING-BOTTOM: 0px; MARGIN: 0px 0px 10px; PADDING-LEFT: 0px; PADDING-RIGHT: 0px; PADDING-TOP: 0px"><SPAN style="LINE-HEIGHT: normal; FONT-SIZE: 12px" class=Apple-style-span></SPAN><SPAN style="LINE-HEIGHT: 22px; FONT-FAMILY: 宋体; COLOR: rgb(0,1,2); FONT-SIZE: small" class=Apple-style-span><FONT size=2>处理逻辑，将用户密码修改并判断是否需要这个策略</FONT></SPAN></P></DIV></TD></TR></TBODY></TABLE></DIV></DIV>
<DIV><SPAN style="BACKGROUND-COLOR: rgb(254,254,253)" class=Apple-style-span>
<DIV>
<TABLE style="LINE-HEIGHT: 19px; WIDTH: 800px; TABLE-LAYOUT: fixed">
<TBODY><FONT size=2></FONT></TBODY></TABLE></DIV></SPAN><SPAN style="LINE-HEIGHT: 19px; BACKGROUND-COLOR: rgb(254,254,253)" class=Apple-style-span><FONT class=Apple-style-span></FONT></SPAN><SPAN style="LINE-HEIGHT: 22px; BACKGROUND-COLOR: rgb(254,254,253); FONT-FAMILY: 宋体; COLOR: rgb(255,1,2); FONT-SIZE: small" class=Apple-style-span><FONT size=2>ALTER USER 用户名 IDENTIFIED BY 密码 ;</FONT></SPAN><SPAN style="BACKGROUND-COLOR: rgb(254,254,253)" class=Apple-style-span>
<DIV>
<TABLE style="LINE-HEIGHT: 19px; WIDTH: 800px; TABLE-LAYOUT: fixed">
<TBODY></TBODY></TABLE></DIV></SPAN><SPAN style="LINE-HEIGHT: 19px; BACKGROUND-COLOR: rgb(254,254,253)" class=Apple-style-span><FONT class=Apple-style-span size=3></FONT></SPAN><SPAN style="LINE-HEIGHT: 22px; BACKGROUND-COLOR: rgb(254,254,253); FONT-FAMILY: 宋体; COLOR: rgb(0,1,2); FONT-SIZE: small" class=Apple-style-span><FONT size=2>语句进行修改密码，密码修改后该用户可正常连接数据库。</FONT></SPAN><SPAN style="BACKGROUND-COLOR: rgb(254,254,253)" class=Apple-style-span>
<DIV style="FONT-SIZE: 14px"></DIV></SPAN>
</DIV>
<DIV><SPAN style="LINE-HEIGHT: 19px; BACKGROUND-COLOR: rgb(254,254,253); FONT-FAMILY: 宋体; COLOR: rgb(0,1,2)" class=Apple-style-span><FONT class=Apple-style-span size=3></FONT></SPAN><SPAN style="LINE-HEIGHT: 22px; BACKGROUND-COLOR: rgb(254,254,253); FONT-FAMILY: 宋体; COLOR: rgb(0,1,2); FONT-SIZE: small" class=Apple-style-span><FONT size=2>如果需要修改策略<BR></FONT></SPAN></DIV><SPAN style="BACKGROUND-COLOR: rgb(254,254,253)" class=Apple-style-span>
<P style="PADDING-BOTTOM: 0px; LINE-HEIGHT: normal; MARGIN: 0px 0px 10px; PADDING-LEFT: 0px; PADDING-RIGHT: 0px; FONT-FAMILY: Arial; FONT-SIZE: 14px; PADDING-TOP: 0px"><FONT style="LINE-HEIGHT: 22px" color=#ff0102 size=2 face=宋体>ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED</FONT></P>
<P style="PADDING-BOTTOM: 0px; LINE-HEIGHT: normal; MARGIN: 0px 0px 10px; PADDING-LEFT: 0px; PADDING-RIGHT: 0px; FONT-FAMILY: Arial; COLOR: rgb(221,221,221); FONT-SIZE: 14px; PADDING-TOP: 0px"><FONT style="LINE-HEIGHT: 22px" color=#000102 size=2 face=宋体>语句将口令有效期默认值180天修改成“无限制”。</FONT></P></SPAN></DIV>
页:
[1]