How to fix the Oracle error ORA-01620: no public threads are available for mounting?

In this post, you’ll learn more about the Oracle ErrorORA-01620: no public threads are available for mounting with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-01620: no public threads are available for mounting

Reason for the Error ORA-01620: no public threads are available for mounting

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

How to fix the Error ORA-01620: no public threads are available for mounting ?

You can fix this error in Oracle by following the below steps

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.