Unable to connect to DB, Migration Tool for conversion from PC 9.51 to PC 11

Running the PC 11 DB Migration tool it generates an error, DB connection fails with error about TNS Oracle
connection.

Migrating the previous PC 9.51 Oracle database to the new PC 11 Oracle database fails in the connection between the ALM server and the Oracle database and the data can’t be migrated

The DB Migration tool uses the oracle service name to look up in tnsnames.

The tnsnames entry has a domain listed, but the service name look up might be using a different domain, in this case check the sqlnet.ora file and names.default_domain in order to determine which is the current connection domain.

Try adding another tnsname net service name entry using the same domain as that specified in sqlnet.ora default domain.

Leave a Comment