Submit a ticketCall us

Welcome to the NEW Success Center. Search all resources (documentation, videos, training, knowledge base articles) or browse resources by product. If you are unable to find what you are looking for, please contact us at customersuccess@solarwinds.com

 

 

 

 

Home > Success Center > Database Performance Analyzer (DPA) > ORA-01882 Timezone region not found error when you try to register an Oracle database

ORA-01882 Timezone region not found error when you try to register an Oracle database

Created by Interspire Import, last modified by MindTouch on Jun 23, 2016

Views: 2,414 Votes: 0 Revisions: 9

Overview

When trying to register an Oracle database, you may sometimes get an error similar to the following:

The timezone on the DB instance that you are trying to register is not compatible with the DPA timezone [Pacific/Tarawa].
Error Message: The timezone name/region on the client is not supported by the database. [error=java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found ]

Environment

All versions of DPA

Resolution

We can ask the Oracle database we are trying to register to use the old JDBC behavior of computing a GMT offset. This will let us register the database instance.

  1. In the Register Instance Wizard, click Advanced Connection Properties
    dpa-9.1-register-instance-wizard-oracle-rds.png 
  2. In the Connection Properties field, enter oracle.jdbc.timezoneAsRegion=false, and then click OK.
  3. Continue registering the database instance.

Cause

There has been a change in the way JDBC handles timezone differences between the client and database. The old behavior was that the JDBC would compute a GMT offset and continue when there was a mismatch between the client timezone and the database timezone. However, the new behavior is to try to use the timezone name/region defined by the client. If the database does not support that particular name/region, we now get an error.

Last modified
19:16, 22 Jun 2016

Tags

Classifications

Public