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 : 27-04-2017
ORA-12204

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

  • ora-38438 : getVarchar not possible due to "string" datatype in the attribute set
  • ora-16180 : number processes specified for MAX_PARALLEL_SERVERS is too small
  • ora-28361 : master key not yet set
  • ora-13331 : invalid LRS segment
  • ora-15155 : version incompatible with the cluster
  • ora-23371 : column string unknown in table string
  • ora-12993 : tablespace 'string' is offline, cannot drop column
  • ora-15024 : discovered duplicately numbered ASM disk string
  • ora-23615 : Block number string does not exist for script string
  • ora-39012 : Client detached before the job started.
  • ora-06711 : TLI Driver: error on bind
  • ora-07290 : sksagdi: specified directory for archiving does not exist.
  • ora-01755 : Must specify an extent number or block number
  • ora-14164 : subpartition "string": INITRANS value must be less than MAXTRANS value
  • ora-33074 : (XSAGDNGL36) In AGGMAP workspace object, the offset number is not a valid offset into dimension workspace object.
  • ora-22982 : cannot create sub-view under this view
  • ora-22924 : snapshot too old
  • ora-36873 : (XSTFDSC03) Column type must be specified explicitly.
  • ora-29271 : not connected
  • ora-23418 : cannot unregister the propagator who is currently in use
  • ora-06523 : Maximum number of arguments exceeded
  • ora-25104 : UNRECOVERABLE option can only be used with ALTER INDEX REBUILD
  • ora-30358 : summary and materialized view are not in same schema
  • ora-01092 : ORACLE instance terminated. Disconnection forced
  • ora-32341 : The EXPLAIN_MVIEW facility failed to explain the materialized view "string"."string"
  • ora-27013 : skgfqdel: cannot delete an open file
  • ora-28181 : proxy 'string' failed to enable one or more of the specified initial roles for client 'string'
  • ora-19323 : Invalid url string
  • ora-36841 : (XSLMGEN11) Dimension string.string!string was not found
  • ora-14322 : DEFAULT partition already exists
  • 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.