Oracle system帐号一直被锁

最新推荐文章于 2024-03-15 10:08:48 发布

转载最新推荐文章于 2024-03-15 10:08:48 发布 · 244 阅读

文章标签：

#数据库

本文描述了Oracle数据库中system账号频繁被锁定的现象，并通过调查发现是由Oracle Performance Monitor组件使用硬编码密码导致。提供了通过operfcfg工具修改SYSTEM账号密码解决该问题的方法。

Oracle2003 EE SP2

oracle10.2.0.3

现象：system帐号平均十几分钟被锁一次

查看system profile为default,全部是默认设置

查看user$表中system lcount值会增长，直到10，system再次被锁，unlock后反复出现同样情况

建trigger捕获未成功登录的信息，发现是一个叫NMUPM.EXE 的进程。

在以下网址找到与我同样的情况，内有解决方案：

http://www.itags.org/database/1034603/

摘录：

I found the reason this is happening. This is due to Bug 3478119. The cause of this behavior. is due to the Oracle Performance Monitor (oraperf.dll) which is a performance DLL that is attempting to connect to the database using incorrect credentials. oraperf.dll and all other performance DLLs are being loaded when nmupm.exe is called by the Management Agent. The install of Oracle Performance Monitor hardcodes the password for the database "SYSTEM" account to "MANAGER". This causes the SYSTEM user to get locked out when the DLL is loaded. This can occur on Windows Platforms. Although I had installed Oracle Counters for Windows Performance Monitor I was not yet using it. In order to resolve The 10g Windows documentation informs customers to run a tool called operfcfg to change the system password. The command is: operfcfg.exe -U system -P {your system password} -D {SID}. I did this yesterday and so far the system account has not locked.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10640532/viewspace-620672/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10640532/viewspace-620672/