Unable to connect to Oracle using SSMA for Oracle

0

I'm trying use SSMA for Oracle, but I can't get the thing going. I've double checked the server name, server port, Oracle SID, password... everything. No matter the type of entry screen I use, I can't get it to connect to the on-premise Oracle instance.

I'm pretty sure the login information is all correct, and I should have a working connector to Oracle since I connect to it from TOAD on a daily basis. Perhaps the version of Oracle is too outdated? What are the troubleshooting steps I should take?

Log in screen:
      

Error 1:

Unable to find specified provider.
Compatible Oracle Data Access Connectivity libraries were not found on the machine.  You can install them from Oracle product media or download it from Oracle web site.

Error 2:

Connection to Oracle failed.
ORA-01017: invalid username/password; logon denied

Error 3:

Connection to Oracle failed.
Network Naming: No LDAP server detected or configured

Hewitt

Posted 2019-05-10T18:00:41.223

Reputation: 1

No answers