Hi @Thomas Doughty
Depending on your error, you can refer to these threads.
Best regards,
Percy Tang
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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)
Hi @Thomas Doughty
Depending on your error, you can refer to these threads.
Best regards,
Percy Tang