In order to install ODI schemas while using Repository Creation Utility (RCU) , despite entering all connection parameters of database true , "Invalid service name" error occured. From SQLDeveloper using same database connection parameters did not give any error like "Invalid Service Name".
Firstly i have thought it was caused from domain name entry in service name.With and without domain name issue not changed. Also checked tnsnames.ora and listener.ora. But nothing found.
Finally I have examined log file of listener in order to detect any error which points "Invalid service name" . In listener.log file there was an entry like this,
18-AUG-2015 09:16:34 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=XXX))(service_name=TESTDB.LOCALDOMA0N.LOCAL)(server=dedicated)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.1.10.10)(PORT=55852)) * establish * TESTDB.LOCALDOMA0N.LOCAL * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
Service name which is TESTDB.LOCALDOMA0N.LOCAL was not the service name that I entered and "i" character was changed with "0" character.My entry was "testdb.localdomain.local".
With upper case of service name RCU executed as well.
