0

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?

eathan
  • 23
  • 6

2 Answers2

3

Your fundamental problem - the Archiver one - is that you've run out of disk space.

The Archiver has a simple job - take an online Redo Log File that is full and write its contents to an Archived Redo Log (ArchiveLog) file, thereby freeing up the online Redo Log File to accept further changes.
When the Archiver cannot do that - for lack of disk space - it stops and, as a result, stops the entire Database as well because the Database will not accept any change that it cannot make a note of (in Redo).

Phill W.
  • 9,889
  • 1
  • 12
  • 24
2

Connect SYS as SYSDBA:

If you're already logged in to the database server OS you can login without a password, assuming you can run commands as the Oracle software owner and have the ORACLE_SID environment parameter set:

sqlplus / as sysdba

or

rman / as sysdba

If you're connecting over the network:

sqlplus sys/password@service_name as sysdba

or

rman target sys/password@service_name as sysdba

The SYSDBA role credential is stored in an external password file and is not subject to expiration. This is not necessarily the same password you would use to connect without invoking the SYSDBA role.

pmdba
  • 3,337
  • 2
  • 7
  • 11