[20160513]安裝UTL_DBWS在11g.txt

[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

--安裝參考連結:


2.首先下載包:


--//解壓到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.測試:

--可以直接使用連結自帶的例子:,不過測試機器要能連線網際網路.
--我的測試就卡在這裡,實際上認真看看指令碼就很容易理解了.