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 ?