RE: Oracle Timezone Updates

Thanks, that did it.

Scott Canaan ‘88
Sr Database Administrator
Information & Technology Services
Finance & Administration
Rochester Institute of Technology
o: (585) 475-7886 | f: (585) 475-7520
srcdco_at_rit.edu<mailto:srcdco_at_rit.edu> | c: (585) 339-8659

CONFIDENTIALITY NOTE: The information transmitted, including attachments, is intended only for the person(s) or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and destroy any copies of this information.

From: Andy Wattenhofer <watt0012_at_umn.edu> Sent: Friday, October 27, 2023 2:56 PM
To: Scott Canaan <srcdco_at_rit.edu>
Cc: oracle-l_at_freelists.org
Subject: Re: Oracle Timezone Updates

The binary files were installed with the 19.20 RU (35320081), but you still need to update the timezone in the database(s). The procedure for that is in doc id 2940808.1<https://support.oracle.com/epmos/faces/DocContentDisplay?id=2940808.1>.

Andy

On Fri, Oct 27, 2023 at 1:49 PM Scott Canaan <dmarc-noreply_at_freelists.org<mailto:dmarc-noreply_at_freelists.org>> wrote: I am trying to migrate a database from Red Hat 7 to Red Hat 8 both with Oracle 19.20. I’m using impdp over the network. When I invoke impdp, I get the following error:

ORA-39405: Oracle Data Pump does not support importing from a source database with TSTZ version 41 into a target database with TSTZ version 32.

I went to Oracle support to find out how to update the timezone to 41 in the new database. It sent me to patch 35099667. I downloaded the patch and attempted to install it. Opatch told me that the patch was included in patch 35320081, which was installed on July 19. So the timezone is still at 32.

How do I get the timezone upgraded to 41?

Scott Canaan ‘88
Sr Database Administrator
Information & Technology Services
Finance & Administration
Rochester Institute of Technology
o: (585) 475-7886 | f: (585) 475-7520
srcdco_at_rit.edu<mailto:srcdco_at_rit.edu> | c: (585) 339-8659 CONFIDENTIALITY NOTE: The information transmitted, including attachments, is intended only for the person(s) or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and destroy any copies of this information.

--
http://www.freelists.org/webpage/oracle-l