4 réponses
Kuching
Messages postés
2702
Date d'inscription
jeudi 30 mai 2002
Statut
Contributeur
Dernière intervention
26 décembre 2007
157
6 févr. 2003 à 09:53
6 févr. 2003 à 09:53
Salut,
Ici:http:home.planet.nl/~heuve345/databases/oracleq.html
Il y a:
Installing and Starting Oracle
Q: I try to startup an instance, but I get the error message indicating that there are no semaphores available (e.g. ORA-07279).
A: By default each Oracle instance requires 50 semaphores. You can check this by executing:
ipcs -a
You can set the numbers of semaphores in the file init<sid>.ora. Change the value of PROCESSES. The default value is 50. Change it to: 6 + maximum number of concurrent connections.
So to solve the problem, shutdown unneeded instances, or decrease the number of PROCESSES of each instance.
If you can’t shutdown instances and/or reduce the number of PROCESSES, you have to rebuild the kernel with more semaphores.
Ca t'aide?
A+ K.
Ici:http:home.planet.nl/~heuve345/databases/oracleq.html
Il y a:
Installing and Starting Oracle
Q: I try to startup an instance, but I get the error message indicating that there are no semaphores available (e.g. ORA-07279).
A: By default each Oracle instance requires 50 semaphores. You can check this by executing:
ipcs -a
You can set the numbers of semaphores in the file init<sid>.ora. Change the value of PROCESSES. The default value is 50. Change it to: 6 + maximum number of concurrent connections.
So to solve the problem, shutdown unneeded instances, or decrease the number of PROCESSES of each instance.
If you can’t shutdown instances and/or reduce the number of PROCESSES, you have to rebuild the kernel with more semaphores.
Ca t'aide?
A+ K.