search cancel

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

book

Article ID: 187595

calendar_today

Updated On:

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.

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.

Environment

Release : 4.8

Component : CA Test Data Manager - Javelin

Resolution

Created passwords for 64-bit .
 
downloaded ODAC XCOPY version 19.3 from Oracle and applied to resolve second issue.