Oracle DBA, How To, Error, Cause and Action

ORA-01620: no public threads are available for mounting

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.