SYS password has expired and cannot be changed due to ORA-00257: Archiver error
0
votes
2
answers
691
views
**In the past** : When I had once the error
ORA-00257: Archiver error
, I had resolved it using the RMAN command:
rman target sys/1234
delete archivelog all;
**This time** , **when I try to connect to rman target**:
rman target sys/1234
I get the error:
RMAN-00554: initialization of internal recovery manager packagefailed.
RMAN-04005: error from target database.
ORA-28001:the password has expired.
**When I try to connect with sqlplus as sys SYSDBA**, then raises the following error:
ERROR:
ORA-28001: the password has expired
Changing password for SYS
New password:
**When I type the new password**, the error that comes is:
ORA-00257: Archiver error. Connect AS SYSDBA only until resolved.
So the problem is that..
- When I connect through sqlplus as sys SYSDBA, I cannot change the
expired sys password because of archivelog RMAN.
- When I try to fix RMAN error, I cannot connect to RMAN due to the expired sys password.
How can I solve this?
Asked by eathan
(23 rep)
Sep 27, 2023, 11:49 AM
Last activity: Sep 29, 2023, 06:26 AM
Last activity: Sep 29, 2023, 06:26 AM