0
votes

the error i m gettingenter image description hereMy intention is to have ORACLE 12 + Informatica on my local system. I have installed Oracle and it is working fine. While I am trying to run SERVER INSTALLATION for INFORMATICA, I am having difficulty with configuring the database for domain connection repository. The connection is failing even though I am giving correct oracle credentials which are as below: DB USERID: infadmin JDBC URL:localhost:1521 Service: orcl My questions is: Why is it failing? Do I have to do anything special before trying this connection like installing any special jdbc drivers or something?

Your replies are much awaited.Thanks in advance.

Vaibhav Gautam

1
What error message are you getting? - Samik
CONNECTION FAILED. CORRECT THE CONNECTION INFORMATION AND TEST AGAIN. - Vaibhav Gautam Sharma
Hi I'm having the same error when installing informatica. Were you able to solve it back then? - Ahaha

1 Answers

0
votes

Check the contents of the tnsnames.ora file located at <Oracle Installation Direcotry>/network/admin. Make sure that the hostname, port no., service name matches exactly.

Also, make sure the oracle service is running.