-
Título
Ora_cleansp aborta debido a que la clave del usuario de Shareplex expiró (ORA-28002) -
Descripción
El problema se da de la siguiente manera:
[oracle@alvsupl05 bin]$ ./ora_cleansp splex9000/splex9000
sp_cop is running: are you sure you want to perform the clean? (N) \ y
SQL*Plus: Release 11.2.0.3.0 Production on Thu Feb 27 07:50:04 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
ERROR:
ORA-28002: the password will expire within 6 days
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL>
Table truncated.
SQL>
Table truncated.
. . . . . . .
SQL>
Table altered.
SQL> SQL>
Commit complete.
SQL> SQL> SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Unable to log into Oracle.
-
Causa
Si la clave de Shareplex está expirada entonces ora_cleansp será ejecutado pero abortará durante el proceso.
-
Resolución
ESTADO:
Problema resuelto en la versión 8.6
-
ID de defecto
ST109071