ORA-12527: TNS:listener: all instances are in restricted mode or blocking new connections

Cause : All paporpiraet adtbaaes nisatnecss uppotrign htes evriec erqeusetdb yt h eciletn erprotde hta ttehye ihte rwreei nr etsrcitde omd eo rwreeb lcoknigt h enwe ocnencitosn.T h eLsitnee rdeosn o tallo wcnoncetoin st oscuhi ntsacne.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 edtaaabs eamdiinsrtaotrt oc hcekt h esattsu fo htei ntsacne.s

update : 24-05-2017
ORA-12527

ORA-12527 - TNS:listener: all instances are in restricted mode or blocking new connections
ORA-12527 - TNS:listener: all instances are in restricted mode or blocking new connections

  • ora-31199 : Warning in processing file string
  • ora-13012 : an invalid window type was specified
  • ora-16572 : Data Guard configuration file not found
  • ora-40003 : wordsize must be in the range string - string for BLAST-P
  • ora-06705 : TLI Driver: remote node is unknown
  • ora-30970 : option not supported for XML Index
  • ora-16218 : This database is already preparing to switch over.
  • ora-07453 : requested resource manager plan schema does not contain OTHER_GROUPS
  • ora-24199 : message store is overflow
  • ora-08414 : error encountered in string
  • ora-10563 : Test recovery had to corrupt data block (file# string, block# string) in order to proceed
  • ora-01538 : failed to acquire any rollback segment
  • ora-14047 : ALTER TABLE|INDEX RENAME may not be combined with other operations
  • ora-30392 : the checksum analysis for the rewrite equivalence failed
  • ora-36163 : (XSMXAGGR06) The AGGREGATE function cannot be run on more than one variable at a time.
  • ora-29914 : ODCIGETINTERFACES routine does not return required stream version
  • ora-02159 : installed DLM does not support releasable locking mode
  • ora-07612 : $GETUAI failed in retrieving the user's clearance level
  • ora-37038 : (XSMLTDCL04) You cannot change definitions of objects in analytic workspace string because it is attached in MULTI mode.
  • ora-29536 : badly formed source: string
  • ora-01246 : recovering files through TSPITR of tablespace string
  • ora-30556 : functional index is defined on the column to be modified
  • ora-13906 : The tablepace is not of the right type.
  • ora-16170 : Terminal recovery may have left the database in an inconsistent state
  • ora-36690 : (NTEXTCNV01) Error during conversion from NTEXT to TEXT.
  • ora-14006 : invalid partition name
  • ora-12334 : database (link name string) is still open
  • ora-02239 : there are objects which reference this sequence
  • ora-02059 : ORA-2PC-CRASH-TEST-string in commit comment
  • ora-02236 : invalid file name
  • 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.