How to fix the Oracle error ORA-28046: Password change for SYS disallowed?

In this post, you’ll learn more about the Oracle ErrorORA-28046: Password change for SYS disallowed with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-28046: Password change for SYS disallowed

Reason for the Error ORA-28046: Password change for SYS disallowed

REMOTE_LOGIN_PASSWORDFILE is set to SHARED, prohibiting SYS password changes.

How to fix the Error ORA-28046: Password change for SYS disallowed ?

You can fix this error in Oracle by following the below steps

Change setting of REMOTE_LOGIN_PASSWORDFILE to EXCLUSIVE or NONE.

Tags :

Leave Your Comment