gtejo1 Absent Member.
Absent Member.
729 views

ORACLE JDBC - Connection error - Oracle 11g

I am having some troubles to achieve the connection between IDM and a data base Oracle 11g. For the first time i succesfully connected the driver with the system, but in there middle of the test it stop working.
Then when i restarted the driver, all the policies were executed but at some point, the log show me this error:

[HTML][12/26/18 16:18:33.682]:Oracle JDBC 11g PT:
<nds dtdversion="2.0" ndsversion="8.x" xmlns:jdbc="urn:dirxml:jdbc">
<source>
<product build="20141001_0706" instance="Oracle JDBC 11g" version="4.0.0.2">DirXML Driver for JDBC</product>
<contact>NetIQ Corporation</contact>
</source>
<input>
<status level="warning" type="app-connection">
<description>Unable to connect. There is a connectivity-related problem.</description>
<jdbc:exception jdbc:class="java.sql.SQLException" jdbc:error-code="604" jdbc:sql-state="60000">
<jdbc:message>ORA-00604: error occurred at recursive SQL level 1
ORA-01882: timezone region not found
</jdbc:message>
</jdbc:exception>
</status>
</input>
</nds>[/HTML]

I trying to figure out if is this and error of the database, idm, or the linux where idm is installed. I tryed deploying a new driver but the error persist.
Could someone give me a hand? Thanks in advance!!

PD: here is the complete log

https://drive.google.com/open?id=1XVzSgVFbfd3piO3sqEykNLYEy0ieibVe
Labels (1)
0 Likes
7 Replies
Knowledge Partner
Knowledge Partner

Re: ORACLE JDBC - Connection error - Oracle 11g

gtejo wrote:

> ORA-00604: error occurred at recursive SQL level 1
> ORA-01882: timezone region not found


Did you try the solution suggested at
https://stackoverflow.com/questions/9156379/ora-01882-timezone-region-not-found
?

--
http://www.is4it.de/en/solution/identity-access-management/

(If you find this post helpful, please click on the star below.)
______________________________________________
https://www.is4it.de/identity-access-management
0 Likes
Knowledge Partner
Knowledge Partner

Re: ORACLE JDBC - Connection error - Oracle 11g

Out of curiosity, which version of IDM are you using?

Which ojdbc*.jar file do you have in use by IDM, presumably under the
/opt/novell/eDirectory/lib/dirxml/classes directory? Does it match the
JRE version? e.g. ojdbc6.jar is made for Java 1.6, etc.

I cannot explain why, in the middle of a test (assuming no other changes),
this would matter, but I suppose it depends on your system. It seems
unlikely Oracle's software would suddenly fail in the middle of a test,
but chances are you are overlooking something as unchanged from your
previously-working scenario (maybe your current tests use time where
earlier ones did not).

--
Good luck.

If you find this post helpful and are logged into the web interface,
show your appreciation and click on the star below.

If you want to send me a private message, please let me know in the
forum as I do not use the web interface often.
0 Likes
Knowledge Partner
Knowledge Partner

Re: ORACLE JDBC - Connection error - Oracle 11g

Another option may be to set user.timezone in the Java parameters, either
in the engine or Remote Loader (RL), wherever you are running the driver
shim (meaning the JAR files, not the driver configuration object necessarily):


-Duser.timezone=GMT



--
Good luck.

If you find this post helpful and are logged into the web interface,
show your appreciation and click on the star below.

If you want to send me a private message, please let me know in the
forum as I do not use the web interface often.
0 Likes
gtejo1 Absent Member.
Absent Member.

Re: ORACLE JDBC - Connection error - Oracle 11g

Im ussing this driver ojdbc6 certified for jdk 7

http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html


which i probe in another environment and works fine. I have no access to the database directly (is own by the client), so i can make any configuration in the endpoint. There is no remote loader in a JDBC driver, the sql setences are executed by engine users. I did tried chaging the ojdbc but the result is the same. I tried chaging this property oracle.jdbc.timezoneAsRegion to "false" in the ojdbc6 jar but the result is the same.
We are stuck here.
0 Likes
Knowledge Partner
Knowledge Partner

Re: ORACLE JDBC - Connection error - Oracle 11g

On 12/26/2018 02:44 PM, gtejo wrote:
>
> Im ussing this driver ojdbc6 certified for jdk 7


Is your IDM instance still using JDK 7? Current versions should all be
using 8.

> which i probe in another environment and works fine. I have no access to
> the database directly (is own by the client), so i can make any
> configuration in the endpoint. There is no remote loader in a JDBC
> driver, the sql setences are executed by engine users. I did tried
> chaging the ojdbc but the result is the same. I tried chaging this


After making a change to the JAR (yuck) did you restart eDirectory to
reload the file? If not, it is as if you did not really do anything.

> property oracle.jdbc.timezoneAsRegion to "false" in the ojdbc6 jar but
> the result is the same.


Did you try setting a Java environment variable for user.timezone as
mentioned before? This, too, would require an eDirectory restart on the
box which is running the driver config and shim.

> We are stuck here.


Another option may be to load up something like DB Visualizer (free
Java-based tool), use the same JAR ojdbc6.jar file, and see if that has
the same issue. If so, you have another tool you can use for testing; if
not, you can try to find out what is different between the two programs in
terms of what they are presumably sending to the server side which
apparently matters to the server.

The Oracle administrators may also be a good resource to ask about this
error, since it sounds like their server is sending it.

--
Good luck.

If you find this post helpful and are logged into the web interface,
show your appreciation and click on the star below.

If you want to send me a private message, please let me know in the
forum as I do not use the web interface often.
0 Likes
gtejo1 Absent Member.
Absent Member.

Re: ORACLE JDBC - Connection error - Oracle 11g

Guys, changing this property oracle.jdbc.timezoneAsRegion to "false" in the ojdbc6 jar and restarting the eDirectory worked. Thanks very much for your help!!
0 Likes
Knowledge Partner
Knowledge Partner

Re: ORACLE JDBC - Connection error - Oracle 11g

Well that's an ugly thing to have to do, but I am glad it worked for you.
Be sure it's something you document well, as it'll be a pain to figure out
when you upgrade something, or migrate something, or anything like that,
and suddenly it all breaks again. Also, don't tell Oracle, or they'll
probably void support of anything using that JAR since you've modified it
directly (just guessing).

--
Good luck.

If you find this post helpful and are logged into the web interface,
show your appreciation and click on the star below.

If you want to send me a private message, please let me know in the
forum as I do not use the web interface often.
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.