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 : 29-04-2017

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

  • ora-07248 : sfwfb: write error, unable to write database block.
  • ora-12706 : this CREATE DATABASE character set is not allowed
  • ora-14100 : partition extended table name cannot refer to a remote object
  • ora-38470 : cannot revoke a privilege that was not granted.
  • ora-14047 : ALTER TABLE|INDEX RENAME may not be combined with other operations
  • ora-26080 : file "string" is not part of table string.string partition string
  • ora-23410 : materialized view "string"."string" is already in a refresh group
  • ora-01469 : PRIOR can only be followed by a column name
  • ora-27478 : job "string.string" is running
  • ora-15116 : invalid combination of ALTER DISKGROUP options
  • ora-01116 : error in opening database file string
  • ora-24050 : subscribers are not supported for exception queue string
  • ora-12609 : TNS: Receive timeout occurred
  • ora-24046 : protocol attribute reserved for future use
  • ora-23304 : malformed deferred rpc at arg string of string in call string, in tid string
  • ora-39771 : stream must be loaded before its handle is freed
  • ora-38858 : cannot mark redo thread string as enabled
  • ora-06127 : NETTCP: unable to change username
  • ora-09961 : Unable to restore termination signal handler
  • ora-25446 : duplicate column value for table alias: string, column: string
  • ora-12629 : TNS:no event test
  • ora-28584 : heterogeneous apply internal error
  • ora-23536 : the object "string"."string" is not cached at the middle tier as expected.
  • ora-30753 : column or table string is substitutable
  • ora-26083 : unsupported direct path stream version string
  • ora-16826 : apply service state is inconsistent with the DelayMins property
  • ora-22166 : collection is empty
  • ora-00395 : online logs for the clone database must be renamed
  • ora-31483 : cannot have spaces in the parameter string
  • ora-06960 : Failed to access log 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.