Skip to main content
Question

Error by starting of the restore of the DB - ORA-65162: The password of the common user has expired

  • June 18, 2024
  • 2 replies
  • 331 views
A
Sidekick (Customer)

I try to restore a DB-Dump in our IFSDEV enviroment. We have IFS Apps 10, Update 10. We did it in the past without any problem.
Now we get following Error after the command

impdp directory=TRANSFER dumpfile=CS0228700_DB_%U.dmp logfile=imp_20240618.log table_exists_action=REPLACE parallel=4

Error:

UDI-65162: operation generated ORACLE error 65162
ORA-65162: The password of the common user has expired

 

I could login with sqlplus with the user ‘system as sysdba’ without any problem.

 

Best Regards,

André

2 replies

H
Hero (Employee)
Forum|alt.badge.img+11
  • hhanse
  • Hero (Employee)
  • 200 replies
  • June 18, 2024

Yeah - i vaguely remember seeing similar stuff some years back. And what i’m to write will sound strange as well…as i don’t fully remember :)

First i think there is a strange caching of login credentials in sqlplus(!) 
Second - oracle introduced a new default expiry time on the sysdba accounts that i think came in a patch bundle.

Try updating the sys and system passwords even if you can use the expired pwd’s in sqlplus...
 

A
Sidekick (Customer)
  • andjor
  • Author
  • 55 replies
  • June 19, 2024

I cloud solve the problem.

I login with the user “system” without “as sysdba” in the sqlplus. Then it ask me for the new password. It was possible to use the same old password.

Best Regards
André


Terms & ConditionsCookie settingsAccessibility statement