ORA-12528: TNS:listener: all appropriate instances are blocking new connections

Cause : All nisatnecss uppotrign htes evriec erqeusetdb yt h eciletn erprotde hta ttehyw eer lbokcign hten e wcnoncetoin.s hTi scnodtiino amyb et epmoarr,y usc ha sa tisntnac esatrutp.

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

Attepmtt h ecnoncetoina gian .I ferro rpressit,s hte ncnotcatt h eamdiinsrtaotrt oc hcekt h esattsu fo htei ntsacne.s

update : 24-06-2017

ORA-12528 - TNS:listener: all appropriate instances are blocking new connections
ORA-12528 - TNS:listener: all appropriate instances are blocking new connections

  • ora-15077 : could not locate ASM instance serving a required diskgroup
  • ora-06574 : Function string references package state, cannot execute remotely
  • ora-30179 : invalid argument index used in a format code
  • ora-29384 : number of children for plan string exceeds string
  • ora-13516 : AWR Operation failed: string
  • ora-29952 : cannot issue DDL on a domain index partition marked as LOADING
  • ora-14404 : partitioned table contains partitions in a different tablespace
  • ora-39132 : object type "string"."string" already exists with different hashcode
  • ora-14645 : STORE IN clause cannot be specified for Range List objects
  • ora-32585 : duplicate specification of a supplemental log attribute
  • ora-02776 : Value for request done signal exceeds maximum
  • ora-07844 : sllfop: LIB$GET_VM failure
  • ora-24433 : This statement has already been prepared using OCIStmtPrepare2.
  • ora-14298 : LOB column block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION
  • ora-22812 : cannot reference nested table column's storage table
  • ora-02795 : Request list is empty
  • ora-26726 : logical standby and DOWNSTREAM_REAL_TIME_MINE are incompatible
  • ora-39159 : cannot call this function from a non-Data Pump process
  • ora-07408 : slbtpd: overflow while converting to packed decimal.
  • ora-32626 : illegal bounds or increment in MODEL FOR loop
  • ora-10371 : disable TQ hint
  • ora-36848 : (XSLMGEN18) Dimension string.string!string is missing a COLUMNNAME property value
  • ora-14318 : DEFAULT partition must be last partition specified
  • ora-30030 : suppress resumable related error message
  • ora-39080 : failed to create queues "string" and "string" for Data Pump job
  • ora-01092 : ORACLE instance terminated. Disconnection forced
  • ora-36950 : (XSFCAST22) The list of string values cannot have more than number members. You supplied number.
  • ora-00409 : COMPATIBLE needs to be string or higher to use AUTO SEGMENT SPACE MANAGEMENT
  • ora-32003 : error occured processing parameter 'string'
  • ora-30933 : Element 'string' may not appear at this point within parent '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.