{"id":1485,"date":"2010-01-14T14:56:41","date_gmt":"2010-01-14T18:56:41","guid":{"rendered":"http:\/\/onlineappsdba.com\/index.php\/2010\/01\/14\/odi-oracle-data-quality-trillium-configuration-issues-on-solaris-10-error-creating-loader-connection-pkgoracleadapterso-ldso1-libclntshso101\/"},"modified":"2010-01-14T14:56:41","modified_gmt":"2010-01-14T18:56:41","slug":"odi-oracle-data-quality-trillium-configuration-issues-on-solaris-10-error-creating-loader-connection-pkgoracleadapterso-ldso1-libclntshso101","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2010\/01\/14\/odi-oracle-data-quality-trillium-configuration-issues-on-solaris-10-error-creating-loader-connection-pkgoracleadapterso-ldso1-libclntshso101\/","title":{"rendered":"ODI – Oracle Data Quality (Trillium) configuration issues on Solaris 10 : Error creating Loader Connection pkgOracleAdapter.so ld.so.1 libclntsh.so.10.1"},"content":{"rendered":"

Oracle Data Quality and Profiling is product from Trillium<\/a> and Oracle ship it\u00a0as part of Oracle Data Integrator (ODI) software. More on ODI here<\/a>\u00a0and here<\/a>\u00a0<\/p>\n

ODI – Oracle Data Integrator
\nODP – Oracle Data Profiling
\nODQ – Oracle Data Quality<\/p>\n

Entity creation<\/strong> failed while creating Loader Connection<\/strong> to Data source (Oracle Database) – For more information on Entity<\/strong>, Metabase<\/strong> or Loader Connection<\/strong> in ODQ\/ODP check Chapter 3<\/strong> of Getting Started with Oracle Data Profiling and Oracle Data Quality for Data Integrator\u00a0Guide here<\/a>
\n.<\/p>\n

How to connect to Oracle Database from ODQ\/ODP (define Loader Connection) :
\n1. <\/strong>Install Oracle Database Client<\/strong> on Server where ODQ\/ODP is running (ODQ\/ODP user should at least have read access<\/strong> on tnsnames.ora<\/strong> and library files<\/strong>).
\n2.<\/strong> Define ORACLE_HOME variable in .TSDiscovery<\/strong> file under user owing ODQ\/ODP software.
\n3. <\/strong>Define TNS alias (tnsnames.ora<\/strong>) in Oracle Database Client to connect to remote Oracle Database
\n4. <\/strong>Create a Metabase (or use existing metabase) using Metabase Manager
\n5.<\/strong> Define Load Connection using : Tools<\/strong> -> Add Loader Connection<\/strong><\/p>\n

.
\n\"Oracle<\/a>
\n.<\/p>\n

<\/a><\/p>\n

6.<\/strong> Create Entity<\/strong> and use Loader Connection created above.<\/p>\n

Entity creation<\/strong> failed with error message, on checking logs on ODQ\/ODP server under<\/p>\n

$ORACLE_ODI_INSTALLATION\/ oracledq\/ metabase_data\/ logs\/ mtb_server.log
\n<\/strong>
\n_________________<\/p>\n

2009-12-15 11:50:03 22277 WARNING CONNECT Remote oracle connection failure, couldn’t load file “\/u01\/ oracledq\/ metabase_server\/ metabase\/ lib\/ pkgOracleAdapter\/ pkgOracleAdapter.so”: ld.so.1: server.bin: fatal: libclntsh.so.10.1: open failed: No such file or directory – couldn’t load file “\/u01\/ oracledq\/ metabase_server\/ metabase\/ lib\/ pkgOracleAdapter\/ pkgOracleAdapter.so”: ld.so.1: server.bin: fatal: libclntsh.so.10.1: open failed: No such file or directory
\n<\/font>_________________<\/p>\n

Issue :<\/strong> libclntsh.so.10.1<\/strong>\u00a0exists under $ORACLE_CLIENT\/[lib or lib32] but $ORACLE_HOME variable was not defined under .TSDiscovery<\/strong><\/p>\n

Fix :<\/strong> Stop Oracle Data Quality and Profiling Server , add ORACLE_HOME variable in .TSDiscovery<\/strong> and start ODQ\/ODP server<\/p>\n

.<\/p>\n

What is .TSDiscovery file in ODQ\/ODP component of ODI ?<\/u><\/strong><\/p>\n

.TSDiscovery<\/strong> is hidden file (as represented by dot in front) on Unix\/Linux server under $HOME for user owning ODI (with ODQ\/ODP) or Oracle Data Quality & Profiling product.
\n\u00a0\u00a0\u00a0\u00a0 ODQ\/ODP server uses\u00a0 TSDiscovery<\/strong> file to gather environment information like LD_LIBRARY_PATH<\/strong>, TS_QUALITY<\/strong>, ODI_JAVA_HOME<\/strong> or ORACLE_HOME<\/strong> .<\/p>\n

.<\/p>\n

References<\/u><\/strong><\/p>\n