Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODI Data Quality metabase Load connections

672918Mar 2 2009 — edited Mar 19 2009

Hi Guys

I am trying to get started with ODI data quality and profiling. I would like to connect from the ODI metabase manager load connections to the database on my local machine using the following

username: thiza
Password:

url:10.12.12.12:1521:EDW

The problem is ODI metabase manager requirs tns name. I tried to put the following string on the tns but still not working

EDW=(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = tvictor-za)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = EDW)))

Can anyone give step by step on how to connect to oracle database from ODI metabase manager(load connections)

any help will be highyl appreciated.

Thanks
Umapada

I tried to put the following string on the tns but still not working

only "EDW" in place of TNS Name in metabase administrator. But when testing the connection at the time of creating entity, it is saying "Please wait, Validating Connection" but this wait never ends and continues for hour.

Edited by: user10612738 on Mar 2, 2009 10:54 PM
---------------------------------------------------------------------------

Seems following shared library is missing. Dont know how to get it from Oracle?
Has anybody found this problem earlier.

2009-03-03 12:12:15 02837 WARNING CONNECT Remote oracle connection failure, couldn't load file "/ora/ora10g/odi101350/oracledq/metabase_server/metabase/lib/pkgOracleAdapter/pkgOracleAdapter.sl": no such file or directory - couldn't load file "/ora/ora10g/odi101350/oracledq/metabase_server/metabase/lib/pkgOracleAdapter/pkgOracleAdapter.sl": no such file or directory
2009-03-03 12:12:15 02837 WARNING ADAPTER Authentication failed. - couldn't load file "/ora/ora10g/odi101350/oracledq/metabase_server/metabase/lib/pkgOracleAdapter/pkgOracleAdapter.sl": no such file or directory
2009-03-03 12:12:15 02837 INFO CLIENT_DISCONNECT interpffffec50
2009-03-03 12:12:15 02837 INFO METABASE removing session directory ->/ora/ora10g/odi101350/oracledq/metabase_data/tmp/session/3fb551e8-4c99-4be3-860d-5953ef6512fe<-
2009-03-03 12:12:25 27177 INFO CLIENT_DISCONNECT interp0029c060

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 16 2009

Added on Mar 2 2009

#business-intelligence-applications, #data-integrator, #system-management-and-integration

1 comment

1,104 views