Oracle DB Error ORA-01620 no public threads are available for mounting

Oracle DB Error ORA-01620 no public threads are available for mounting

The following is the cause of this error:

The value of the initialization parameter THREAD is zero, its default value. There are no threads which have been publicly enabled, and not mounted.

Action you can take to resolve this issue: Shut down the instance, change the value of the initialization 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.


Tags: Database, Education, Software




Disclaimer:Pak/ed and the contributors are not responsible for any errors contained and are not liable for any damages resulting from the use of this material.  Disclaimer


Related

Home      Disclaimer      Advertise      Contact      Privacy Policy     

Copyright © 2004-16 Paked.com. All rights reserved.

Note: Site best viewed at 1024 x 768 or higher screen resolution