Re: ORA-07320 error as non-oracle user

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
Received on Wed Jul 15 1998 - 20:33:44 CDT