Return
-
Title
Ora_cleansp aborted when Splex user's password is expiring (ORA-28002) -
Description
The problem looks like:[oracle@alvsupl05 bin]$ ./ora_cleansp splex9000/splex9000sp_cop is running: are you sure you want to perform the clean? (N) \ ySQL*Plus: Release 11.2.0.3.0 Production on Thu Feb 27 07:50:04 2014Copyright (c) 1982, 2011, Oracle. All rights reserved.ERROR:ORA-28002: the password will expire within 6 daysConnected to:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,Data Mining and Real Application Testing optionsSQL> 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 ProductionWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,Data Mining and Real Application Testing optionsUnable to log into Oracle. -
Cause
If the splex user's password is expiring then when ora_cleansp is run the oracle script will succeed, but ora_cleansp will be aborted. -
Resolution
STATUS:
Issue resolved in version 8.6.
-
Defect ID
ST109071