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@xxxxxxx>:
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@xxxxxxx <srcdco@xxxxxxx>* | 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@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> *On
Behalf Of *Powell, Mark
*Sent:* Tuesday, August 10, 2021 1:58 PM
*To:* 'oracle-l@xxxxxxxxxxxxx' <oracle-l@xxxxxxxxxxxxx>
*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@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on
behalf of Scott Canaan <srcdco@xxxxxxx>
*Sent:* Tuesday, August 10, 2021 1:35 PM
*To:* 'oracle-l@xxxxxxxxxxxxx' <oracle-l@xxxxxxxxxxxxx>
*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@xxxxxxx <srcdco@xxxxxxx>* | 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.
