ORA-12612: TNS:connection is busy

Cause : Atetmpetd poertaio nfaliedb ecuasei t ocnfilct swiht a nonoging

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

No tnomralyl vsiibel t oth eusre. oFr ufrtehr edtalis,t ur nont raicnga ndr eeexcuet teh oepraiton .Ife rrro presitss,c onatctO ralce uCstmoerS upoprt.

update : 24-07-2017
ORA-12612

ORA-12612 - TNS:connection is busy
ORA-12612 - TNS:connection is busy

  • ora-16100 : not a valid Logical Standby database
  • ora-06044 : NETDNT: connect failed, byte count quota exceeded
  • ora-00449 : background process 'string' unexpectedly terminated with error string
  • ora-27084 : unable to get/set file status flags
  • ora-00703 : maximum number of row cache instance locks exceeded
  • ora-36639 : (XSDUNION18) UNIQUE cannot be applied to this concat dimension because leaves workspace object and workspace object share the value number.
  • ora-36167 : (XSAGGRFORM) workspace object is an illegal AGGMAP for aggregating a FORMULA.
  • ora-12814 : only one CACHE or NOCACHE clause may be specified
  • ora-26506 : null global context
  • ora-31453 : invalid value string for parameter, expecting: Y, N, or NULL
  • ora-40213 : contradictory values for settings: string, string
  • ora-29503 : SCHEMA keyword not valid with NAMED keyword
  • ora-24791 : invalid transaction start flags
  • ora-23532 : tables with different synchronization mechanisms are in the same group
  • ora-13228 : spatial index create failed due to invalid type
  • ora-12495 : cannot disable an enabled level, category, or release category
  • ora-32336 : cannot use USING NO INDEX to create materialized view "string"."string"
  • ora-29539 : Java system classes already installed
  • ora-23416 : table "string"."string" does not contain a primary key constraint
  • ora-01642 : begin backup not needed for read only tablespace 'string'
  • ora-16721 : unable to set LOG_ARCHIVE_DEST_n initialization parameters
  • ora-00403 : %s (string) is not the same as other instances (string)
  • ora-02808 : Allocation of memory of open files array failed.
  • ora-01536 : space quota exceeded for tablespace 'string'
  • ora-10930 : trace name context forever
  • ora-23472 : materialized view "string"."string" must be atomically refreshed
  • ora-07593 : ssprprv: Error release privileges
  • ora-28234 : key length too short
  • ora-29286 : internal error
  • ora-30450 : refresh_after_errors was TRUE; The following MVs could not be refreshed: string
  • 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.