"ORA-27123: unable to attach to shared memory segment" error
717949Aug 20 2009 — edited Aug 20 2009Hi,
I have oracle db installed(by using Oracle template) as user "oracle", and when I tried to start the oracle instance as another user (required by the benchmark) "abc", I got ORA-27123 error:
sql>startup pfile = <ORACLE_HOME>/dbs/inittest.ora"
"ORA-27123: unable to attach to shared memory segment"
I think this is because all the files under <ORACLE_HOME> owned by "oracle" user with 755 permission, so for user "abc", it doesn't have the write permission. Can I change the permission of oracle files to be 777 to solve this error?
Another newbie question, if I have "init.ora" and "inittest.ora" under <ORACLE_HOME>/dbs, if I start oracle using "<sql>startup", will it read the setting of "inittest.ora" or "init.ora"? ($ORACLE_SID=test)
thanks,
jenny