no public threads are available for mounting ORA1620 error

From: Chi-Wai <dleung_at_hill.ucr.edu>
Date: 4 Jun 1998 17:44:23 -0700
Message-ID: <6l7f17$8hs$1@hill.ucr.edu>

Hi All,

I have the following error
when I try to create a new set of new controlfile.

The reason why I want to recreate controlfile is: I was to increase MAXDATAFILES to 300.
I know how to recreate controlfile, I did it before. Everytime it works except, this time, I am suspecting the machine is too overloaded with too many instances.

When I do:

SVRMGR> connect internal
Connected to an idle instance.
SVRMGR> @create_control_file
ORACLE instance started.

Total System Global Area      26375600 bytes
Fixed Size                       39696 bytes
Variable Size                  9788064 bytes
Database Buffers              16384000 bytes
Redo Buffers                    163840 bytes

CREATE CONTROLFILE DATABASE "DATAWHSE" NORESETLOGS NOARCHIVELOG *

ORA-01503: CREATE CONTROLFILE failed
ORA-01620: no public threads are available for mounting
ORA-01507: database not mounted

ALTER DATABASE OPEN

THe problem is error ORA-01620
This machine is an Ultra Sparc 2 with 1 gig memory with
/etc/system file look like:

And it has 4 oracle instances running already with 100 SQLNET connections. Is the MACHINE ALREADY has too much load , that it can't handle one more instance anymore?

set shmsys:shminfo_shmmax=268435456
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=500
set shmsys:shminfo_shmseg=500
set semsys:seminfo_semmns=1800
set semsys:seminfo_semmni=4096
---------------------------------------------------------------

WHen I do oerr ora 1620
I got the following:

01620, 00000, "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.

If anyone knows what should I do,
please let me know?

Thank you in advance,

Please dleung_at_cncx.com

Dominica Leung Received on Thu Jun 04 1998 - 19:44:23 CDT