ORA-12647: Authentication required

Cause : The parameter that controls whether authentication is required was set to true, but the executable does not have an authentication service linked in.

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

Either re-link the executable with an authentication service adapter or disable the parameter.

update : 24-06-2017

ORA-12647 - Authentication required
ORA-12647 - Authentication required

  • ora-24162 : name value pair list is full, cannot add another entry
  • ora-24335 : cannot support more than 1000 columns
  • ora-12624 : TNS:connection is already registered
  • ora-38958 : Source platform string is in different byte order than target platform string
  • ora-19597 : file string blocksize string does not match set blocksize of string
  • ora-32136 : Cannot perform operation on an invalid stream
  • ora-02083 : database name has illegal character 'string'
  • ora-23309 : object string.string of type string exists
  • ora-01679 : database must be mounted EXCLUSIVE and not open to activate
  • ora-01171 : datafile string going offline due to error advancing checkpoint
  • ora-12732 : invalid interval value in regular expression
  • ora-07514 : scgcan: $deq unexpected return while canceling lock
  • ora-29658 : EXTERNAL NAME clause is not compatible with its supertype
  • ora-23290 : This operation may not be combined with any other operation
  • ora-28669 : bitmap index can not be created on an IOT with no mapping table
  • ora-22605 : FDO handle [string] is not initialized
  • ora-22865 : more than one column specified
  • ora-01734 : illegal parameters - EXTENT MIN higher than EXTENT MAX
  • ora-00567 : Requested processor group string is too large (maximum string)
  • ora-09280 : sllfcf: error closing file
  • ora-01782 : UNRECOVERABLE cannot be specified for a cluster or clustered table
  • ora-29893 : indextypes without column data do not need the given data type
  • ora-22151 : cannot resize non-zero variable-length array to zero elements
  • ora-15050 : disk "string" contains string error(s)
  • ora-36681 : (XSDPART19) Partitions string and string are out of order.
  • ora-12606 : TNS: Application timeout occurred
  • ora-12040 : master rollback segment option not support by master site string
  • ora-06767 : TLI Driver: alloc failed during release
  • ora-29973 : Unsupported query or operation during change notification registration
  • ora-39763 : stream must be completely loaded before it is reset
  • 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.