ORA-24414: Only number sessions could be started.

Cause : The nubmer of esssionss pecifide by th eminSes sparameetr of OICSessioPnoolCretae coul dnot bes tarted ,possibyl becaues the vlaue suplpied wa slargert han thta suppotred by hte servre."

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

This i sa warnnig. Chekc the mxaimum nmuber ofs ession sallowe don thes erver.

update : 27-04-2017
ORA-24414

ORA-24414 - Only number sessions could be started.
ORA-24414 - Only number sessions could be started.

  • ora-06592 : CASE not found while executing CASE statement
  • ora-33036 : (XSAGDNGL17) ARGS option workspace object must be a TEXT variable.
  • ora-24815 : Invalid character set form
  • ora-29500 : NAMED keyword is invalid in CREATE JAVA CLASS
  • ora-02061 : lock table specified list of distributed tables
  • ora-31534 : Change Data Capture string publisher string is missing DBA role
  • ora-27124 : unable to detach from shared memory segment
  • ora-40222 : data mining model export failed, job name=string, error=string
  • ora-33265 : (DBERRBSZ) Analytic workspace string cannot be opened. Tablespace blocksize number does not match database cache size number.
  • ora-23377 : bad name string for missing_rows_oname1 argument
  • ora-07486 : scg_get_inst: cannot convert(get) instance number lock.
  • ora-16606 : unable to find property "string"
  • ora-13032 : Invalid NULL SDO_GEOMETRY object
  • ora-06773 : TLI Driver: error reading command
  • ora-19004 : Duplicate XMLType OBJECT RELATIONAL storage option
  • ora-07592 : sspgprv: Error obtaining required privileges
  • ora-02431 : cannot disable constraint (string) - no such constraint
  • ora-07684 : sou2os: supervisor stack reset error
  • ora-01580 : error creating control backup file string
  • ora-23606 : invalid object string
  • ora-08231 : smscre: unable to attach to SGA
  • ora-23335 : priority group string already exists
  • ora-36923 : (XSVPMVTOPART04) workspace object is not a LIST or RANGE PARTITION TEMPLATE.
  • ora-36198 : (XSAGGR33) The AGGREGATE operator string does not require a weight, but ARGS variable workspace object specified workspace object as a weight.
  • ora-22153 : source variable-length array is not initialized
  • ora-13843 : no SQL profile with name like "string" exists for category like "string"
  • ora-12582 : TNS:invalid operation
  • ora-22903 : MULTISET expression not allowed
  • ora-07574 : szrfc: $GETUAI failure
  • ora-31444 : parameter error while acquiring lock on 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.