Hello @saspert,
nice question. And I understand the confussion. Let me see if I can help a bit.
I am going to understand pre-requisites for CPM and Oracle are set properly and in the correct order, as mentioned in the SAS documentation. If not, I would really start from there. Success on any SAS installation depends 50% if pre-requisites are properly in place before the SAS installation starts. The other 50% is about the proper configuration and to understand the architecture.
That being said:
For the tester, you will need the appropiate jdbc drivers from Oracle. I personally use Squirrel (another java db client where I can test jdbc) and the connection details. If this does not work for you, you will need to start making this to work, with the right jdbc driver version, together with your DBA, as main responsible of that basic connection.
About the error, I feel like the main issue probably is one of the following:
Used Oracle jdbc driver is not correct.
Oracle database is not correct.
The input provided to the SAS Configuration (to the SAS Deployment Wizard) is incorrect (very often, the provided name of the connection is not correct).
Check your JDBC connection details on server.xml on the SASServer9
The password is not set on your metadata, for the ABM/CPM database connection.
What I would ask you to provide us, and let's see if we can help you:
jdbc driver version (full details), link, etc.
Oracle database version (full details)
the responsefile/s (.properties file/s) used during your install/config. (beware, it might contain passwords)
the server.xml of SASServer9
... View more