Environment
NetIQ Identity Manager Driver - JDBC
Situation
In the JDBC driver documentation it is described how to change the driver parameters by modifying the descriptor files for the specific driver.
See table 5-4, page 47 in https://www.netiq.com/documentation/idm45drivers/pdfdoc/jdbc/jdbc.pdf
But there is no information on how to make the driver connect to for Oracle as 'sysdba'
Resolution
To make this work do the following:
1) modify as per documentation open the _oracle_jdbc.xml (contained in JDBCConfig.jar => com/novell/nds/dirxml/driver/jdbc/db/descriptor/driver/_oracle_jdbc.xml )
2) comment the connection-parameters, and make the following changes:
from:
<connection-properties>user={$username}; password={$password}; oracle.jdbc.defaultNChar=true</connection-properties>
to:
<connection-properties>user={$username}; password={$password}; internal_logon=sysdba; oracle.jdbc.defaultNChar=true</connection-properties>
3) update the JDBCConfig.jar as per documentation and deploy it to the lib or classes directory on the IDM Engine server.
1) modify as per documentation open the _oracle_jdbc.xml (contained in JDBCConfig.jar => com/novell/nds/dirxml/driver/jdbc/db/descriptor/driver/_oracle_jdbc.xml )
2) comment the connection-parameters, and make the following changes:
from:
<connection-properties>user={$username}; password={$password}; oracle.jdbc.defaultNChar=true</connection-properties>
to:
<connection-properties>user={$username}; password={$password}; internal_logon=sysdba; oracle.jdbc.defaultNChar=true</connection-properties>
3) update the JDBCConfig.jar as per documentation and deploy it to the lib or classes directory on the IDM Engine server.