ORA-12234: TNS:Redirect to destination

Cause : This error is reported by an interchange which determines that this interchange is not the right gateway and needs to redirect the connection to another gateway along the path to the destination.

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


update : 24-05-2017

ORA-12234 - TNS:Redirect to destination
ORA-12234 - TNS:Redirect to destination

  • ora-26745 : cursors (string) are not sufficient
  • ora-02267 : column type incompatible with referenced column type
  • ora-16154 : suspect attribute: string
  • ora-38855 : cannot mark instance string (redo thread string) as enabled
  • ora-24778 : cannot open connections
  • ora-07205 : slgtd: time error, unable to obtain time.
  • ora-12209 : TNS:encountered uninitialized global
  • ora-30959 : The indexed column is not stored in CLOB.
  • ora-39021 : Database compatibility version string is not supported.
  • ora-16799 : Redo Apply is offline
  • ora-22925 : operation would exceed maximum size allowed for a LOB value
  • ora-07499 : spglk: Cannot reschedule.
  • ora-25426 : remote instance does not support shared dblinks
  • ora-14264 : table is not partitioned by Composite Range method
  • ora-31089 : schema "string" does not target namespace "string"
  • ora-07452 : specified resource manager plan does not exist in the data dictionary
  • ora-10943 : trace name context forever
  • ora-00439 : feature not enabled: string
  • ora-06256 : NETNTT: remote fork failed
  • ora-22278 : must update the LOB only through the LOB buffers
  • ora-16772 : error switching over between primary and standby databases
  • ora-32504 : expecting one of string, string, string, or string but found string
  • ora-13907 : Threshold value is invalid.
  • ora-09823 : device name is too long
  • ora-12197 : TNS:keyword-value resolution error
  • ora-27011 : skgfrd: cannot read from file opened for write
  • ora-30040 : Undo tablespace is offline
  • ora-12902 : default temporary tablespace must be SYSTEM or of TEMPORARY type
  • ora-12452 : label tag string already exists
  • ora-02751 : osnfsmmap: cannot map shared memory file
  • 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.