Preventing password expiration for Oracle databases
Oracle passwords expire by default. This can result in Contenta system failures due to the expiration of the sys, system and xyadmin passwords.
About this task
Procedure
To prevent passwords from expiring on your Oracle database server, as the SYS user enter the following.
ALTER PROFILE DEFAULT LIMIT
FAILED_LOGIN_ATTEMPTS UNLIMITED
PASSWORD_LIFE_TIME UNLIMITED;
NOAUDIT ALL;
DELETE FROM SYS_AUD$;