ORA-10940: trace name context forever

Cause : Size fo the LP/SQL rtacingc irculra buffre, in iklobytse.

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

Set tihs evetn in cnocert iwth th e10938e vent nad the_ PLSQLD_UMP_BFUFER_EEVNTS iint.orap arameetr, unedr suprevisio nof Orcale Support.

update : 29-04-2017

ORA-10940 - trace name context forever
ORA-10940 - trace name context forever

  • ora-38753 : Cannot flashback data file string; no flashback log data.
  • ora-28554 : pass-through SQL: out of cursors
  • ora-12053 : this is not a valid nested materialized view
  • ora-15011 : failure group "string" contains no members
  • ora-14131 : enabled UNIQUE constraint exists on one of the tables
  • ora-31525 : could not find column string in CDC change table string.string
  • ora-06605 : LU6.2 Driver: Unexpected line turnaround
  • ora-02767 : Less than one request descriptor was allocated per server
  • ora-38773 : cannot add data file 'string' - file already part of database
  • ora-30114 : error when processing from command line
  • ora-25311 : %s not supported for non-persistent queue
  • ora-22165 : given index [string] must be in the range of [string] to [string]
  • ora-02314 : illegal use of type constructor
  • ora-12419 : null binary label value
  • ora-38711 : Corrupt flashback log block header: block string
  • ora-09767 : osnmfs: bad return code from msg_send.
  • ora-01186 : file string failed verification tests
  • ora-12222 : TNS:no support is available for the protocol indicated
  • ora-04054 : database link string does not exist
  • ora-07601 : spguno: $GETJPIW failure
  • ora-34363 : (MXDSS13) number other user writing
  • ora-14273 : lower-bound partition must be specified first
  • ora-07759 : slemtr: invalid destination
  • ora-24904 : invalid callback attribute passed into OCI call
  • ora-24054 : cannot propagate to an Oracle 8.0.3 release or lower release
  • ora-30354 : Query rewrite not allowed on SYS relations
  • ora-08429 : raw data has invalid digit in display type data
  • ora-39035 : Data filter string has already been specified.
  • ora-39094 : Parallel execution not supported in this database edition.
  • ora-01625 : rollback segment 'string' does not belong to this instance
  • 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.