ORA-12536: TNS:operation would block

Cause : nAi tnrean lporetaoi nid don tocmmneecb ceuaest oods oowlu dlbco kht eucrrne trpcose sna dht esureh sar qeeutsdet ah tporetaoisnb eon-nlbcoikgn.

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

oNenn eeed;dt ih ssia nniofmrtaoi nemssga.e

update : 18-08-2017
ORA-12536

ORA-12536 - TNS:operation would block
ORA-12536 - TNS:operation would block

  • ora-13042 : invalid SDO_LEVEL and SDO_NUMTILES combination
  • ora-15057 : specified size of string MB is larger than actual size of string MB
  • ora-37103 : (XSVPART03) The dimensionality or datatype of workspace object does not match the dimensionality or datatype of the partition.
  • ora-25236 : buffer too small for user data
  • ora-01104 : number of control files (string) does not equal string
  • ora-13206 : internal error [string] while creating the spatial index
  • ora-39313 : call to DBMS_SCHEMA_COPY.CLONE is not legal
  • ora-27124 : unable to detach from shared memory segment
  • ora-31448 : invalid value for change_source
  • ora-30396 : rewrite equivalence procedures require the COMPATIBLE parameter to be string or greater
  • ora-10906 : Unable to extend segment after insert direct load
  • ora-34871 : (PERMIT06) Session-only value 'value' of workspace object has been deleted because a PERMIT change has revealed a duplicate value.
  • ora-12316 : syntax error in database link's connect string
  • ora-22818 : subquery expressions not allowed here
  • ora-08277 : Cannot set environment variable
  • ora-39171 : Job is experiencing a resumable wait. string
  • ora-31645 : unable to read from dump file "string"
  • ora-02483 : Syntax error in process specification (string)
  • ora-07304 : ksmcsg: illegal redo buffer size.
  • ora-06259 : NETNTT: cannot read from remote process
  • ora-07492 : scgrcl: cannot close lock.
  • ora-22904 : invalid reference to a nested table column
  • ora-16809 : multiple warnings detected for the database
  • ora-33429 : (EIFMAKEF17) CAUTION: NTEXT expression will be exported with type TEXT.
  • ora-24162 : name value pair list is full, cannot add another entry
  • ora-29934 : index specified for association is not a domain index
  • ora-13129 : HHCODE column string not found
  • ora-24085 : operation failed, queue string is invalid
  • ora-08313 : sllfop: could not allocate buffers
  • ora-16722 : unable to set LOG_ARCHIVE_DEST_STATE_n initialization parameters
  • 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.