We have just had an Oracle 11g database created to house our PowerDesigner repository. I'm using PowerDesigner SP04 PL01 (22.214.171.124 (4535)), i.e. a 64-bit client. I can connect to the database successfully using SQL*Plus, but I can't connect to the Repository.
A colleague can connect successfully to the Repository, so I have mirrored his inputs when creating my Profile Definition. My Data Source is the Connection Profile (my .dcp file is located in what appears to be the correct folder), but when I try to test the connection using the database user id/ password supplied by our DBA, I get an error "Database connection failed! Please verify the database definition, user and password."
I am a bit stumped as to what's causing this, and would appreciate any suggestions. Please let me know if you need further information.