TNS-01174: The sum of the POOL_SIZEs from each PRESPAWN_DESC is greater than the PRESPAWN_MAX
Cause: The minimum value for PRESPAWN_MAX should be the sum of the POOL_SIZEs.
Action: Be sure the parameters required for PRESPAWN_DESC are specified in each SID_DESC. For example, SID_LIST_LISTENER = (SID_LIST=(SID_DESC=(SID_NAME=<sid>)(PRESPAWN_MAX=15)(ORACLE_HOME=<oracle_home>)(PRESPAWN_DESC=(PROTOCOL=tcp)(POOL_SIZE=10)(TIMEOUT=30))(PRESPAWN_DESC=(PROTOCOL=ipc)(POOL_SIZE=5)(TIMEOUT=15)))) Add or correct these parameters in the LISTENER.ORA file
TNS-01175
Custom Search


More Oracle errors
ORA-29310database is not open, or opened as a clone
PGU-41107GROUP within a GROUP not allowed
RMAN-06477configuration value length exceeds 1024
DIA-48469Keyword "string" cannot be duplicated
ORA-19263XQST0043 - duplicate namespace prefix string
ORA-06010NETASY: dialogue file too long
ORA-23537function or procedure string is not allowed to be invoked from this site.
ORA-02705osnpol: polling of communication channel failed
ORA-36670(XSDPART08) workspace object is an INTEGER or NTEXT dimension, or contains an INTEGER or NTEXT dimension. INTEGER and NTEXT dimensions cannot be used as partition dimensions.
ORA-15206duplicate diskgroup string specified
OCI-30130invalid parameter key type received
NNL-01062Cache checkpoint file name: string
ORA-15482failed to create/remove path to volume device file
ORA-23405refresh group number string does not exist
ORA-29935missing FROM keyword
PCC-02383Expecting an expression of type OCIExtProcContext
ORA-08275Environment variable unset
ORA-25022cannot reference a trigger of a different type
DRG-12303cannot add more than 99 indexes to an index set
ORA-39054missing or invalid definition of the SQL output file.




TOP 20 Oracle errors
ORA-12504TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
RMAN-20079full resync from primary database is not done
ORA-14411The DDL cannot be run concurrently with other DDLs
ORA-14760ADD PARTITION is not permitted on Interval partitioned objects
ORA-10877error signaled in parallel recovery slave string
ORA-32701Hang detected
ORA-00838Specified value of MEMORY_TARGET is too small, needs to be at least stringM
ORA-16665timeout waiting for the result from a database
ORA-16957SQL Analyze time limit interrupt
ORA-16664unable to receive the result from a database
RMAN-08132WARNING: cannot update recovery area reclaimable file list
ORA-00000normal, successful completion
ORA-16766Redo Apply is stopped
ORA-00837Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET
RMAN-08137WARNING: archived log not deleted as it is still needed
DIA-48122error with opening the ADR block file [string] [string]
ORA-47988password should contain at least one numeric and one alphabetic character
IMP-00057Warning: Dump file may not contain data of all partitions of this table
ORA-00001unique constraint (string.string) violated
ORA-55508Invalid input to Flashback Transaction Backout




Your own TOP 20 Oracle errors
TNS-01174The sum of the POOL_SIZEs from each PRESPAWN_DESC is greater than the PRESPAWN_MAX