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 : 27-06-2017

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

  • ora-00022 : invalid session ID; access denied
  • ora-37060 : (XSMCSESS08) number is not a valid custom member in dimension workspace object.
  • ora-12902 : default temporary tablespace must be SYSTEM or of TEMPORARY type
  • ora-01327 : failed to exclusively lock system dictionary as required by build
  • ora-28582 : a direct connection to this agent is not allowed
  • ora-16095 : Dependent destination removal for inactivation
  • ora-27477 : "string.string" already exists
  • ora-07513 : sscgctl: $deq unexpected return on cancel of term. lock
  • ora-12405 : invalid label list
  • ora-13061 : topology with the name string does not exist
  • ora-15051 : file 'string' contains string error(s)
  • ora-06311 : IPA: Maximum number of servers reached
  • ora-22978 : only simple attribute name is allowed in the WITH OBJECT OID clause
  • ora-12533 : TNS:illegal ADDRESS parameters
  • ora-32584 : missing LOG keyword
  • ora-07264 : spwat: semop error, unable to decrement semaphore.
  • ora-21601 : attribute is not an object
  • ora-06576 : not a valid function or procedure name
  • ora-24380 : invalid mode specification
  • ora-13452 : GeoRaster metadata BIN function error
  • ora-12718 : operation requires connection as SYS
  • ora-01676 : standby file name convert of 'string' exceeds maximum length of string
  • ora-28520 : error initializing heterogeneous data dictionary translations
  • ora-31186 : Document contains too many nodes
  • ora-16228 : Insufficient recovery for logical standby
  • ora-36816 : (XSTBLFUNC09) The workspace object dimension is of datatype string which does not support custom member upserts.
  • ora-19626 : backup set type is string - can not be processed by this conversation
  • ora-08238 : smsfre: cannot detach from SGA
  • ora-19026 : EXTRACTVALUE can only retrieve value of leaf node
  • ora-13444 : GeoRaster metadata SRS error
  • 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.