fdm import data from ebs error, any helps?
Version:
FDM 11.1.2.2;
ODI 11.1.1.6;
Oracle Database 11gR2;
ERPI and FDM was installed on the same machine(MS server 2008 64bit) and 32bit oracle db client as a plus;
Error Message:ORA-12504: TNS: listener was not given the SERVICE_NAME in CONNECT_DATA
Error description:When import data to FDM application, data can import into ERPI database, but error occurred when push data into FDM application database.my ERPI database and FDM application database use the same SID.
tnsnames.ora config
odidev =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.233)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = odidev)