本文介绍了oracle 11g r2-ODAC安装后将dbmsclr.plb部署为sysdba的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我刚完成在系统上安装ODTwithODAC112012的操作.现在,我正在尝试部署dbmsclr.plb

I just finished installing ODTwithODAC112012 on my system. Now I am trying to deploy dbmsclr.plb

但是我得到的错误SP2-024没什么可改变的.

But I am getting the error SP2-024 nothing to change.

这是命令窗口:-

C:\>sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Tue Aug 14 22:59:39 2012

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

SQL> connect sys/Bel29072012 as SYSDBA
Connected.
SQL> C:\app\thoshiba\product\11.2.0\dbhome_1\RDBMS\ADMIN\dbmsclr.plb
SP2-0024: Nothing to change.
SQL> select count(*) from all_objects where object_name='DBMS_CLR';

  COUNT(*)
----------
         0

SQL> select count(*) from all_objects where object_name='DBMS_CLR' AND owner='SYS';

  COUNT(*)
----------
         0

SQL>

请让我知道如何解决此问题.

Please let me know how to overcome this issue.

推荐答案

要解决"SP2-024无需更改"的错误,需要添加 @ ,然后再运行类似

To gedrid of "SP2-024 nothing to change" error Need to add @ before running the script like

SQL> @C:\app\thoshiba\product\11.2.0\dbhome_1\RDBMS\ADMIN\dbmsclr.plb

这篇关于oracle 11g r2-ODAC安装后将dbmsclr.plb部署为sysdba的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

07-23 13:12
查看更多