SSMA Presenting ORA-01017: invalid username/password; logon denied

Thomas Doughty 0 Reputation points
2023-11-28T11:49:11.5766667+00:00

I am trying to leverage SSMA to migrate a oracle database to SQL or atleast get a migration assessment report.

However every time I attempt to connect to the database I get the following error:

Connection to Oracle failed.

ORA-01017: invalid username/password; logon denied
I have confirmed the Username and password in other systems and I have even created a new user just for SSMA however still the same error, therefore I am confident it is not the username/Password that is the issue.

Log file is below however does not show much more information :

Any help is greatly appreciated

[Error: Gui] [31788/5] [2023-11-28 11:36:50]: Exception: Connection to Oracle failed.
ORA-01017: invalid username/password; logon denied
 site: Microsoft.SSMA.Framework.Generic.DbUtilities.SsmaDbConnection Connect(Microsoft.SSMA.Framework.Oracle.Base.Connection.OracleConnectionParameters, System.Security.SecureString)
 source: Microsoft.SSMA.Framework.Oracle.Base
   at Microsoft.SSMA.Framework.Oracle.Base.Connection.OracleConnectionFactory.Connect(OracleConnectionParameters connectionParameters, SecureString password)
   at Microsoft.SSMA.Framework.Oracle.Collector.OracleObjectCollector.ConnectToOracle(IProjectPreferencesProvider projectPreferences, String xmlConnectionParameters, SecureString password, IDbConnection implicitConnection, IUIProgressBarProvider progressBarProvider)
   at Microsoft.SSMA.Framework.Oracle.Collector.OracleObjectCollector.CollectData(String connectionParameters, SecureString password, XMetabase existingMetabase, ICollectionContext context, IDbConnection implicitConnection, XNode filter)
   at Microsoft.SSMA.Framework.Generic.Collectors.Default.DefaultObjectCollector.CollectData(String connectionParameters, SecureString password, ICollectionContext context)
   at Microsoft.SSMA.Framework.Generic.SSMAWorkspace.MetabaseSsmaWorkspaceItem.Connect(String connectionParameters, SecureString password)
   at Microsoft.SSMA.GUI.Product.OracleToMsSql.LowLevel.AppConnectToSourceOracle.ConnectToSourceStart(Object guiContext)
[Error: Gui] [31788/5] [2023-11-28 11:36:50]: Inner Exception #1: ORA-01017: invalid username/password; logon denied
 site: PR Get(OracleInternal.ConnectionPool.ConnectionString, Boolean, Oracle.ManagedDataAccess.Client.OracleConnection, System.String, Boolean)
 source: Oracle Data Provider for .NET, Managed Driver
 error code: -2147467259
   at OracleInternal.ConnectionPool.PoolManager`3.Get(ConnectionString csWithDiffOrNewPwd, Boolean bGetForApp, OracleConnection connRefForCriteria, String affinityInstanceName, Boolean bForceMatch)
   at OracleInternal.ConnectionPool.OraclePoolManager.Get(ConnectionString csWithNewPassword, Boolean bGetForApp, OracleConnection connRefForCriteria, String affinityInstanceName, Boolean bForceMatch)
   at OracleInternal.ConnectionPool.OracleConnectionDispenser`3.Get(ConnectionString cs, PM conPM, ConnectionString pmCS, SecureString securedPassword, SecureString securedProxyPassword, OracleConnection connRefForCriteria)
   at Oracle.ManagedDataAccess.Client.OracleConnection.Open()
   at Microsoft.SSMA.Framework.Generic.DbUtilities.SsmaDbConnection.Open()
   at Microsoft.SSMA.Framework.Oracle.Base.Connection.OracleConnectionFactory.Connect(OracleConnectionParameters connectionParameters, SecureString password)
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,214 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
507 questions
{count} votes