Oracle Database Logon Fails (ORA-01017)

From iDENprotect Knowledge Base
Jump to: navigation, search

Overview

When connecting idenprotect Core Platform to Oracle DBaaS there is an error reported

ORA-01017: invalid username/password; logon denied

Despite the credential in database.properties being correct.

Cause

This appears to be an Oracle bug

https://stackoverflow.com/questions/28945312/ora-01017-when-connecting-through-jdbc-thin-driver


Resolution

Add an additional parameter to java runtime

java -Doracle.jdbc.thinLogonCapability=o3 

This can be added to the idenprotect.conf file under /opt/idenprotect/idenprotect.conf

export "JAVA_OPTS=-Dlog4j.configuration=file:/etc/idenprotect/logging.properties -Doracle.jdbc.thinLogonCapability=o3 -Xms384m -Xmx512m -XX:MaxPermSize=256m"