ORA-01882: timezone region not found

3212398 · April 2017

We have created a new instance of the DAC and we see this error when trying to run an ETL :-

FAILED TO CREATE CONNECTION POOL DataWarehouse Process failed during creation of connection pool DataWarehouse.

ORA-00604: error occurred at recursive SQL level 1

I cannot find where this might be configured, can you help us?

Our DBAs feel this is a client side setting

Thanks

Venkata Yaswanth Ramisetty · April 2017

Hi,

Can you check once on your server whether timezone is set or not.

Regards,

Yaswanth

3212398 · April 2017

We have resolved this issue by setting the TZ Env Var … please close this SR

Thanks for your help !

Venkata Yaswanth Ramisetty · April 2017

If you find my comment helpful, mark it as correct answer and close the thread.

Thanks,

Yaswanth

Oracle Business Intelligence Applications