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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s