Oracle 11.1.0 + Solaris 10 10/08 + Database Creation failed

[xunil321]

Dear all,

we have installed Oracle 11.1.0 on a Solaris 10 10/08 T5220 system and
the DB server installs fine.

When we try now to create the database by dbca the following errors
at the "Completing Database Creation" step were seen:

ORA-12801: error signaled in parallel query server P073.
ORA-00018: maximum number of sessions exceeded
ORA-06512: at "SYS.UTL_RECOMP", line 629
ORA-06512: at "SYS.UTL_RECOMP", line 671
ORA-06512: at line 1

We learnt from the net that an increase of the SESSIONS / PROCESSES
parameters in the init.ora file should help us.
Regardless which number for these parameters we used
(PROCESSES = 1000 or 5000 or 10000) the errors above still occured.

We turned also off parallelism but without success!

Is this a bug and/or is there any other method to create the database
without any errors?

THX,
Rainer

 

[Annihilannic]

Typically with Oracle there are a whole bunch of prerequisite ulimits you have to increase such as number of processes, number of open file handles, etc. Have you done that?

Annihilannic.

 

[cryptoadm]

You have setup parallel processing and blew out the max allowed processes (upir 'sessions' parameter).

 

[xunil321]

THX for the help. I put the "sessions" parameter in the
$ORACLE_HOME/assistants/dbca/templates/General_Purpose.dbc
file and now it is perfect.

By the way:
I tried also to install 11.1.0 on a Sun with only 4gb RAM
under Solaris 10 10/08. I got the error

ORA-27102 Out of Memory

Does this mean that we need more physical RAM now?

Rainer

 

[Mike042]

Does this mean that we need more physical RAM now?
No. You have run out of 'shared memory'.

A Google search for: "ORA-27102 Out of Memory"
produced several thousand suggestions. This looks like a good one:

http://technopark02.blogspot.com/2006/09/solaris-10oracle-fixing-ora-27102-out.html

I hope that helps.

Mike

 

[xunil321]

@Mike:
THX I got it by reducing the SGA parameter.

Rainer