Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Connecting to ORACLE database from Informtica

Status
Not open for further replies.

OraBalz

Programmer
Mar 3, 2004
9
IN
I am trying to connect to Oracle database from INFA. The connectstring /TNSName is 'swm1_rs242m'.

I tried tnspinging from the Unix box where the Server resides.
tnsping swm1_rs242m.
It is connecting to.

I have created a Database connection in Server Manager with the conenctstring swm1_rs242m

Now when I run a Session for this it gives me the following error. Anyone who has connected to Oracle database please respond..

READER_1_1_1> CMN_1290 Database driver event...Error occurred loading library [A file or directory in the path name does not exist.]
READER_1_1_1> Tue Apr 27 12:00:26 2004

READER_1_1_1> CMN_1290 Database driver event...Error occurred loading library [libpmora.a]
READER_1_1_1> Tue Apr 27 12:00:26 2004
READER_1_1_1> CMN_1290 Database driver event...Error occurred loading library [A file or directory in the path name does not exist.]
READER_1_1_1> Tue Apr 27 12:00:26 2004
READER_1_1_1> CMN_1290 Database driver event...Error occurred loading library [libpmora.a]
READER_1_1_1> DBG_21438 Reader: Source is [swm1_rs242m], user [swms]
READER_1_1_1> Tue Apr 27 12:00:26 2004
READER_1_1_1> RR_4036 Error connecting to database [Invalid database type or unable to load driver].
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top