ORA-12574: TNS:redirection denied

Cause : The connect request failed because it would have required redirection and the caller has requested no redirections.

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

Not normally visible to the user. For further details, turn on tracing and reexecute the operation. If error persists, contact Oracle Customer Support.

update : 23-08-2017
ORA-12574

ORA-12574 - TNS:redirection denied
ORA-12574 - TNS:redirection denied

  • ora-26575 : remote database does not support replication parallel propagation
  • ora-12468 : max write level does not equal max read level
  • ora-02322 : failure in accessing storage table of the nested table column
  • ora-28595 : Extproc agent : Invalid DLL Path
  • ora-27212 : some entrypoints in Media Management Library are missing
  • ora-12721 : operation cannot execute when other sessions are active
  • ora-07650 : sigunc: $GETJPIW failure
  • ora-01373 : insufficient memory for staging persistent LogMiner session
  • ora-30455 : summary contains VARIANCE without corresponding SUM & COUNT
  • ora-02423 : schema name does not match schema authorization identifier
  • ora-09802 : Conversion of binary label to string failed.
  • ora-01900 : LOGFILE keyword expected
  • ora-30971 : illegal operation on the Path Table
  • ora-03262 : the file is non-empty
  • ora-14266 : data type or length of an index subpartitioning column may not be changed
  • ora-12197 : TNS:keyword-value resolution error
  • ora-37602 : (XSPGERRTEMPUSER) Ran out of temporary storage while writing to analytic workspace string. Free some temporary storage immediately. You can do so, for example, by DETACHING an analytic workspace.
  • ora-25219 : enqueue failed, sequence deviation not allowed for queue string.string
  • ora-29822 : selectivity cannot be specified for the type of object
  • ora-38856 : cannot mark instance string (redo thread string) as enabled
  • ora-13788 : invalid recommendation type
  • ora-02373 : Error parsing insert statement for table string.
  • ora-19580 : %s conversation not active
  • ora-25258 : cannot register for notifications on an 8.0 style exception queue
  • ora-36814 : (XSTBLFUNC07) The datatype of the column used in the ROW2CELL clause of a LIMITMAP must be RAW(16).
  • ora-07569 : slspool: $CLOSE failure
  • ora-30488 : argument should be a function of expressions in PARTITION BY
  • ora-01292 : no log file has been specified for the current LogMiner session
  • ora-16065 : remote archival disabled at standby destination
  • ora-25440 : invalid table alias: string
  • 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.