Re: ORA-07320 error as non-oracle user

I'm receiving the same error message. I checked the permissions on the file below and they seemed to be set correctly. I'm using Oracle 7.3 on Solaris 2.6. I installed it today and I'm trying to set up a new database.

Thanks!!

Amy

In article <35AD5878.5788BAA9_at_nightmare.com>,   Oracle DBA <oracle_at_nightmare.com> wrote:
> James Owens wrote:
>
> James,
>
> Sounds like the "oracle" executable is not setuid.
>
> Go to the ORACLE_HOME/bin directory and check the permissions
> on "oracle"
>
> % ls -l oracle
>
> It should be 6751 or rwsr-s--x
>
> If it is not set to this simply chmod the executable to this. Also
> make sure the directory is not mounted nosetuid. If it is on some
> operating systems the setuid and setgid bit will be set but will take
> no affect.
>
> You get the permission denied usually because the shared memory is
> owned by the user "oracle" or whatever your software owner is and
> when your shadow process is spawned the setid bit makes sure it is done
> as the software owner.
>
> Let me know if this does not fix it,
>
> -Bennett
>
> >
> > Hello all,
> >
> > I am trying to access our Oracle 7.3.3 database on a server that was
> > just built. The server is running Solaris 2.6.
> >
> > As oracle I am able use sqlplus and login as any user.
> > As root or any other user on the system I get the following:
> >
> > ERROR: ORA-01034: ORACLE not available
> > ORA-07320: smsget: shmat error when trying to attach sga.
> > SVR4 Error: 13: Permission denied
> >
> > I'm rather new to the oracle arena being a UNIX admin person but know we
> > have had this problem before. I seem to recall it was a permissions
> > issue on one of the files but cannot remember what our DBA did way back
> > then. He's since left the company so of course, now I am stuck.
> >
> > If anyone has seen this and can help that would be great.
> >
> > Thanks,
> >
> > Jim Owens
> > UNIX System Admin
> > TDS-CS
> > james.owens_at_teldta.com
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Jul 16 1998 - 17:50:48 CDT