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> 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 <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