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 : 27-06-2017

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

  • ora-13770 : Baseline "string" does not exist.
  • ora-19274 : XQ0054 - variable initialization failed due to circularity
  • ora-07215 : slsget: getrusage error.
  • ora-01485 : compile bind length different from execute bind length
  • ora-30088 : datetime/interval precision is out of range
  • ora-03122 : attempt to close ORACLE-side window on user side
  • ora-14626 : values being added already exist in DEFAULT subpartition
  • ora-06606 : LU6.2 Driver: Unexpected response from SNA
  • ora-00029 : session is not a user session
  • ora-27157 : OS post/wait facility removed
  • ora-22871 : ALTER TYPE with REPLACE is not allowed for pure incomplete types
  • ora-28511 : lost RPC connection to heterogeneous remote agent using SID=string
  • ora-00324 : log file 'string' translated name 'string' too long, string characters exceeds string limit
  • ora-16958 : DML statements running parallel are not supported for test execute.
  • ora-24035 : AQ agent string is not a subscriber for queue string
  • ora-13844 : no new SQL profile name or category specified.
  • ora-32810 : foreign queue string is not registered
  • ora-01129 : user's default or temporary tablespace does not exist
  • ora-28150 : proxy not authorized to connect as client
  • ora-36667 : (XSDPART05) string is not a legal CONCAT partition.
  • ora-07426 : spstp: cannot obtain the location of dbs directory.
  • ora-19371 : invalid update option
  • ora-38903 : DML error logging is not supported for abstract column "string"
  • ora-27005 : cannot open file for async I/O on device not supporting async
  • ora-13615 : The task or object string is greater than the maximum allowable length of 30 characters.
  • ora-16008 : indeterminate control file checkpoint
  • ora-16122 : applying large dml transaction at SCN string
  • ora-32343 : let MVIEW engine know that it is IMPORT from 9i or earlier
  • ora-02097 : parameter cannot be modified because specified value is invalid
  • ora-23427 : deferred purge queue argument string out of range
  • 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.