So I am trying to setup a new data source in a Weblogic Server (12c), but I'm getting the same error over and over:
java.sql.SQLException: ORA-01435: user does not exist
This looks pretty straightforward, but as far as I can tell it really isn't.
- I double checked the database properties several time by connecting to the DB with an external tool (Oracle SQLDeveloper).
- I tried connecting with the schema owner and a second user (created for the web application), none of them work in the WLS data source (but both work perfectly in SQLDeveloper).
- The same WLS instance can connect to a different Oracle data source without issues - it's just the new one that is making problems. (Also both the working and the non-working data source have the same managed server as their target.)
If I enter the exact same DB properties (host, port, driver, password) but change the username to a non-existing one I get a different error:
ORA-01017: invalid username/password; logon denied
So this tells me that somehow, the user does exist, but the WLS is still getting the ORA-01435 error.
Does anyone have an idea what the problem could be?
P.S. If I open the 'Monitoring' tab of the problematic data source the table is empty. So far I assumed this was because of the connection errors I'm getting, but I thought I'd mention it here anyway.