Re: shmat error when trying to attach sga

"Imel Rautenbach" <imel_at_iafrica.com> writes:

> I get this when running sqlplus on hp-ux on Oracle 7.3.3 as a user not in
> the dba group.
>
> I presume i need to change rights for all users to access the database.
Nope. What you need to the following:

chmod 4755 $ORACLE_HOME/bin/oracle

The problem is that the SGA is created as owned by the oracle user. When the client connects, it connects under its own user ID so it can't access the SGA.

-- 
                                Rick
                                Rick Wessman
                                Oracle Corporation
                                rwessman_at_us.oracle.com