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 : 19-08-2017

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

  • ora-00161 : transaction branch length string is illegal (maximum allowed string)
  • ora-14085 : partitioned table cannot have column with LONG datatype
  • ora-36802 : (XSTBLFUNC01) The OLAP_TABLE function must contain a DATAMAP that executes a FETCH command or a LIMITMAP.
  • ora-19603 : cannot backup or copy active file with KEEP .. UNRECOVERABLE option
  • ora-01291 : missing logfile
  • ora-39094 : Parallel execution not supported in this database edition.
  • ora-12054 : cannot set the ON COMMIT refresh attribute for the materialized view
  • ora-29872 : parameters clause cannot be combined with the specified options
  • ora-38796 : Not enough flashback database log data to undo FLASHBACK.
  • ora-06264 : NETNTT: data protocol error
  • ora-02300 : invalid value for OIDGENERATORS
  • ora-13416 : invalid geometry parameter
  • ora-30181 : integer in argument index is not immediately followed by )
  • ora-04044 : procedure, function, package, or type is not allowed here
  • ora-12433 : create trigger failed, policy not applied
  • ora-29884 : domain index is defined on the column to be dropped
  • ora-13870 : Database-wide SQL tracing is not enabled
  • ora-36314 : (PHYS01) workspace object must be a dimension, relation or variable.
  • ora-02703 : osnpopipe: pipe creation failed
  • ora-22925 : operation would exceed maximum size allowed for a LOB value
  • ora-31203 : DBMS_LDAP: PL/SQL - Init Failed.
  • ora-32050 : %s operation failed
  • ora-16730 : error executing dbms_logstdby.skip_txn procedure
  • ora-34019 : (MSCGADD03) workspace object is not a LIST PARTITION TEMPLATE.
  • ora-24097 : Invalid value string, string should be non-negative
  • ora-01438 : value larger than specified precision allowed for this column
  • ora-04092 : cannot string in a trigger
  • ora-00385 : cannot enable Very Large Memory with new buffer cache parameters
  • ora-24404 : connection pool does not exist
  • ora-02820 : Unable to write the requested number of blocks
  • 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.