I want to "migrate" my Oracle database to MongoDB. I am trying to make a Oracle connection using the option in metadatas.
But when I check the connection configuration, I get this error: "The network adapter could not establish the connection"
Screenshot here: http://prntscr.com/fqzakh
I am sure password is good, I can connect with it using SQL plus and SqlDeveloper.
I just don't know how to solve it, nothing on Internet was helpfull (and we are two working on it...)
By the way, I am on a virtual machien (windows 7) with oracle on this machine.
Did you try to change the username "sys as sysdba" to a simple one such as "scott"?
Also, are you sure about the port number and the SID?
Have you tried with 'SID' and 'Service name' connection method? Are you sure that your Oracle machine allow remote connection ? multiple simultaneous connections ?
The first 100 community members completing the Open Studio survey win a $10 gift voucher.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend