Home » RDBMS Server » Server Utilities » Export Fails EXP-00056: ORACLE error 28002 encountered
Export Fails EXP-00056: ORACLE error 28002 encountered [message #73431] Mon, 26 April 2004 11:59 Go to next message
saustin
Messages: 43
Registered: June 2003
Member
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. 

 

Report message to a moderator

Re: Export Fails EXP-00056: ORACLE error 28002 encountered [message #73459 is a reply to message #73431] Tue, 04 May 2004 23:14 Go to previous messageGo to next message
Prateek Sachan
Messages: 6
Registered: May 2004
Junior Member
Hi Steve,

Please check ur userid= parameter. the account password must be expiring.

Cheers.

Prateek

Report message to a moderator

Re: Export Fails EXP-00056: ORACLE error 28002 encountered [message #73463 is a reply to message #73459] Wed, 05 May 2004 03:25 Go to previous message
saustin
Messages: 43
Registered: June 2003
Member
Thanks Prateek !

Correct indeed ! The SYSTEM password had expired. Re-set and no more problem. Have a great day. Steve.

Report message to a moderator

Previous Topic: Export database version 8i with Oracle client 9i
Next Topic: ORA-12560: TNS:Protocol adaptor error while running SVRMGRL
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 01 16:18:07 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.