From the past 1 week I'm struggling to install UIM 8.5.1 with Oracle 12c on Redhat 7.x.
I'm able to connect with the same user credentials from SQLDeveloper to the Oracle PDB.
Appreciate any help!
so the ORA error is being returned by the oracle client.
Have you checked with your DBA?
I found this like with some suggestion on changes to the database
oracle - ORA-01017 Invalid Username/Password when connecting to 11g database from 9i client - Stack Overflow
things to check
make sure on the UIM server you have the oracle THIN client only.
make sure the client version matches the bit level of the OS.
test with a password that does not have any special characters.
Hope this helps
In addition to Gene's comments, please try this query while connected in Oracle SQL Developer to the pdb database
select * from all_users where username LIKE 'CA_UIM';
I would be interested to see your Oracle server tnsnames.ora file also.
Also, in your screenshot, can you show the other fields please (the popup is blocking)?
Here are the Connection details and the snapshots.
Thanks in advance!
UIM DB Configuration:
SQL Developer Connection details & User query:
Listener Service Status:
The password is just "oracle123" for SYS & CA_UIM users.
I'm using the latest Oracle Client lib ojdbc8.jar for Oracle 12.2 Server.
I think you need to open a support case to look into this in more detail
We are not using Software Version of full Oracle client.
UIM is using series of libraries in Oracle Instant Client.
This is why UIM ask you the location of Oracle Instant client.
Make sure the below items.
1. Please use ZIP version of Oracle Instant Client. There is also RPM version but do not use RPM version.
because we need all libraries in the same location.
2. ldd should return no error.
# cd <Location you extracted Oracle Instant Client># ldd libociei.so
Retrieving data ...