Team, I am getting this error in informatica cloud when i run the mapping.Oracle is running properly, informatica connection is working properly still throw this error..
I have attached the screensort.
error--- CMN_1022 Database driver error... CMN_1022 [ [Informatica][ODBC Oracle Wire Protocol driver]Connection refused. Verify Host Name and Port Number.[Informatica][ODBC Oracle Wire Protocol driver][Oracle]ORA-12203: unable to connect to destination Database driver error... Function Name : Connect Database driver error... Function Name : Connect Database Error: Failed to connect to database using user [core] and connection string [Driver=DataDirect CLOSED 8.0 Oracle Wire Protocol for Informatica - BASE;Host=localhost;ServiceName=xe;Port=1521;UID=core;AS=6000000;EBL=0;ENS=1;IACP=4;ETWT=1;WorkArounds
it must be run as my database and informatica connection is working properly.
Please help on this to get it fixed.
Missing TNS entry in tnsnames.ora file. Same happens to SQL connections if host details are missing in ODBC.ini file