ORA-28046: Password change for SYS disallowed

Cause : REMOTE_LOGIN_PASSWORDFILE is set to SHARED, prohibiting SYS password changes.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Change setting of REMOTE_LOGIN_PASSWORDFILE to EXCLUSIVE or NONE.

update : 27-04-2017
ORA-28046

ORA-28046 - Password change for SYS disallowed
ORA-28046 - Password change for SYS disallowed

  • ora-31478 : could not detach LogMiner session after change set advance
  • ora-29305 : cannot point-in-time recover tablespace 'string'
  • ora-30959 : The indexed column is not stored in CLOB.
  • ora-04053 : error occurred when validating remote object stringstringstringstringstring
  • ora-30432 : summary 'string.string' is in INVALID state
  • ora-33215 : (CINSERT07) You cannot add session-only values to the workspace object dimension.
  • ora-01090 : shutdown in progress - connection is not permitted
  • ora-22813 : operand value exceeds system limits
  • ora-19762 : invalid file type string
  • ora-09953 : scggc: unexpected return of a lock convert
  • ora-31434 : purge is currently running
  • ora-30439 : refresh of 'string.string' failed because of string
  • ora-08197 : Flashback Table operation is not supported on clustered tables
  • ora-32131 : bind data type cannot be changed
  • ora-36883 : (XSSRF02) The first parameter of an AW single row function cannot be NULL.
  • ora-30501 : instance shutdown triggers cannot have AFTER type
  • ora-07718 : sksafre: error freeing memory
  • ora-14162 : subpartition "string": sum of PCTUSED and PCTFREE may not exceed 100
  • ora-09778 : snynfyport: failure allocating the notify port.
  • ora-32052 : failed to start mapping service
  • ora-28514 : heterogeneous database link initialization could not convert system date
  • ora-32162 : Read/Write SQL method not registered
  • ora-09914 : Unable to open the ORACLE password file.
  • ora-04021 : timeout occurred while waiting to lock object stringstringstringstringstring
  • ora-32611 : incorrect use of MODEL CV operator
  • ora-01521 : error in adding data files
  • ora-40306 : wide data not supported for decision tree model create
  • ora-27373 : unknown or illegal event source queue
  • ora-29522 : authorization error for referenced name string.string
  • ora-13188 : cell decode failed
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.