ORA-27145: insufficient resources for requested number of processes

Cause : OS system call error

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

check errno and contact Oracle Support

update : 25-04-2017
ORA-27145

ORA-27145 - insufficient resources for requested number of processes
ORA-27145 - insufficient resources for requested number of processes

  • ora-29386 : plan or consumer group string is mandatory and cannot be deleted or modified
  • ora-02293 : cannot validate (string.string) - check constraint violated
  • ora-38501 : sub-query not allowed in the expression
  • ora-40205 : invalid setting name string
  • ora-30047 : Internal event for kti tracing
  • ora-27067 : size of I/O buffer is invalid
  • ora-19806 : cannot make duplex backups in recovery area
  • ora-07587 : spdcr: $CREPRC failure
  • ora-12442 : policy column "string" already used by an existing policy
  • ora-39020 : invalid mode type string
  • ora-15043 : ASM disk "string" is not a diskgroup member
  • ora-32621 : illegal aggregation in UNTIL iteration condition
  • ora-02351 : internal error: string
  • ora-40219 : apply result table string is incompatible with current operation
  • ora-29296 : invalid encoded string
  • ora-28653 : tables must both be index-organized
  • ora-03247 : Invalid block number specified
  • ora-16021 : session string destination cannot be the same as session string destination
  • ora-02793 : Close of asynchronous I/O failed.
  • ora-28172 : distinguished name not provided by proxy
  • ora-38103 : Invalid column in the UPDATE SET Clause: string
  • ora-02754 : osnfsmmap: cannot change shared memory inheritence
  • ora-40289 : duplicate attributes provided for data mining function
  • ora-12532 : TNS:invalid argument
  • ora-29256 : Cursor contains both regular and array defines which is illegal
  • ora-13390 : error in spatial analysis and mining function: [string]
  • ora-29855 : error occurred in the execution of ODCIINDEXCREATE routine
  • ora-15018 : diskgroup cannot be created
  • ora-14306 : List value 'string' specified twice in partitions 'string', 'string'
  • ora-29304 : tablespace 'string' does not exist
  • 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.