Oracle 11 - Oracle users expired

[Former Member]

Dears,

this morning I discovered my Sap Netweaver system based on Oracle 11 down .

Into the logs I discovered the matter:

the schema owner SAPSR3 was expired.

As I can see this feature was introducted by Oracle 11, the expiry date is after 180 days from the installation.

I wonder there are no Oss notes for this issue.

Best Regards

[Former Member · Accepted solution]

Hi Roberto,

Check Note 1519872 - SAP Database User Profile SAPUPROF

Best regards,

Orkun Gedik

[former_member204746]

try this:

ALTER PROFILE DEFAULT LIMIT

FAILED_LOGIN_ATTEMPTS UNLIMITED

PASSWORD_LIFE_TIME UNLIMITED;