1 Reply Latest reply: Sep 23, 2011 6:35 AM by 839293 RSS

    Linux Instant Client SQL*Plus raises OCI-21500 with XML DB

    839293
      I have downloaded and installed (unzipped) Linux versions of following Instant Client packages from http://www.oracle.com/technetwork/topics/linuxsoft-082809.html

      Instant Client Package - Basic Lite: Smaller version of the Basic, with only English error messages and Unicode, ASCII, and Western European character set support
      Instant Client Package - SQL*Plus: Additional libraries and executable for running SQL*Plus with Instant Client
      $ ll /usr/local/oracle-instantclient-11-2/
      total 65M
      -rwxrwxr-x 1 jani jani  22K 2010-09-05 23:35 adrci*
      -rw-rw-r-- 1 jani jani  447 2010-09-05 23:35 BASIC_LITE_README
      -rwxrwxr-x 1 jani jani  38K 2010-09-05 23:35 genezi*
      -r--r--r-- 1 jani jani  342 2010-09-05 23:36 glogin.sql
      -rwxrwxr-x 1 jani jani  42M 2010-09-05 23:35 libclntsh.so.11.1*
      -r-xr-xr-x 1 jani jani 6.7M 2010-09-05 23:35 libnnz11.so*
      -rwxrwxr-x 1 jani jani 1.8M 2010-09-05 23:35 libocci.so.11.1*
      -rwxrwxr-x 1 jani jani 7.3M 2010-09-05 23:35 libociicus.so*
      -r-xr-xr-x 1 jani jani 149K 2010-09-05 23:35 libocijdbc11.so*
      -r-xr-xr-x 1 jani jani 1.5M 2010-09-05 23:36 libsqlplusic.so*
      -r-xr-xr-x 1 jani jani 1.2M 2010-09-05 23:36 libsqlplus.so*
      -r--r--r-- 1 jani jani 2.0M 2010-09-05 23:35 ojdbc5.jar
      -r--r--r-- 1 jani jani 2.1M 2010-09-05 23:35 ojdbc6.jar
      -r-xr-xr-x 1 jani jani 6.8K 2010-09-05 23:36 sqlplus*
      -rw-rw-r-- 1 jani jani  441 2010-09-05 23:36 SQLPLUS_README
      -rwxrwxr-x 1 jani jani 156K 2010-09-05 23:35 uidrvci*
      -rw-rw-r-- 1 jani jani  66K 2010-09-05 23:35 xstreams.jar
      So far I have been able to use SQL*Plus with several remote databases without problems.

      Now with XML DB I have run into the following issue:
      SQL> desc all_xml_schemas;
       Name                            Null?    Type
       ----------------------------------------- -------- ----------------------------
       OWNER                                  VARCHAR2(30)
       SCHEMA_URL                             VARCHAR2(700)
       LOCAL                                  VARCHAR2(3)
       SCHEMA                              SYS.XMLTYPE
       INT_OBJNAME                             VARCHAR2(4000)
       QUAL_SCHEMA_URL                        VARCHAR2(767)
       HIER_TYPE                             VARCHAR2(11)
       BINARY                              VARCHAR2(3)
       SCHEMA_ID                             RAW(16)
       HIDDEN                              VARCHAR2(3)
      
      SQL> column schema_url format a40
      SQL> select owner, schema_url from all_xml_schemas where schema_url = 'JANI';
      
      no rows selected
      
      SQL> select owner, schema_url from all_xml_schemas where owner = 'JANI';
      
      OWNER                      SCHEMA_URL
      ------------------------------ ----------------------------------------
      JANI                      camt.053.001.02.xsd
      JANI                      multipart-schema-1.xsd
      JANI                      multipart-schema-3.xsd
      JANI                      multipart-schema-2.xsd
      JANI                      datetime-issue.xsd
      JANI                      xml-1/example.xsd
      JANI                      datetime-issue-2.xsd
      JANI                      datetime-issue-3.xsd
      JANI                      camt.053.001.02.annotated.xsd
      JANI                      camt.054.001.02.annotated.xsd
      
      10 rows selected.
      
      SQL> select schema from all_xml_schemas where schema_url = 'camt.053.001.02.xsd';
      Errors in file :
      OCI-21500: internal error code, arguments: [unable to load XDB library], [], [], [], [], [], [], []
      P6��_�mP6��_�mP6��_�mTcA��`6���:��H����`6���:��H��H6����`6���:��H����`6���:��H����`6���:��H����`6���:��H��H6����`6���:��H����`6���:��H��H6����`6���:��H����`6���:��H����`6���:��H����`6���:��H����`6���:��H����`6���:��H��H6����`6���:��H����`6���:��H����`6���:��H����`6���:��H����`6���:��H��H6����`6���:��H����`6���:��H��H6����`6���:��H����`6���:��H��H6����`6���:��H����`6���:��H����`6���:��H����`6���:��H����`6���:��H����`6���:��H����`6���:��H����`6���:��H����H��`6���:��H����`6���:��H����`6���:��H��H6����`6���:��H����`6���:��H��H6����`6���:��H��p6��p6��@6��d:��H��X6��|:��H��,6��P:��H��p6��p6��@6��d:��H��,6��ERROR:
      OCI-21500: internal error code, arguments: [unable to load XDB library], [],
      [], [], [], [], [], []
      SQL>
      My collegeaus running on Windows can run the query without problems, so I assume this is related to my Instant Client installation. Where I can find that missing XDB library ?

      The versions are:
      $ sqlplus
      
      SQL*Plus: Release 11.2.0.2.0 Production on Fri Sep 16 09:42:08 2011
      
      Copyright (c) 1982, 2010, Oracle.  All rights reserved.
      
      
      Connected to:
      Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
      
      
      Session altered.
      
      SQL>
        • 1. Re: Linux Instant Client SQL*Plus raises OCI-21500 with XML DB
          839293
          I downloaded Oracle Database 11g Release 2 Client (11.2.0.1.0) for Linux x86 from http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-linuxsoft-085393.html and installed (selected custom install from installer) options:

          SQL*PLUS
          Oracle XML Development Kit

          And got a working SQL*Plus.

          I had to create the following links before the installation succeeded:
          $ sudo ln -s /usr/bin/awk /bin/awk
          $ sudo ln -s /usr/lib/i386-linux-gnu/libpthread_nonshared.a /usr/lib/libpthread_nonshared.a
          $ sudo ln -s /usr/lib/i386-linux-gnu/libc_nonshared.a /usr/lib/libc_nonshared.a
          I'm running on Xubuntu 11.04.

          See also:

          Oracle Client 11gR2 Install on Ubuntu 11.04
          http://dsn0wman.blogspot.com/2011/04/install-oracle-11gr2-client-on-ubuntu.html