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 : 29-05-2017
ORA-12612

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

  • ora-15201 : disk string contains a valid RDBMS file
  • ora-00383 : DEFAULT cache for blocksize string cannot be reduced to zero
  • ora-36180 : (XSAGGR08) AGGREGATE cannot function because there is a permission clause associated with variable workspace object.
  • ora-01684 : max # extents (string) reached in table string.string partition string
  • ora-12531 : TNS:cannot allocate memory
  • ora-28512 : cannot get data dictionary translations from string
  • ora-01665 : control file is not a standby control file
  • ora-27460 : cannot execute disabled job "string.string"
  • ora-07680 : sou2os: another call to Oracle currently executing
  • ora-36921 : (XSVPMVTOPART02) workspace object and workspace object are not in the same analytic workspace.
  • ora-25306 : Cannot connect to buffered queue's owner instance
  • ora-32103 : error from OCI call
  • ora-31411 : change set string is referenced by a change table
  • ora-12215 : TNS:poorly formed PREFERRED_NAVIGATORS Addresses in TNSNAV.ORA
  • ora-24292 : no more tables permitted in this sorted hash cluster
  • ora-01417 : a table may be outer joined to at most one other table
  • ora-01925 : maximum of string enabled roles exceeded
  • ora-24414 : Only number sessions could be started.
  • ora-24816 : Expanded non LONG bind data supplied after actual LONG or LOB column
  • ora-07415 : slpath: allocation of memory buffer failed.
  • ora-29896 : Length of PARAMETER string longer than string characters
  • ora-30374 : materialized view is already fresh
  • ora-33016 : (XSAGDNGL07) In AGGMAP workspace object, workspace object is not a valid operator or variable name.
  • ora-07390 : sftopn: translate error, unable to translate file name.
  • ora-25193 : cannot use COMPRESS option for a single column key
  • ora-01097 : cannot shutdown while in a transaction - commit or rollback first
  • ora-13374 : SDO_MBR not supported for geodetic data
  • ora-07578 : szprv: $FIND_HELD failure
  • ora-26017 : global indexes not allowed for direct path load of table partition string
  • ora-19576 : datafile string not defined in control file
  • 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.