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 : 26-04-2017
ORA-12612

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

  • ora-07493 : scgrcl: lock manager error.
  • ora-33448 : (ESDREAD04) Discarding compiled code for workspace object because number now has string data, whereas it had string data when the code was compiled.
  • ora-01253 : cannot start online backup - file string in recovery manager backup
  • ora-36830 : (XSLMGEN00) AW name cannot be NA
  • ora-37132 : (XSCCOMP07) Incremental aggregation over the dense DIMENSION workspace object is not supported when aggregating a VARIABLE dimensioned by a COMPRESSED COMPOSITE.
  • ora-13186 : fixed tile size tessellation failed
  • ora-24157 : duplicate variable name string
  • ora-12583 : TNS:no reader
  • ora-19713 : invalid copy number: string
  • ora-38497 : Expression Filter index does not exist
  • ora-04047 : object specified is incompatible with the flag specified
  • ora-22057 : bad integer length [string]
  • ora-24777 : use of non-migratable database link not allowed
  • ora-00600 : internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string]
  • ora-00965 : column aliases not allowed for '*'
  • ora-16026 : parameter string contains an invalid attribute value
  • ora-14049 : invalid ALTER TABLE MODIFY PARTITION option
  • ora-12471 : Specified compartment or group is not authorized for user
  • ora-07511 : sscggtl: $enq unexpected return for master termination lock
  • ora-36669 : (XSDPART07) string is not a legal LIST partition.
  • ora-09280 : sllfcf: error closing file
  • ora-40206 : invalid setting value for setting name string
  • ora-01104 : number of control files (string) does not equal string
  • ora-38443 : An attribute set should be assigned to the expression set for statistics collection.
  • ora-13233 : failed to create sequence number [string] for R-tree
  • ora-30431 : refresh method must be ANY or INCREMENTAL or FORCE_FULL, not string
  • ora-39130 : Object type string not imported. Base object name conflicts with the master table
  • ora-04068 : existing state of packagesstringstringstring has been discarded
  • ora-00056 : DDL lock on object 'string.string' is already held in an incompatible mode
  • ora-24353 : user buffer too small to accommodate COBOL display type
  • 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.