Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Export EXP-00056: ORACLE error 28002 ?

Status
Not open for further replies.

saustin

MIS
Feb 19, 2001
336
US
Hi,

Our nightly export just failed with the errors below.


EXP-00056: ORACLE error 28002 encountered
ORA-28002: the password will expire within 24851 days
EXP-00222:
System error message 2
System error message: No such file or directory

EXP-00056: ORACLE error 24309 encountered
ORA-24309: already connected to a server
EXP-00000: Export terminated unsuccessfully

Recently we started using password timeouts due to Sarbanes Oxley requirements. Several users have not reset their password. Is this related ? Did read the bug no 1654141 on Metalink but am not clear if ALL users need to be out of expired grace period for export to work again.

Any ideas GREATLY appreciated. Thanks, Steve.

 
Hi Sy,
Many thanks for the reply. Indeed the userid parameter was the key. It was SYSTEM who was expired. After he was re-set no more problem. Bug 1654141 was true here. Cheers, Steve.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top