[20160513]安装UTL_DBWS在11g.txt

--//工作需要,需要安装UTL_DBWS包,做一个记录.

--//安装机器11.2.0.4 linux.

1.环境:
SYS@book> @ &r/ver1
PORT_STRING         VERSION        BANNER
------------------- -------------- --------------------------------------------------------------------------------
x86_64/Linux 2.4.xx 11.2.0.4.0     Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

--安装参考链接:
https://oracle-base.com/articles/10g/utl_dbws-10g

2.首先下载包:
http://download.oracle.com/technology/sample_code/tech/java/jsp/dbws-callout-utility-10131.zip

--//解压到zip文件进入$ORACLE_HOME/sqlj/lib目录.

# 11g and 12c
loadjava -u sys/oracle -r -v -f -genmissing -s -grant public dbwsclientws.jar dbwsclientdb11.jar

--在安装过程结束,会报一些错误,内容如下:

The following operations failed
class com/sun/jmx/interceptor/DefaultMBeanServerInterceptor$1: creation (createFailed)
class com/sun/jmx/interceptor/DefaultMBeanServerInterceptor$ListenerWrapper: creation (createFailed)
class com/sun/jmx/interceptor/DefaultMBeanServerInterceptor: creation (createFailed)
......

--//可以不必理会这些错误.继续安装

3.授权问题:
$ sqlplus / as sysdba

SQL> @utl_dbws_decl
SQL> @utl_dbws_body

SQL> CREATE PUBLIC SYNONYM utl_dbws FOR sys.utl_dbws;
SQL> GRANT EXECUTE ON sys.utl_dbws TO test;

4.测试:

--可以直接使用链接自带的例子:https://oracle-base.com/articles/10g/utl_dbws-10g,不过测试机器要能连接互联网.
--我的测试就卡在这里,实际上认真看看脚本就很容易理解了.