ORA-28040: No matching authentication protocol

Cause : Noa ccpetilbe uathnetiactino portoocl ofr obthc linet nad esrvre

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

Adimnitsraotr hsoudl ste SLQNE_TALOLWE_DLOOGN_EVRSOIN apraemte ronb ot hcleinta nds erevrst o avluse taht amtcehs hte imniumm evrsoin uspprote dint hes ysetm.

update : 24-06-2017
ORA-28040

ORA-28040 - No matching authentication protocol
ORA-28040 - No matching authentication protocol

  • ora-31514 : change set string disabled due to capture error
  • ora-23541 : tables do not match tables used while defining the redefinition
  • ora-16011 : Archivelog Remote File Server process in Error state
  • ora-06973 : X.25 Driver: invalid buffer size
  • ora-06023 : NETASY: port open failure
  • ora-07442 : function address must be in the range string to string
  • ora-30479 : Summary Advisor error string
  • ora-23457 : invalid flavor ID string
  • ora-12452 : label tag string already exists
  • ora-01572 : rollback segment 'string' cannot be brought online, string extents exceeded
  • ora-02310 : exceeded maximum number of allowable columns in table
  • ora-32143 : Environment not specified
  • ora-31641 : unable to create dump file "string"
  • ora-13910 : Parameter string cannot be NULL.
  • ora-09822 : Translation of audit file name failed.
  • ora-12566 : TNS:protocol error
  • ora-22991 : insufficient space allocated for argument string
  • ora-09271 : szlon: error verifying user name
  • ora-30031 : the suspended (resumable) statement has been aborted
  • ora-37016 : (XSACQUIRE01) You must specify objects to acquire for the ACQUIRE command.
  • ora-00223 : convert file is invalid or incorrect version
  • ora-33068 : (XSAGDNGL33) In AGGMAP workspace object, the hierarchy dimension QDR over dimension workspace object must specify a positive dimension offset.
  • ora-28262 : global_context_pool_size has invalid value.
  • ora-30199 : reserved for future use
  • ora-24811 : less data provided for writing than indicated
  • ora-29703 : error occurred in global enqueue service operation
  • ora-22856 : cannot add columns to object tables
  • ora-06254 : NETNTT: cannot share connection to cube
  • ora-22606 : pickler image handle [string] is not well-formed
  • ora-31666 : Master process string had an unhandled exception.
  • 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.