ORA-12661: Protocol authentication to be used

Cause : Teh rOalceA davnecdS eucrtiya uhtetniactoins evriec ahsd eetrimnde hta tteh rOalceN e ttarnpsotr rpootclo ni suei st ob eu tliiezdt oa uhtetniact eau sre' siednitt.y

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

Tihse rorri su sde oslleyt oc ommuinctaei noframtoinb ewtene htea uhtetniactoins evriec nadt h eOarcel eNts essino alyre nads huol dnto onramlyl eb ivsbil.e fI htee rorri ss ene,c otnatc rOalceW olrdiwd eSpuprot.

update : 20-08-2017
ORA-12661

ORA-12661 - Protocol authentication to be used
ORA-12661 - Protocol authentication to be used

  • ora-02065 : illegal option for ALTER SYSTEM
  • ora-00132 : syntax error or unresolved network name 'string'
  • ora-29349 : tablespace 'string' already exists
  • ora-19247 : XQ0027 - validation error
  • ora-24812 : character set conversion to or from UCS2 failed
  • ora-31059 : Cannot insert root XML document node if it already exists
  • ora-01718 : BY ACCESS | SESSION clause not allowed for NOAUDIT
  • ora-31229 : DBMS_LDAP: invalid input parameter
  • ora-24327 : need explicit attach before authenticating a user
  • ora-31637 : cannot create job string for user string
  • ora-23300 : %s
  • ora-01526 : error in opening file 'string'
  • ora-22307 : operation must be on a user-defined type
  • ora-29282 : invalid file ID
  • ora-16224 : Database Guard is enabled
  • ora-30040 : Undo tablespace is offline
  • ora-16620 : one or more databases could not be contacted for a delete operation
  • ora-22324 : altered type has compilation errors
  • ora-39119 : worker process interrupt for delete worker processes call by master process
  • ora-12988 : cannot drop column from table owned by SYS
  • ora-10979 : trace flags for join index implementation
  • ora-31168 : Node localname and namespace values should be less than 64K
  • ora-02730 : osnrnf: cannot find user logon directory
  • ora-24775 : cannot prepare or commit transaction with non-zero lock value
  • ora-19688 : control file autobackup format(string) for string does not have %F
  • ora-38449 : table "string" does not exist or is not accessible
  • ora-31650 : timeout waiting for master process response
  • ora-13340 : a point geometry has more than one coordinate
  • ora-27120 : unable to removed shared memory segment
  • ora-32766 : instr with negative offset: use varchar semantics on LOBs
  • 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.