RE: July PSU Issue

From: Scott Canaan <srcdco_at_rit.edu>
Date: Tue, 10 Aug 2021 18:29:11 +0000
Message-ID: <5d6062bcb0014fcb913008df6a27df1c_at_ex04test91a.ad.rit.edu>

Actually in the case of the 2 databases I’ve tried, they go down every night for a cold backup, so it has been restarted more than once.

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: Sayan Malakshinov <xt.and.r_at_gmail.com> Sent: Tuesday, August 10, 2021 2:04 PM
To: Scott Canaan <srcdco_at_rit.edu>
Cc: mark.powell2_at_dxc.com; ORACLE-L <oracle-l_at_freelists.org> Subject: Re: July PSU Issue

Sometimes this error just means that some memory structure is broken, so I would try to restart database or even server. Best regards,
Sayan Malakshinov
Oracle performance tuning expert
Oracle Database Developer Choice Award winner Oracle ACE Associate
http://orasql.org

вт, 10 авг. 2021 г., 21:00 Scott Canaan <srcdco_at_rit.edu<mailto:srcdco_at_rit.edu>>: The password does not contain any special characters other than those allowed, so quotes are not needed. I can change other users to the same password, just not sys.

This is EE, not RAC, and using a password file.

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: oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org> <oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org>> On Behalf Of Powell, Mark Sent: Tuesday, August 10, 2021 1:58 PM
To: 'oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>' <oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>> Subject: Re: July PSU Issue

Does the password being attempted contain any special characters? If yes, try enclosing the password in double quotes and see if the same error occurs or not?

Is the environment Standard Ed or EE? RAC or non-RAC? Password file in use or not?

Mark Powell
Database Administration
(313) 592-5148

From: oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org> <oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org>> on behalf of Scott Canaan <srcdco_at_rit.edu<mailto:srcdco_at_rit.edu>> Sent: Tuesday, August 10, 2021 1:35 PM
To: 'oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>' <oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>> Subject: July PSU Issue

We’ve installed the July PSU and have been testing and found the following issue:

When attempting to change the sys password, it generates an ORA-07445:

SQL> alter user sys identified by xxxxxxxxxxxxxxxxx;

alter user sys identified by xxxxxxxxxxxxxxxxxx

ERROR at line 1:

ORA-03113: end-of-file on communication channel

Process ID: 15559

Session ID: 263 Serial number: 7056

In the alert log, I see:

ORA-07445: exception encountered: core dump [__intel_ssse3_rep_memcpy()+9660] [SIGSEGV] [ADDR:0x1C] [PC:0x6F3861C] [Address not mapped to object] []

I am trying to create an SR, but it keeps returning an error 504, so I can’t get that done, either.

Has anyone run into this? Is there a fix or workaround? We have production patching scheduled for Saturday morning, so this is urgent.

This is 19c (19.12.0.0) on Red Hat 7.

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

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

Received on Tue Aug 10 2021 - 20:29:11 CEST

This message: [ Message body ]
Next message: Powell, Mark: "Re: July PSU Issue"
Previous message: Sayan Malakshinov: "Re: July PSU Issue"
In reply to: Sayan Malakshinov: "Re: July PSU Issue"
Next in thread: Powell, Mark: "Re: July PSU Issue"
Reply: Powell, Mark: "Re: July PSU Issue"
Reply: Leng Burgess: "Re: July PSU Issue"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message