技术文章 - CS353989
从 Oracle 迁移到 SQL Server 声称 Windchill PDMLink 12 中的“密码无效”
已修改: 22-Nov-2022
适用于
- Windchill PDMLink 12.0 to 12.1
说明
- 尽管在从 Oracle 迁移到 SQL Server 的过程中键入了正确的密码，Windchill 数据库迁移工具仍出现错误
Invalid Password
- DB_Migration.log 读取：
- INFO Oracle_SQLServer_Dynamic_Mig.ui.MainForm.checkORAPassword():360 - Checking Oracle password ... - ERROR Oracle_SQLServer_Dynamic_Mig.DataSource.checkOraConnection():172 - System.Data.OleDb.OleDbException (0x80004005): ORA-28759: failure to open file at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.OleDb.OleDbConnection.Open() at Oracle_SQLServer_Dynamic_Mig.DataSource.checkOraConnection() in n:\SQLMigration\modules\O2S\src_native\Oracle_SQLServer_Dynamic_Mig\database\DataSource.cs:line 172 - ERROR Oracle_SQLServer_Dynamic_Mig.DataSource.checkOraConnection():172 - Connection 'Data Source=(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCPS)(HOST = <hostname>)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = wind)));User ID=<dbuser>;Password=<password>;Provider=OraOLEDB.Oracle.1;Connection Timeout=120;' Failed. - Error: ORA-28759: failure to open file
这是文章 353989 的 PDF 版本，可能已过期。最新版本 CS353989