[原创]rman提示ORA-01031: insufficient privileges
刚安装了一台元数据测试机，结果发现rman连不上，报01031错误。<br>错误如下：<br><div id="codeText" class="codeText"><ol style="margin:0 1px 0 0;padding:5px 0;" start="1" class="dp-css"><li>C:\Documents and Settings\lihw>rman target / </li><li></li><li>
恢复管理器: Release 10.2.0.1.0 - Production on 星期一 8月 15 11:01:59 2011 </li><li>
</li><li>
Copyright (c) 1982, 2005, Oracle.All rights reserved. </li><li>
</li><li>
RMAN-00571: ===========================================================</li><li>
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============</li><li>
RMAN-00571: ===========================================================</li><li>
RMAN-00554: 内部恢复管理器程序包初始化失败 </li><li>
RMAN-04005: 目标数据库中存在错误:</li><li>
ORA-01031: insufficient privileges</li></ol></div>首先想到就是sqlnet.ora配置有问题。于是查看了下sqlnet.ora内容，如下：<br><div id="codeText" class="codeText"><ol style="margin:0 1px 0 0;padding:5px 0;" start="1" class="dp-css"><li># This file is actually generated by netca. But if customers choose to </li><li>
# install "Software Only", this file wont exist and without the native </li><li>
# authentication, they will not be able to connect to the database on NT.</li><li>
</li><li>
SQLNET.AUTHENTICATION_SERVICES = (NTS)</li></ol></div>看到这里想必大家都明白了，原来是域认证没有通过。<br>处理办法非常简单，将该用户加入到ora_dba这个组中即可<br><a href="http://blog.chinaunix.net/attachment/201108/15/14669803_1313379235WXAx.jpg" target="_blank" target="_blank"><img src="http://blog.chinaunix.net/attachment/201108/15/14669803_1313379235WXAx.jpg" .load="imgResize(this, 650);" border="0" ;=""></a><br><br><br><br>
页:
[1]