ORA-01620: no public threads are available for mounting

Answer Posted / guest

Cause: The INIT.ORA parameter "thread" is zero, its default
value. There are no threads which have been publicly
enabled, and not mounted.

Action: Shutdown the instance, change the INIT.ORA parameter
to a thread which is privately enabled and not mounted. If
the database is open in another instance, then a thread may
be publicly enabled.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

ORA-26079: file "string" is not part of table string.string

1711


ORA-26094: stream format error: input column overflow

2563


ORA-16626: failed to enable specified object

1990


ORA-16516: The current state is invalid for the attempted operation.

8445


ORA-26028: index string.string initially in unusable state

3627


IMP-00060: Warning: Skipping table "string"."string" because object type "string"."string" does not exist or has different identifier

2938


when i ran any workflow or session, getting below error: seesion task instance[s_xxx]: Execution terminated unexpecterdly

1972


ORA-26076: cannot set or reset value after direct path structure is allocated

1690


invalid quantity specification negative quantity are not allowed for this item please check this item definition quantity

3124


In my project I am using star schema and only diimension tables are loaded and not fact tables any one can help me why it is happening? Plase guide me.

2568


IMG-02003: 2FF03 - incorrect color histogram feature specification

1435


ORA-26082: load of overlapping segments on table string.string is not allowed

1550


IMP-00064: Definition of LOB was truncated by export

6138


ORA-26030: index string.string had string partitions made unusable due to:

1725


IMP-00096: Warning: Skipping table "string"."string" because type synonym "string"."string" cannot be created

1412