One Star

Connexion to oracle 12

Hello.

 

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.

  • Data Integration
2 REPLIES
Nine Stars TRF
Nine Stars

Re: Connexion to oracle 12

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?


TRF
Moderator

Re: Connexion to oracle 12

Hi,

Have you tried with 'SID' and 'Service name' connection method? Are you sure that your Oracle machine allow remote connection ? multiple simultaneous connections ?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.