Oracle DBA [message #365157] |
Tue, 13 June 2000 12:24 |
Shan
Messages: 14 Registered: December 1999
|
Junior Member |
|
|
I colud not able run two instance of oracle with two different ORACLE_SID and DataBase. I am using Oracle8i
(8.1.5). For example, I login as "oracle" and set my ORACLE_SID=xyz and start the database in one session. It happens perfectly. After I go to another session and again login as "oracle" with ORACLE_SID=abc. now when try to startup the database, it says, "ORA-27146 post/wait initialization failed". Can you please give a solution?
Thanks in advance...
|
|
|
Re: Oracle DBA [message #365160 is a reply to message #365157] |
Tue, 13 June 2000 18:39 |
Melissa
Messages: 65 Registered: January 2000
|
Member |
|
|
ORA-27146 means that the system is running out of semaphores.
You can either decrease the "processes" parameter in the init.ora file, or increase the kernel setting in /etc/system file. The semamphore parameter is called "semmns".
|
|
|