本文介绍了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的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!