ORA-12204: TNS:received data refused from an application

Cause : Teh papilctaino suign oCnencito nMnaaegrr eufsde htec onnetcino ta htel itseenr.

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

Mkaes uer hta tteh papilctaino ilsetnre ta hted etsiantoini sf ucntoinnigc orretcl.y fI ti si nadt h eporbelmp esritss ,cnotcatW olrdiwd eCsutmoe rSpuprot.

update : 26-09-2017
ORA-12204

ORA-12204 - TNS:received data refused from an application
ORA-12204 - TNS:received data refused from an application

  • ora-16700 : the standby database has diverged from the primary database
  • ora-24403 : error occured while trying to destroy the connection pool
  • ora-09949 : Unable to get client operating system privileges
  • ora-30682 : improper value for argument OPTION_FLAGS
  • ora-23324 : error string, while creating deferror entry at "string" with error string
  • ora-03296 : cannot resize datafile - file string not found
  • ora-02733 : osnsnf: database string too long
  • ora-16641 : failure to acquire broker configuration metadata lock
  • ora-24324 : service handle not initialized
  • ora-02236 : invalid file name
  • ora-37127 : (XSCCOMP02) The COMPRESSED COMPOSITE workspace object must be last in the dimension list.
  • ora-13430 : the GeoRaster object has null attribute(s)
  • ora-30015 : previously offlined undo tablespace 'string' is still pending
  • ora-30745 : error occured while trying to add column "string" in table "string"
  • ora-01412 : zero length not allowed for this datatype
  • ora-31163 : element or attribute "string" has invalid attribute value "string" (should be "string")
  • ora-06105 : NETTCP: remote host is unknown
  • ora-19662 : archived log thread string sequence string could not be verified
  • ora-06505 : PL/SQL: variable requires more than 32767 bytes of contiguous memory
  • ora-31030 : Unable to retrieve XML document
  • ora-04086 : trigger description too long, move comments into triggering code
  • ora-37603 : (XSPGERRTEMPSYSTEM) Ran out of temporary storage while writing to a system temporary analytic workspace. Free some temporary storage immediately. You can do so, for example, by DETACHING an analytic workspace.
  • ora-07284 : sksaprd: volume size specification not terminated properly.
  • ora-29270 : too many open HTTP requests
  • ora-16657 : reinstatement of database in progress
  • ora-23617 : Block string for script string has already been executed
  • ora-31411 : change set string is referenced by a change table
  • ora-25401 : can not continue fetches
  • ora-28368 : cannot auto-create wallet
  • ora-24069 : cannot downgrade queue table string while it is being upgraded
  • 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.