ORA-28042: Server authentication failed

Cause : Srevre afieldt oa uhtetniact eistefl ot htec leint

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

Cnofrimt hta htes evre ri sav aildd aatbsaes evre.r

update : 23-08-2017
ORA-28042

ORA-28042 - Server authentication failed
ORA-28042 - Server authentication failed

  • ora-31606 : XML context number does not match any previously allocated context
  • ora-32845 : Messaging Gateway agent is already running
  • ora-38473 : cannot drop a type used for Expression Filter attribute set
  • ora-12007 : materialized view reuse parameters are inconsistent
  • ora-13752 : User "string" must be SYS or must have the "ADMINISTER ANY SQL TUNING SET" privilege.
  • ora-12554 : TNS:current operation is still in progress
  • ora-31181 : PL/SQL DOM handle accesses node that is no longer available
  • ora-13856 : Service name must be specified
  • ora-07246 : sfofi: open error, unable to open database file.
  • ora-16123 : transaction string string string is waiting for commit approval
  • ora-36924 : (XSVPMVTOPART05) workspace object is not in a COMPOSITE.
  • ora-01203 : wrong incarnation of this file - wrong creation SCN
  • ora-37101 : (XSVPART01) Partitioning information can only be given for variables dimensioned by a PARTITION TEMPLATE.
  • ora-27125 : unable to create shared memory segment
  • ora-13025 : polygon does not close
  • ora-39709 : incomplete component downgrade; string downgrade aborted
  • ora-07258 : spdcr: fork error, unable to create process.
  • ora-19564 : error occurred writing string bytes at block number string
  • ora-12086 : table "string"."string" is not an object table
  • ora-01277 : file 'string' already exists
  • ora-27211 : Failed to load Media Management Library
  • ora-00056 : DDL lock on object 'string.string' is already held in an incompatible mode
  • ora-28023 : must revoke grants of this role to other user(s) first
  • ora-01200 : actual file size of string is smaller than correct size of string blocks
  • ora-14021 : MAXVALUE must be specified for all columns
  • ora-31652 : command response message was invalid type - detaching job
  • ora-13854 : Tracing for service(module/action) string on instance string is not enabled
  • ora-36998 : (XSRELGID15) LEVEL ORDER VALUESET workspace object and LEVEL RELATION workspace object have the different level dimensions.
  • ora-09968 : unable to lock file
  • ora-16650 : command incompatible when Fast-Start Failover is enabled
  • 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.