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 : 21-08-2017
ORA-24414

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

  • ora-30656 : column type not supported on external organized table
  • ora-23427 : deferred purge queue argument string out of range
  • ora-32051 : mapping service not available
  • ora-22931 : MOVE of nested table to a different tablespace not supported
  • ora-02765 : Invalid maximum number of servers
  • ora-23399 : generation of replication support for "string"."string" is not complete
  • ora-01663 : the contents of tablespace 'string' is constantly changing
  • ora-30189 : reserved for future use
  • ora-32503 : Mapping SGA from file failed
  • ora-01185 : logfile group number string is invalid
  • ora-01286 : start interval required
  • ora-28140 : Invalid column specified
  • ora-24329 : invalid character set identifier
  • ora-29951 : warning in the execution of ODCIINDEXSPLITPARTITION routine
  • ora-01923 : CASCADE aborted, objects locked by another user
  • ora-07759 : slemtr: invalid destination
  • ora-13006 : the specified cell number is invalid
  • ora-16036 : invalid MANAGED recovery CANCEL option
  • ora-22153 : source variable-length array is not initialized
  • ora-26027 : unique index string.string partition string initially in unusable state
  • ora-22054 : underflow error
  • ora-02299 : cannot validate (string.string) - duplicate keys found
  • ora-07487 : scg_init_lm: cannot create lock manager instance.
  • ora-24363 : measurements in characters illegal here
  • ora-24192 : the property name cannot be null
  • ora-36268 : (XSCGMDLAGG01) 'string' is not a valid dimension value.
  • ora-02158 : invalid CREATE INDEX option
  • ora-14096 : tables in ALTER TABLE EXCHANGE PARTITION must have the same number of columns
  • ora-06932 : CMX: error in local name
  • ora-23301 : mixed use of deferred rpc destination modes
  • 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.