Quickly resolve Oracle Database errors with Oracle Doctor

Oracle Database Error ORA-01620

ORA-01620 no public threads are available for mounting

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.

ORA-01620 Comments

No comments yet

Submit comments and questions for ORA-01620

No registration required

CAPTCHA Image New word