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 : 23-05-2017
ORA-28046

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

  • ora-27071 : unable to seek to desired position in file
  • ora-06120 : NETTCP: network driver not loaded
  • ora-00328 : archived log ends at change string, need later change string
  • ora-40221 : maximum target cardinality exceeded
  • ora-19602 : cannot backup or copy active file in NOARCHIVELOG mode
  • ora-25106 : only one of PARALLEL or NOPARALLEL clause may be specified
  • ora-13783 : invalid tuning scope
  • ora-32500 : Dirname 'string' cannot exceed 'number' characters
  • ora-14624 : DEFAULT subpartition must be last subpartition specified
  • ora-07495 : spwat: lm_wait failed.
  • ora-29322 : SCN string size too long -- maximum size 58 bytes/characters
  • ora-19033 : schema specified in the XML document does not match the schema parameter
  • ora-22835 : Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: string, maximum: string)
  • ora-36887 : (XSSRF06) Error rewriting OLAP DML expression. Column name string is not a valid ADT column.
  • ora-12151 : TNS:received bad packet type from network layer
  • ora-13711 : Some snapshots in the range [string, string] are missing key statistics.
  • ora-01631 : max # extents (string) reached in table string.string
  • ora-21615 : an OTS (named or simple) instance failed
  • ora-16955 : Unknown error during SQL analyze.
  • ora-06960 : Failed to access log file
  • ora-00393 : log string of thread string is needed for recovery of offline datafiles
  • ora-38782 : cannot flashback database to non-guaranteed restore point 'string'
  • ora-38457 : The attribute "string" is not a valid XMLType attribute.
  • ora-39168 : Object path string was not found.
  • ora-30189 : reserved for future use
  • ora-24027 : AQ HTTP propagation encountered error, status-code string, string
  • ora-00453 : backgroud process 'string' is dead
  • ora-27157 : OS post/wait facility removed
  • ora-29974 : Internal event for PL/SQL debugging
  • ora-08116 : can not acquire dml enough lock(S mode) for online index build
  • 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.