Instance won't start

[DQuinn]

Hi,

This Morning:

I have a server with 3 instances running(I can access all instances).

This Afternoon:

Tried to create a new instance but get the Oracle not available error.
UNIX admin jacks up max number of processes and users, I can then create new instance.

When doing a shutdown/startup, one of the instances I was able to access in the morning did not start. Tried to start manually but get

ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist

What other parameters should I be looking at on the UNIX side?

BTW...Connecting as internal and issuing a startup command gives me a

SQL> startup
ORA-24323: value not allowed
ORA-03113: end-of-file on communication channel

error.

Can anybody help?

Thanks

[DQuinn]

OOPS..

Forgot to specify...

Oracle 8.1.7 on UNIX 11.0

Thanks

[Calvin_Qiu]

And the Shared Memory and Semaphore setting in /etc/system?

[pravin]

actually u have to see

what is total memory of ur o/s
Since u say that there are 3 instances running - check the sga size.
Keep some memory free for o/s process, working.

also check the shared Memory and semaphore setting in /etc/system

[DQuinn]

Here are some of the parameters:

maxuprc 200
maxusers 251
shmmax 1073741824
shmmni 100
shmseg 10

semmni 70
semmns 200

Any other important information missing?

What do these parameters do?

I am new on UNIX so these are all new to me.


Thanks

[jovery]

Check out the installation guide for your platform, it will explain the parameters you require and how to calculate the values.

http://technet.oracle.com/docs/produ...i/content.html

Regards

[DQuinn]

I read that..

They really don't say much about setting the semaphores except for saying that the values should be 70 for semmni and 200 for semmns.

Seems that this is still not enough.

Are these numbers per instance? They don't say.

Oracle should specify a "rule of thumb" method for calculating number of semaphores.

[prakashs43]

I think the sum of the existing instances SGA + new instance's SGA and other parameters are exceeding the Operating system allocated resources fro oracle .

try to adjust the either kernel prameters or init.ora parameters of all the instances to fit into the system resource limits .

I guess ur earlier instances might be still working
u can check this by shutting down other instances and starting the enw instance which u have created .