Table of Contents Previous Next


8 Migration Issues : 8.1 Migration Toolkit Connection Errors

Migration Toolkit uses information from the toolkit.properties file to connect to the source and target databases. Most of the connection errors that occur when using Migration Toolkit are related to the information specified in the toolkit.properties file. Use the following section to identify common connection errors, and learn how to resolve them.
For information about editing the toolkit.properties file, see Section 5, Building the toolkit.properties file.
The user name or password specified in the toolkit.properties file is not valid to use to connect to the Oracle source database.
To resolve this error, edit the toolkit.properties file, specifying the name and password of a valid user with sufficient privileges to perform the migration in the SRC_DB_USER and SRC_DB_PASSWORD properties.
The user name or password specified in the toolkit.properties file is not valid to use to connect to the Postgres database.
To resolve this error, edit the toolkit.properties file, specifying the name and password of a valid user with sufficient privileges to perform the migration in the TARGET_DB_USER and TARGET_DB_PASSWORD properties.
To resolve this error, you can either unlock the user account on the Oracle server or edit the toolkit.properties file, specifying the name and password of a valid user with sufficient privileges to perform the migration in the SRC_DB_USER and SRC_DB_PASSWORD parameters.
The JDBC URL for the source database specified in the toolkit.properties file contains invalid connection properties.
To resolve this error, edit the toolkit.properties file, specifying valid connection information for the source database in the SRC_DB_URL property. For information about forming a JDBC URL for your specific database, see Sections 5.1 through 5.6 of this document.
The JDBC URL for the target database (Advanced Server) specified in the toolkit.properties file contains invalid connection properties.
To resolve this error, edit the toolkit.properties file, specifying valid connection information for the target database in the TARGET_DB_URL property. For information about forming a JDBC URL for Advanced Server, see section 5.1 of this document.

8 Migration Issues : 8.1 Migration Toolkit Connection Errors

Table of Contents Previous Next