Oracle 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/