Oracle Bulk Copy Exception Execution complete with error: ORA-01017: invalid user name / password; connection refused

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Oracle Bulk Copy error from 64-bit Javelin:

 

Execution complete with error: ORA-01017: invalid user name / password; connection refused

 

Ran the same process in an 32 bytes version and I didn't get any issue.

Environment

Release : 4.8

Component : CA Test Data Manager - Javelin

Cause

Password create for 32-bit will not work for 64-bit.

 

After fixing the password, then getting this error:

 

2020-03-24 21:03:31 - Error executing Oracle Bulk Copy: SCRAMBLE.CASDETEST: The type initializer for 'Oracle.DataAccess.Client.OracleBulkCopy' threw an exception.

Resolution

Created passwords for 64-bit .

 

downloaded ODAC XCOPY version 19.3 from Oracle and applied to resolve second issue.