Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

"ORA-27123: unable to attach to shared memory segment" error

717949Aug 20 2009 — edited Aug 20 2009
Hi,

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 17 2009
Added on Aug 20 2009
5 comments
4,137 views