精华内容
下载资源
问答
  • python中使用Com组件说明

    万次阅读 2017-09-07 16:27:49
    使用COM文件中的Client中的makepy.py生成COM组件库对话框,双击生成相应的文件 调用 时如下 以前弄了好几天不成功,重装系统后这么容易就成功了。以前在浪费时间吗 from win32...

    使用COM文件中的Client中的makepy.py生成COM组件库对话框,双击生成相应的文件


    调用 时如下 以前弄了好几天不成功,重装系统后这么容易就成功了。以前在浪费时间吗


    from win32com.client import DispatchBaseClass
    from win32com import client

    def GetDBString():
    a1 = client.DispatchEx('{2206CDB2-19C1-11D1-89E0-00C04FD7A829}')
    connString = a1.PromptNew()
    return connString

    print(GetDBString())
     
     
     
    

    展开全文
  • COM组件详细说明

    2013-08-03 20:30:28
    COM组件由以Win 32动态连接库(DLL)或可执行文件(EXE)形式发布的可执行代码所组成
  • 组件说明

    千次阅读 2016-05-05 16:15:56
    react-native-selectablesectionlistview 快速检索列表(按首字母) https://github.com/johanneslumpe/react-native-selectablesectionlistview ...图表组件 https://github.com/tomauty/react-native-c

    react-native-selectablesectionlistview

    快速检索列表(按首字母)

    https://github.com/johanneslumpe/react-native-selectablesectionlistview

     

     

    react-native-chart

    图表组件

    https://github.com/tomauty/react-native-chart

     

     

     

    react-native-animatable

    动画组件

    https://github.com/oblador/react-native-animatable

     

     

    React Native Module for CodePush

    热更新

    https://github.com/Microsoft/react-native-code-push

     

    react-native-auto-updater

    热更新(似乎更好)

    https://github.com/aerofs/react-native-auto-updater

     

     

    React-Native-Remote-Update

    热更新(中国人写的)

     

    https://github.com/fengjundev/React-Native-Remote-Update

     

     

     

     

     

    react-native-refresher

    列表下拉刷新

    https://github.com/syrusakbary/react-native-refresher

     

     

    Gifted ListView

    下拉刷新和加载更多

    https://github.com/FaridSafi/react-native-gifted-listview

     

     

     

    react-native-drawer-layout

    左侧菜单与官方的DrawerLayoutAndroid 用法相同,兼容ios

    https://github.com/iodine/react-native-drawer-layout

     

    react-native-barcodescanner

    条码扫描

    https://github.com/ideacreation/react-native-barcodescanner

     

    react-native-file-transfer

    文件上传

    https://github.com/kamilkp/react-native-file-transfer

     

     

    react-native-communications

    打开url,打电话,发邮件, text?

    https://github.com/anarchicknight/react-native-communications

     

    react-native-toast

    支持androidiostoast

    https://github.com/remobile/react-native-toast

     

    react-native-device-info

    获取设备各类信息

    https://github.com/rebeccahughes/react-native-device-info

     

    WebStorm ReactNative的代码模板插件,包括:

    1.组件名称2.Api 名称3.所有StyleSheets属性4.组件属性

    https://github.com/virtoolswebplayer/ReactNative-LiveTemplate

     

    react-native-cordova-plugin

    react-native调用cordova插件

    https://github.com/axemclion/react-native-cordova-plugin

     

    react-native-google-places-autocomplete

    输入自动完成

    https://github.com/FaridSafi/react-native-google-places-autocomplete

    react-native-bounceable

    抖一抖动画小组件(有点意思)

    https://github.com/slavik0329/react-native-bounceable

     

    react-native-animatable

    封装后动画组件(效果较丰富)

    https://github.com/oblador/react-native-animatable

    Switch:

    getInitialState: function() {

        return {

          switchValue: false,

        };

      },

          <Switch style={{marginLeft:15,}}

                   value={this.state.switchValue}

                 onValueChange={() => this.setState({ switchValue: !this.state.switchValue})}/>

    展开全文
  • WaveCOM短信COM组件开发接口说明,对WaveCOM、西门子等短信收发设备均有效。
  • Oracle Spatial 组件 说明

    万次阅读 2012-03-08 20:59:59
    一.Spatial 组件说明 在之前整理了几篇与Oracle组件相关的Blog:Oracle8i/9i/10g/11g组件(Components) 说明http://blog.csdn.net/tianlesoftware/article/details/5937382 Oracle XDB 组件 重建 说明...

     

    一.Spatial 组件说明

     

    在之前整理了几篇与Oracle组件相关的Blog:

    Oracle8i/9i/10g/11g组件(Components) 说明

    http://www.cndba.cn/Dave/article/1445

     

    Oracle XDB 组件 重建 说明

    http://blog.csdn.net/tianlesoftware/article/details/7323139

     

    Oracle OLAP 组件 重建 说明

    http://blog.csdn.net/tianlesoftware/article/details/7321333

     

    在这篇我们看一下Spatial组件的说明。

     

    在说明之前,我们先用如下SQL查看一下DB中的组件:

    SQL> col comp_id for a15

    SQL> col version for a15

    SQL> col comp_name for a30

    SQL> select comp_id,comp_name,versionfrom dba_registry

     2  ;

     

    COMP_ID         COMP_NAME                      VERSION

    --------------------------------------------- ---------------

    XDB             Oracle XML Database            11.2.0.3.0

    AMD             OLAP Catalog                   11.2.0.3.0

    EM              Oracle Enterprise Manager      11.2.0.3.0

    SDO             Spatial                        11.2.0.3.0

    ORDIM           Oracle Multimedia              11.2.0.3.0

    CONTEXT         Oracle Text                    11.2.0.3.0

    ODM             Oracle Data Mining             11.2.0.3.0

    EXF             Oracle Expression Filter       11.2.0.3.0

    RUL             Oracle Rules Manager           11.2.0.3.0

    OWM             Oracle Workspace Manager       11.2.0.3.0

    CATALOG        Oracle Database CatalogViews  11.2.0.3.0

     

    COMP_ID         COMP_NAME                      VERSION

    --------------------------------------------- ---------------

    CATPROC         Oracle Database Packages and T11.2.0.3.0

                    ypes

     

    JAVAVM         JServer JAVA VirtualMachine   11.2.0.3.0

    XML             Oracle XDK                     11.2.0.3.0

    CATJAVA         Oracle Database Java Packages  11.2.0.3.0

    XOQ             Oracle OLAP API                11.2.0.3.0

    APS             OLAP Analytic Workspace        11.2.0.3.0

     

    17 rows selected.

    --这里是我们DB 的所有组件列表, 其中有关OLAP 组件的说明,之前的Blog 已经说明,这里看一下Spatial 组件。

     

    MOS上对该组件的说明如下:

    Oracle Spatialis an extension to the Oracle RDBMS. An integrated set of functions andprocedures, that enables spatial information to be stored, managed andmaintained within Oracle. 

     

    Oracle Spatialis designed to make spatial data management easier and more natural to users oflocation-enabled applications and geographic information system (GIS)applications. When spatial data is stored in an Oracle database, it can beeasily manipulated, retrieved, and related to all other data stored in thedatabase. 

    --Oracle Spatial 组件是为了让空间数据管理更容易,更自然的使用location-enabled应用和GIS 应用。 当Spatial 数据存储在DB中时,它可以很容易的被操作和恢复,与之相关的其他数据也会存储在DB中。

     

    It is an optionwhich provides integration of location with traditional relational attributedata for Internet and wireless location-based services. However, Oracle Spatialdoes not provide tools for spatial data collection, sophisticated analytical andvisualisation functionality provided by the traditional Geographic InformationSystems (GIS).

     

    Oracle Spatial consists of the following:

    (1)    A schema (MDSYS) thatprescribes the storage, syntax, and semantics of supported geometric datatypes.

    (2)    Spatial indexing mechanisms.

    (3)    A set of spatial operators andfunctions for performing area-of-interest queries, spatial join queries, andother spatial analysis operations.

    (4)    Administrative utilities.

    (5)    Java classes for accessing,manipulating and storing Spatial object types. This will be included in afuture distribution but is currently available from the Oracle TechnicalNetwork (OTN)

     

    Spatial data isany data with a location component. Databases with geographic references, suchas addresses, phone numbers and postal codes may now analyse this informationusing third party geocoding tools and services. The Oracle Spatial geocodingfeature matches these records with a latitude/longitude point that is thenstored in the database. This facilitates analysis based on spatialrelationships of the associated data. The proximity of ATM machines tocustomers within a certain distance and the amount of money withdrawn perterritory are examples of geocoding feature usage.

     

    A common exampleof spatial data can be seen in a road map. A road map is a two-dimensionalobject that contains points, lines, and polygons that can represent cities,roads, and political boundaries such as states or provinces. A road map is avisualization of geographic information. The location of cities, roads, andpolitical boundaries that exist on the surface of the Earth are projected ontoa two-dimensional display or piece of paper, preserving the relative positionsand relative distances of the rendered objects. 

    --Spatial Data 一个常见的示例就是road map。Road Map 是一个二维的对象,其包含点,线和多变形,这些信息可以代表一个城市,街道或者城市和省的边界。Road Map 是地理信息的形象化。

     

    Spatial 组件的用户:

    (1)    MDSYS:

    The Oracle Spatial and Oracle interMedia Locator administratoraccount 

    (2)    MDDATA:

    The schema used by Oracle Spatial for storing Geocoder androuter data 

     

    更多说明参考官网手册:

    http://docs.oracle.com/cd/B19306_01/appdev.102/b14255/toc.htm

    What is Oracle Spatial? A Technical UserIntroduction [ID 102313.1]

     

    二.Spatial 组件重建

    MOS:

    Master Note for Oracle Spatial and OracleLocator Installation [ID 220481.1]

     

    2.1 Spatial 组件卸载

    MOS:

    Steps for Manual De-installation of OracleSpatial [ID 179472.1]

     

    2.1.1 准备工作

    Before deinstalling Oracle Spatial, it isbest to drop all Spatial indexes.

    --在卸载OracleSpatial 组件之前最好drop 掉所有的Spatial 索引。

     

    Check if Spatial indexes exist in thedatabase: 

    --可以使用如下SQL来检查:

    connect / as sysdba 
    select owner,index_name from dba_indexes  where ityp_name ='SPATIAL_INDEX';

     

    Check if tables having Spatial columns(columns having datatype SDO_GEOMETRY) exist:

    --检查是否有表使用Spatial列,即列的类型为:SDO_GEOMETRY.

    set pages 200 
    col owner for a20 
    col table_name for a30 
    col column_name for a25 

    /* Formatted on 2012/3/8 13:48:49 (QP5v5.185.11230.41888) */

     SELECT owner, table_name, column_name

        FROM dba_tab_columns

      WHERE data_type = 'SDO_GEOMETRY' AND owner != 'MDSYS'

    ORDER BY 1, 2,3;

     

    Note: Removing MDSYS will drop (!) existingSDO_GEOMETRY columns from above tables! 

    --在我们卸载Spatial组件时,会drop 掉所有表中包含SDO_GEOMETRY的列。

     

    如果存在SDO_GEOMETRY列,那么参考MOS文档处理:

    Re-installing Spatial with Existing TablesHaving an SDO_GEOMETRY Column [ID 250791.1]

     

    2.1.2 drop Spatial 索引

    To drop Spatial indexes: 
    SQL>drop index <owner>.<indexname>; 

    --如果有索引不能drop,加force 强制drop:

    -- If some indexes cannot be dropped usethe FORCE option: 
    SQL>drop index <owner>.<indexname> force; 

     

    2.1.3 drop Spatical 用户:MDSYS

    Then drop the user MDSYS: 

    SQL>drop user MDSYS cascade; 

     

    2.1.4 drop 同义词

    Optionally drop all remaining publicsynonyms created for Spatial: 

    --可选的操作,drop剩余的同义词,语法如下:

    set pagesize 0 
    set feed off 
    spool dropsyn.sql 
    select 'drop public synonym "' || synonym_name || '";' fromdba_synonyms where table_owner='MDSYS'; 
    spool off;
    @dropsyn.sql

     

    2.1.5 Drop 其他用户

    Spatial alsocreates a few user schemas during installation which can be dropped aswell: 

           --Spatial 在drop 期间也会产生新的用户,这些用户也可以被drop:

     

    SQL>drop user mddata cascade; 


    -- Only created as of release 11g: 

    --这些用户仅在11g中产生:

    SQL>drop user spatial_csw_admin_usrcascade; 
    SQL>drop user spatial_wfs_admin_usr cascade; 

     

    2.1.6 其他注意事项:

    (1)如果我们删除Spatial 后,还可以从v$option中查到记录,如:
    SQL> select * from v$option where parameter = 'Spatial';
    PARAMETER VALUE
    ------------------------------- ----------
    Spatial TRUE

    这个暂时没有没有解决方法,因为与Spatial 相关的表和索引我们之前已经droped,但是v$option 并没有更新,这个可能是Oracle 的BUG:

    BUG:3069432 -V$OPTION NOT UPDATED AFTER DEINSTALLING SPATIAL OPTION

     

    具体可以参考:

    Removed Spatial Option But Spatial StillAppears In V$Option [ID 273573.1]

     

    (2)必须安装Spatial 组件

    如果我们卸载了Spatial 组件之后,又不打算重装Spatial 组件,那么我们至少必须安装Spatial 组件的一个子组件:Oracle Locator。 这样就可以避免以后升级中依赖关系带来的问题,比如XDB 组件。

     

    (3)彻底清除Spatial 组件

    如果Spatial 安装失败或者安装到其他用户下面,那么可以参考如下文档,直接drop 所有相关的对象来清除所有Spatial组件对象。

    AccidentallyInstalled SPATIAL Into SYS, SYSTEM Or Another Schema [ID 413693.1]

     

     

    2.2 Spatial 组件安装

    MOS:

    Steps for Manual Installation /Verification of Spatial 10g / 11g [ID 270588.1]

    Steps for Manual Installation of Oracle 9iSpatial [ID 220484.1]

     

    2.2.1 Oracle 9i 安装Spatial

           在Oracle 9i中,Spatial 组件是预选安装的,只要只要同意,就可以安装了。如果我们使用DBCA 来创建示例,Spatial 组件也是默认安装的。

           如果我们在创建实例时没有安装Spatial 组件,那么可以使用如下方法:

     

    Oracle 9i 中的条件是初始化参数中的COMPATIBLE 参数值大于 9.0.0.0.0.

     

    2.2.1.1 Check if the userORDSYS already exists:

    --检查ORDSYS用户是否存在:

    Connect to the database instance specifyingAS SYSDBA.

    SQL> select username from dba_userswhere username='ORDSYS';

     

    (1)If ORDSYS does NOT exist:

    --如果ORDSYS不存在:

    SQL> @?/ord/admin/ordinst.sql

     

    This will createthe ORDSYS user and the MDSYS user with the required privileges.

    The accountMDSYS will be locked by default by this script (in release 9.2 only).

    这个脚本会创建ORDSYS 和 MDSYS 用户。 在9.2中,MDSYS 默认会被lock。

     

    (2)If the ORDSYS user already existsand the MDSYS user does NOT exist:

    --如果ORDSYS已经存在,而MDSYS 不存在,操作如下:

    create the user MDSYS by running followingcommand:

    create user MDSYS identified by<password> account lock;

    grant the required privileges to MDSYS byrunning:

    SQL> @?/md/admin/mdprivs.sql

     

    (3)    If the ORDSYS user already exists AND the MDSYS user already existsthen you are advised to verify if the installation has been done correctly andde-install Spatial first in case of re-installation. 

    --如果ORDSYS 和MDSYS 都存在,那么就需要在安装之前先卸载他们,具体的卸载不丑,参考第一部分的说明。

     

     

    2.2.1.2 Install Spatial by running thefollowing procedure, as the MDSYS account should be locked you must login assys and then change the current schema:

    --运行如下脚本安装Spatial:

    SQL>connect / as sysdba 
    SQL>alter session set current_schema=MDSYS; 
    SQL>@?/md/admin/mdinst.sql

     

    2.2.1.3 It is strongly recommended that theMDSYS user account remains locked. The MDSYS user is created with administratorprivileges; therefore, it is important to protect this account fromunauthorized use. 

    --默认情况下MDSYS账户是locked的,这个账户有administrator 的权限,因此推荐保持lock 状态,如果解锁,使用如下命令:

     

    To lock the MDSYS user, connect as SYS andenter the following command:

    SQL> alter user MDSYS account lock;

     

    2.2.2 Oracle 10g/11g 安装Spatial

     

    2.2.2.1 准备工作

    To be able to doa successful Spatial 10g / 11g installation you need to have the followingproducts already installed:

    --在Oracle 10g/11g 中安装Spatial 组件,必须先保证如下三个组件已经存在:

    (1)    JServer JAVA Virtual Machine

    (2)    Oracle interMedia   

    (3)    Oracle XML Database

     

    To verify if the products are installed andvalid run:

    --验证以上三个组件,可以使用如下SQL:

    SQL> col comp_id for a12

    SQL> col version for a15

    SQL> col status for a15

    SQL> select comp_id,version,status fromdba_registry where comp_id in ('JAVAVM','ORDIM','XDB');

     

    COMP_ID     VERSION         STATUS

    ------------ ------------------------------

    XDB         11.2.0.3.0      VALID

    ORDIM       11.2.0.3.0      VALID

    JAVAVM      11.2.0.3.0      VALID


    如果没有安装或者无效,就需要解决这些组件,具体可以参考:

    Oracle XDB 组件 重建 说明

    http://blog.csdn.net/tianlesoftware/article/details/7323139


    Oracle JAVAVM 组件 Reload 说明
    http://www.cndba.cn/Dave/article/1328


    Where to Find the Information to Install,Upgrade, Downgrade and Deinstall interMedia/Oracle Multimedia? [ID 337415.1]

     


    2.2.2.2 安装Spatial 组件

    If the MDSYS user does NOT exist:

    --如果MDSYS 用户不存在:

    create the user MDSYS by running followingcommand:

    SQL> createuser MDSYS identified by <password> default tablespace SYSAUX accountlock;

     

    --赋权:

    grant the required privileges to MDSYS byrunning:

       SQL> @?/md/admin/mdprivs.sql

     

    If the MDSYSuser already exists then you are advised to verify if the installation has beendone correctly and de-install Spatial first in case of re-installation.

    --如果用户已经存在,那么在安装之前最好先卸载, 具体卸载步骤参考第一部分。

     

       See the verification checks at the bottom of this note and a link tode-installation note.

     

    Install Spatialby executing the steps shown below. Note you need to run this as a SYSDBA user!

    --使用sysdaba 用户执行如下步骤:

       SQL> connect / as sysdba

       SQL> spool spatial_installation.lst

       SQL> @?/md/admin/mdinst.sql

       SQL> spool off

     

        At the end of the installation some verification steps are automaticallyexecuted!

    You can also manually run the theverification steps later on.

     

    It is stronglyrecommended that the MDSYS user account remains locked. The MDSYS user is createdwith administrator privileges; therefore, it is important to protect thisaccount from unauthorized use. 

     

    To lock theMDSYS user, connect as SYS and enter the following command:

       SQL> alter user MDSYS account lock;

     

    2.2.2.3 验证安装

     

    Execute the following steps to verify ifSpatial is installed correctly:

    SQL> connect/ as sysdba 
        SQL> set serveroutput on
        SQL> execute validate_sdo;
        SQL> select comp_id, control,schema, version, status, comp_name from dba_registry where comp_id='SDO';
        SQL> select object_name,object_type, status from dba_objects where owner='MDSYS' and status <>'VALID' order by object_name;

    --示例:

    SQL> execute validate_sdo;

    PL/SQL procedure successfully completed.

     

    SQL> select comp_id, control, schema,version, status, comp_name from dba_registry where comp_id='SDO';

     

    COMP_ID     CONTROL      SCHEMA       VERSION         STATUS          COMP_NAME

    ------------ ------------ --------------------------- --------------- ---------

    SDO         SYS          MDSYS        11.2.0.3.0      VALID           Spatial

     

     

     

     

    -------------------------------------------------------------------------------------------------------

    版权所有,文章允许转载,但必须以链接方式注明源地址,否则追究法律责任!

    QQ:492913789

    Email:ahdba@qq.com

    Blog:  http://www.cndba.cn/dave

    Weibo: http://weibo.com/tianlesoftware

    Twitter: http://twitter.com/tianlesoftware

    Facebook: http://www.facebook.com/tianlesoftware

    Linkedin: http://cn.linkedin.com/in/tianlesoftware

     

     

    -------加群需要在备注说明Oracle表空间和数据文件的关系,否则拒绝申请----

    DBA1 群:62697716(满);   DBA2 群:62697977(满)  DBA3 群:62697850(满)  

    DBA 超级群:63306533(满);  DBA4 群:83829929   DBA5群: 142216823

    DBA6 群:158654907    DBA7 群:172855474   DBA总群:104207940

    展开全文
  • Oracle XDK 组件 说明

    千次阅读 2012-03-09 15:59:20
    一.Oracle XDK 组件 说明 在说明之前,我们先用如下SQL查看一下DB中的组件:SQL> col comp_id for a15SQL> col version for a15SQL> col comp_name for a30SQL> select comp_id,comp_name,versionfrom dba_registry...

     

    一.Oracle XDK 组件 说明

     

    在说明之前,我们先用如下SQL查看一下DB中的组件:

    SQL> col comp_id for a15

    SQL> col version for a15

    SQL> col comp_name for a30

    SQL> select comp_id,comp_name,versionfrom dba_registry;

     

    COMP_ID         COMP_NAME                      VERSION

    --------------------------------------------- ---------------

    XDB             Oracle XML Database            11.2.0.3.0

    AMD             OLAP Catalog                   11.2.0.3.0

    EM              Oracle Enterprise Manager      11.2.0.3.0

    SDO             Spatial                        11.2.0.3.0

    ORDIM           Oracle Multimedia              11.2.0.3.0

    CONTEXT         Oracle Text                    11.2.0.3.0

    ODM             Oracle Data Mining             11.2.0.3.0

    EXF             Oracle Expression Filter       11.2.0.3.0

    RUL             Oracle Rules Manager           11.2.0.3.0

    OWM             Oracle Workspace Manager       11.2.0.3.0

    CATALOG         Oracle Database Catalog Views  11.2.0.3.0

     

    COMP_ID         COMP_NAME                      VERSION

    --------------------------------------------- ---------------

    CATPROC         Oracle Database Packages and T11.2.0.3.0

                    ypes

     

    JAVAVM          JServer JAVA Virtual Machine   11.2.0.3.0

    XML             Oracle XDK                     11.2.0.3.0

    CATJAVA         Oracle Database Java Packages  11.2.0.3.0

    XOQ             Oracle OLAP API                11.2.0.3.0

    APS             OLAP Analytic Workspace        11.2.0.3.0

     

    17 rows selected.

     

    MOS 说明:

    Oracle 8i/9i/10g/11g 组件(Components) 说明

    http://www.cndba.cn/Dave/article/1445

     

    Oracle OracleXML Developer's Kit (XDK) is a versatile set of components that enables you tobuild and deploy C, C++, and Java software programs that process XML. You canassemble these components into an XML application that serves your businessneeds. 

    --Oracle XDK 组件是一个多功能集合的组件,其可以构建和部署C,C++,Java 程序来处理XML。

     

    Oracle XDKprovides the foundation for the Oracle XML solution. The XDK supports OracleXML DB, which is a set of technologies used for storage and processing of XMLin the database. You can use the XDK in conjunction with Oracle XML DB to buildapplications that run in Oracle Database. You can also use the XDKindependently of XML DB. 

    --Oracle XDK 为XML的解决方案提供了基础。 XDK 支持XML DB,XDB是一个技术的集合,其可以用来在DB中存储和处理XML。 我们可以使用XDK 和XDB来构建应用在DB中运行,也可以单独使用XDK。

     

    OracleXDB 组件 重建 说明

    http://www.cndba.cn/Dave/article/1324

     

    The Oracle XDKis fully supported by Oracle Corporation and comes with a commercialredistribution license. The standard installation of Oracle Database includesthe XDK. 

     

    注意:

    (1)Customersusing Oracle XDK with PL/SQL and migrating from Oracle Database Release 8.1 or9.2 are strongly encouraged to use AL32UTF8 as the database character set.Otherwise, issues can arise during PL/SQL processing of XML data that containsescaped entities. 

    --在Oracle 8.1和9.2中强烈建议AL32UTF8字符集。

     

    (2)9206 XDKshould be installed in 9204 database, 9207 XDK should be installed in 9205database and 9208 XDK should be installed in 9206 server. That is why in9.2.0.8 installation you will see XDK version 9.2.0.10

     

    XDK 用户:

    SYS: In 9.2 XDK should be installed in SYSschema, as 9.2.0.* patchsets upgrade XDK installed in SYS schemaonly.  

           --从Oracle 9.2 开始,XDK 只安装到SYS 用户。

     

    官网的其他文档:

     XML DB Developer's Guide,10g Release 2 (10.2) 
    Introduction to Oracle XMLDeveloper's Kit (11gR2)

     

     

    二. XDK 卸载

    MOS:

    Note.317176.1 Howto De-install corrupted pl/sql XDK in 9.2 and Install the right version 

    Note.171658.1 HowTo Install and Uninstall the XML Developers Toolkit 

     

    1)     Let's check which user owns theXDK. To find out execute this query as SYS

    --检查XDK 用户:

    SQL> select owner,dbms_java.longname(object_name), object_type, status from all_objects where dbms_java.longname(object_name)like  ('%XMLParser%') and object_type like '%JAVA%';

     

    Note:- If the packagesshow up as INVALID then XDK is corrupt and you need to follow  re-installsteps

    --如果这里包显示无效,那么XDK 就corrupt,需要重建XDK。

     

    2) For each user that owns XDK executebelow function to find out the version

    --每个XDK用户执行如下函数,来确认版本信息:

    SQL> CREATE OR REPLACE FUNCTIONXMLVersion RETURN VARCHAR2
      IS LANGUAGE JAVA NAME  'oracle.xml.parser.v2.XMLParser.getReleaseVersion()returns java.lang.String';

     /

    SQL> select xmlversion from dual;


    3) 9206 XDK should be installed in 9204 database, 9207 XDK should be installedin 9205 database and 9208 XDK should be installed in 9206 server.

    IF the XDK isinstalled in only SYS schema and you have right XDK version then no need tocontinue further ....

     

    4) In 9.2, the XDK should be installed inthe SYS schema, as 9.2.0.* patchsets upgrade the XDK installed in the SYSschema only.

           --在Oracle 9.2 中,XDK 需要安装在SYS用户下。

     

    5) If you have XDK installed in any schemaother than SYS, then follow below steps to successfully install the rightversion of XDK in SYS schema

           --如果XDK 已经安装到了其他目录,那么使用如下步骤可以转移到SYS 用户。

     

    a) If the user owning XDK just has XDKcomponents and no custom code then drop the user owning XDK using cascadeoption

     

    b) Now, as SYS, check if any other schemahas XDK installed

    SQL> select owner,dbms_java.longname(object_name), object_type, status from all_objects where dbms_java.longname(object_name)like  ('%XMLParser%') and object_type like '%JAVA%';

     

    c) If the above query show that SYS hasalready the right version of XDK installed then stop here ..... 

    otherwise continue

    For both Unix and Windows as SYS executebelow command

       SQL>[ORACLE_HOME]/rdbms/admin/initxml.sql

    d) Installation complete and no need tocontinue further ..

     

    6) IF current XDK in SYS is corrupted oryou have wrong version of XDK in SYS schema then follow below steps tode-install and install

           --如果XDK 已经正确安装到了SYS用户,但是XDK 版本错误,那么需要卸载XDK 然后重新安装。

     

    I) To de-install XDKinstalled from Technet you need to have right version of jar files I.e say you have 9.2.0.6 XDK installed in a 9.2.0.6 database (RightXDK should be 9.2.0.8) then you need to have 9.2.0.6 XDK files to drop thecurrent XDK. With below steps I will assume you have 9.2.0.6 XDK in 9.2.0.6database and we are going to de-install 9.2.0.6 XDK and install 9.2.0.8 XDK

      

    a) Download 9.2.0.6 XDK from Technet

    http://www.oracle.com/technology/tech/xml/xdk/software/prod/xdk_plsql.html

    Install it in some directory on thedatabase box.

     

    b) Cd to XDK_HOME/xdk/admin directory

     

    c) Log in as SYS and execute below commands

    SQL> @xmldrop.sql
     
    SQL> drop package dbms_xmlquery;
    SQL> drop package dbms_xmlsave;
    SQL> drop package xmlgen;
    SQL> drop public synonym dbms_xmlquery;
    SQL> drop public synonym dbms_xmlsave;
    SQL> drop public synonym xmlgen;
    SQL> exit


    d) Cd to XDK_HOME/lib and issue a dropjava command for each of the followingjava archives
      
       ./xdk/lib/xschema.jar
       ./xdk/lib/xsu12.jar 
       ./xdk/lib/classgen.jar
       ./xdk/lib/xmlparserv2.jar
       ./xdk/lib/xmlplsql.jar

       eg.  dropjava -v -uuser/password xdk/lib/xschema.jar

     

    e) Deinstall is complete. Now you can loginand check if any version of XDK is installed

     

    f) To install XDK as SYS executebelow command

       SQL> [ORACLE_HOME]/rdbms/admin/initxml.sql


    II) To de-install corrupt 9.2 XDK that is installedfrom $OH follow below steps

    a) Cd to $OH

    b) Log in as SYS and execute below commands

    SQL> @rdbms/admin/rmxml.sql
     
    SQL> drop package dbms_xmlquery;
    SQL> drop package dbms_xmlsave;
    SQL> drop package xmlgen;
    SQL> drop public synonym dbms_xmlquery;
    SQL> drop public synonym dbms_xmlsave;
    SQL> drop public synonym xmlgen;
    SQL> exit


    d) Cd to $OH and issue a dropjava command for each of the following javaarchives
      
       ./lib/xschema.jar
       ./lib/xsu12.jar 
       ./lib/classgen.jar
       ./lib/xmlparserv2.jar
       ./rdbms/jlib/xdb.jar
       ./rdbms/jlib/servlet.jar
       ./lib/xmlplsql.jar

       eg.  dropjava -v -uuser/password ./lib/xschema.jar

     

    e) Deinstall is complete. Now you can loginand check if any version of XDK is installed

     

    f) To install XDK as SYS executebelow command

       SQL>[ORACLE_HOME]/rdbms/admin/initxml.sql



    注意事项:

    In 9iR2, the xdkfor pl/sql written in java has been deprecated and in 10i it is no longersupported

    Starting with9.2 Oracle introduced XDK for pl/sql written in C/C++ which is referred asXDB/XMLTYPE. The packages XMLDOM, XMLPARSER and XSLPROCESSOR have been replacedby the new names as DBMS_XMLDOM, DBMS_XMLPARSER and DBMS_XSLPROCESSOR.

    The new packageshave the same methods and functionality and support the same interfaces using Cinstead of Java.  In 10i there will be synonyms created to the oldpackages to provide backward compatibility.

    In 9.2 you havethe option to either use pl/sql XDK written in C or Java.

    In order toinstall XDB refer to Note 1292089.1

     

     

    三. XDK 组件安装

    Note.435999.1 HowTo Install XDK 10.2.0.x ? 
    Note.277152.1 Howto install XDK 9.2.0.x in an 8.1.7 Database Cleanly 
    Note.453050.1 Howto Verify the XDK Installation
    Installing the XDK (11gR2) 

    There is no needto install XDK Java in 10g database as it comes with XDB schema. In 10g, muchabout XDK has been included in Oracle XML Database (XDB). 

    --从Oracle10g 开始,不需要安装XDK组件,其已经包含在XDB组件中。

     

    So, to install the XDK Java, XDB should beinstalled first . 

    --所以如果要安装XDK,XDB 需要先安装。

     

    关于XDB安装,参考:

    OracleXDB 组件 重建 说明

    http://blog.csdn.net/tianlesoftware/article/details/7323139

     

     If theJServer is installed correctly but the XDK component is not, for example it isinvalid, (which can be shown by the following SQL statement):

    --如果JServer 安装正确,但是XDK 无效,可以通过如下SQL 查询:

    COLUMN comp_name format a30
    COLUMN version format a20
    COLUMN status format a20

    select comp_name,version,status from dba_registry where comp_name='Oracle XDK';


    注:这里的Jserver 是JVM组件的一个子集。

     

    Then execute the following scripts tore-install the XDK component.

    --可以执行如下脚本重建XDK 组件:

    Connected as SYSDBA.

    $ORACLE_HOME/xdk/admin/rmxml.sql
    $ORACLE_HOME/xdk/admin/initxml.sql

     

     

    But afterrunning initxml.sql, if following error is encountered , then theJavaVM  is not installed correctly :

    --如果执行initxml.sql,遇到如下错误,可能JavaVM组件没有正确安装。

    BEGIN dbms_java.loadjava('-v -r -grantPUBLIC -s rdbms/jlib/servlet.jar'); END; 


    ERROR at line 1: 
    ORA-29532: Java call terminated by uncaught Java exception: 
    java.lang.NullPointerException 
    ORA-06512: at "SYS.DBMS_JAVA", line 222 
    ORA-06512: at line 1 


    BEGIN dbms_java.loadjava('-v -r -install -grant PUBLIC -s lib/xmlparserv2.jar 
    rdbms/jlib/xdb.jar'); END; 


    ERROR at line 1: 
    ORA-29532: Java call terminated by uncaught Java exception: 
    java.lang.NullPointerException 
    ORA-06512: at "SYS.DBMS_JAVA", line 222 
    ORA-06512: at line 1 


    BEGIN dbms_java.loadjava('-v -r -grant PUBLIC -s lib/xsu12.jar'); END; 


    ERROR at line 1: 
    ORA-29532: Java call terminated by uncaught Java exception: 
    java.lang.NullPointerException 
    ORA-06512: at "SYS.DBMS_JAVA", line 222 
    ORA-06512: at line 1 

     

    重装JavaVM组件即可,具体参考:

    OracleJAVAVM 组件Reload 说明

    http://www.cndba.cn/Dave/article/1328

     

     

    四.验证XDK 安装

     

    1. Verify there are no invalid Java classesthat start with name "oracle/xml"  by querying the ALL_OBJECTSview. 
    SQL> Select substr(dbms_java.longname(object_name),1, 30) as class, statusfrom all_objects where object_type = 'JAVA CLASS' and status = 'INVALID'; 

    2. Verify installation of the Oracle XML Parser for JAVA (i.e xmlparserv2.jar) 
    SQL> select substr(dbms_java.longname(object_name),1, 30) as class, statusfrom all_objects where object_type = 'JAVA CLASS' and object_name =dbms_java.shortname('oracle/xml/parser/v2/DOMParser'); 



    You should see the following result: 

    CLASS Status 
    -------------------------------- --------- 
    oracle/xml/parser/v2/DOMParser Valid 



    3. Verify the PL/SQL wrapper packages are created for the Oracle XML Parser 
    for PL/SQL 

    DESC XMLPARSER; 
    or 
    DESC XMLDOM; 



    4. Verify the PL/SQL wrapper packages are created for the Oracle XML SQLUtility 

    DESC DBMS_XMLQUERY; 
    or 
    DESC DBMS_XMLSAVE; 

     

     

    XML 与XDK 的常见问题参考:

    Note 250288.1 XDK For PL/SQL API Has Been Deprecated from 9.2 Database
    Note.103871.1 XML Parser for PL/SQL FAQs 
    Note.103872.1 XML Parser for Java Version 2 - Frequently Asked Questions 

     

     

     

    -------------------------------------------------------------------------------------------------------

    版权所有,文章允许转载,但必须以链接方式注明源地址,否则追究法律责任!

    QQ:492913789

    Email:ahdba@qq.com

    Blog:  http://www.cndba.cn/dave

    Weibo: http://weibo.com/tianlesoftware

    Twitter: http://twitter.com/tianlesoftware

    Facebook: http://www.facebook.com/tianlesoftware

    Linkedin: http://cn.linkedin.com/in/tianlesoftware

     

    -------加群需要在备注说明Oracle表空间和数据文件的关系,否则拒绝申请----

    DBA1 群:62697716(满);   DBA2 群:62697977(满)  DBA3 群:62697850(满)  

    DBA 超级群:63306533(满);  DBA4 群:83829929   DBA5群: 142216823

    DBA6 群:158654907    DBA7 群:172855474   DBA总群:104207940

    展开全文
  • COM组件

    千次阅读 2013-09-14 17:33:27
    COM组件 COM component(COM组件)是微软公司为了计算机工业的软件生产更加符合人类的行为方式开发的一种新的软件开发技术。在COM构架下,人们可以开发出各种各样的功能专一的组件,然后将它们按照需要组合...
  • Oracle Enterprise Manager 组件 说明

    千次阅读 2012-03-10 15:45:30
     Enterprise Manager 组件说明 在说明之前,我们先用如下SQL 查看一下DB中的组件:SQL> col comp_id for a15SQL> col version for a15SQL> col comp_name for a30SQL> select comp_id,comp_name,versionfrom dba_...
  • Oracle Data Mining 组件 说明

    千次阅读 2012-03-09 14:51:04
    一.DataMining 组件 说明 在说明之前,我们先用如下SQL查看一下DB中的组件:SQL> col comp_id for a15SQL> col version for a15SQL> col comp_name for a30SQL> select comp_id,comp_name,versionfrom dba_registry...
  • Oracle XDB 组件 重建 说明

    千次阅读 2012-08-05 15:46:01
     XDB 组件说明 1.1 官网说明: XDB 全称XML DB,官网的说明如下: http://docs.oracle.com/cd/E11882_01/appdev.112/e23094/xdb01int.htm   Overviewof Oracle XML DB OracleXML DB Architecture Oracle...
  • 关于COM组件

    千次阅读 2016-04-11 17:44:22
    FAQ1:什么是COM组件?〖第一章〗 Answer: COM组件是以WIN32动态链接库(DLL)或可执行文件(EXE)形式发布的可执行代码组成。 COM组件是遵循COM规范编写的 COM组件是一些小的二进制可执行文件 COM组件可以给...
  • c#注册COM组件

    千次阅读 2018-08-13 18:10:37
    以下以一个实例说明如何通过C#创建、注册、注销COM组件。 创建COM组件: 首先新建项目,选择类库,解决方案名称为COMLib,编写一个类,同时需要为该类创建接口。注意类和方法必须为Public,并且接口和类都需要COM...
  • COM组件调试

    千次阅读 2018-03-26 15:10:42
    COM技术虽然已经不被Microsoft推荐,我还是简单记录一下怎样调试COM组件。 跟调试普通的dll差不多,有一点区别。 1. 创建COM组件 现在利用VS去创建COM组件是很容易的,可以利用C++/VC++ 或者C#,淡然C#去编写COM...
  • Mail,ras,sms组件使用说明。C++编写的COM组件
  • Oracle OLAP 组件 重建 说明

    万次阅读 2012-03-05 16:14:03
    Oracle OLAP 组件 说明 有关Oracle 的所有组件说明,参考:Oracle8i/9i/10g/11g 组件(Components) 说明http://blog.csdn.net/tianlesoftware/article/details/5937382 联机分析处理OLAP(On-Line Analytical...
  • HslCommunication组件库使用说明

    千次阅读 2017-12-14 16:12:00
    HslCommunication组件库使用说明 一个由个人开发的组件库,携带了一些众多的功能,包含了数据网络通信,文件上传下载,日志组件,PLC访问类,还有一些其他的基础类库。 NuGet地址: ...
  •  使用ATL开发COM组件之前,要对几个重要的类进行说明:  CComModule  这是ATL的中心模块类,它的作用有点像MFC中的CWinApp,但没有后者那么庞大。它和它导出的类主要负责处理引用技术、在本地服务器内的类厂...
  • jacob调用com组件

    千次阅读 2016-12-11 22:04:29
    com组件可以存在exe,或者dll中,而且对vb,vc,delphi等语言提供了统一的调用,而dll只能存在于dll文件中,而且不同语言调用方式不一样,com组件开发难度相对于dll较大,多用于大型项目中。 java主要使用jacob来...
  • Oracle JAVAVM 组件 Reload 说明

    万次阅读 2012-03-08 20:51:40
    一.JAVAVM 组件 说明 有关Oracle 所有组件的概述,参考:Oracle 8i/9i/10g/11g 组件(Components) 说明http://blog.csdn.net/tianlesoftware/article/details/5937382 现在我们查看组件的信息:SQL> col comp_id ...
  • 牛X的COM组件安装

    2012-11-30 19:47:42
    牛X的COM组件安装[只适用与ASP,VB.NET开发语言版本] 此文档以注册iMsgServer2000.dll为例说明,其它组件的注册相同
  • COM组件的编写与注册

    千次阅读 2018-12-12 16:47:01
    前言 ...以上是维基百科对COM组件的定义,简单来说,C++编写的COM组件可以在C#、Delphi语言中使用,COM组件可以实现跨语言的操作,在COM中也分进程间和进程外通信,COM/DCOM 组件可以在DLL 或EXE 文...
  • 一.Rules Manager 和 Expression Filter 组件说明 在说明之前,我们先用如下SQL查看一下DB中的组件:SQL> col comp_id for a15SQL> col version for a15SQL> col comp_name for a30SQL> select comp_id,comp_name,...
  • 作者:HH 时间:2019-01-08 参考文献: 【1】... 【2】https://www.cnblogs.com/DeeLMind/p/7809115.html ============================================================...
  • COM组件 教程&源代码

    2010-08-04 16:02:00
    适合COM组件初级学者,有很详细的文字图片说明,并附有实例源代码!~
  • 什么是组件? 一个组件同一个微型应用程序类似,即都是已经编译、链接好并可以使用的了,应用程序就是由多个这样的组件打包而得到的。各定制的组件可以在运行时同其他组件连接起来以构成某个...2.COM组件可以以二进制
  • COM组件简介

    千次阅读 2014-03-11 13:31:40
    面向对象的思想难以适应这种分布式软件模型,于是组件化程序设计思想得到了迅速的发展。 按照组件化的程序设计的思想,复杂的应用程序被设计成一些小的,功能单一的组件模块,这些组件模块可以运行在同一台机器上,...
  • 关于C#开发OCX组件说明

    千次阅读 2016-10-18 17:32:33
    OCX是指用C++、C#或者VB开发的COM组件,对外开放的接口可提供和html进行调用,解决html调用本地电脑资源或者第三方集成的问题。应用场景包括银行、视频播放(用flash也能解决相关问题)等。   2、 OCX、COM的...
  • cover-view、cover-image 这两类覆盖组件用于显示在一些特殊组件上方(map、video、canvas、camera、live-player、live-pusher)。 这类组件一般被放置在要覆盖组件内,比如: <video id="myVideo" src=...

空空如也

空空如也

1 2 3 4 5 ... 20
收藏数 404,176
精华内容 161,670
关键字:

com组件说明