Home » RDBMS Server » Server Administration » Oracle DBA
Oracle DBA [message #365157] Tue, 13 June 2000 12:24 Go to next message
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 Go to previous message
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".
Previous Topic: CPU Bound machine
Next Topic: Oracle 8 rowid
Goto Forum:
  


Current Time: Thu Mar 28 12:00:32 CDT 2024