What does SQLDeveloper change?
Date: Thu, 19 Apr 2018 18:52:30 -0500
Message-ID: <CAFN=diD8v0QL2nfmCHR60biMaHDF-maB1A4JGMzwhHduGjQfCw_at_mail.gmail.com>
I've got some sort of conflict between SQL Server SSMA conversion tool and SQL Developer and I can't figure out where it is.
I'm in the process of generating assessment reports for the conversion of around 130 databases and on a positive piece of this I've learned enough powershell to script this. Each assessment is taking anywhere from 1/2 hr to 2 hrs so I figured I'd grab the latest version of SQL Developer (18.2). After getting SQL Developer to work I noticed that every SSMA execution failed, giving the error: "NESTED System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.". The problem is I can't figure out what the SQL Developer setup changed as all I did was unzip the download under "C:\Oracle" and then start the executable to validate it was working.
I removed "C:\Oracle\sqldeveloper", along with %AppData\Roaming\sqldeveloper directories but the problem persists. My guess is there's some sort of java-related change that happened or 32-bit vs. 64-bit dll change but I can't figure it out. Anyone know all changes that SQLDeveloper makes?
-- Dave-- http://www.freelists.org/webpage/oracle-l Received on Fri Apr 20 2018 - 01:52:30 CEST