Re: Help needed on oracle error

Erwin Joosten wrote:
>
> Can someone help me with the next error message:
>
> ERROR: ORA-01034: ORACLE not available
> ORA-07320: smsget: shmat error when trying to attach sga
> AT&T System V/386 Error: 13: Permission denied.
>
> I'm running oracle 7.0.16 on a SCO UNIX 3.2 server. It occures when i login
> to oracle with just a unix account. when i login as oracle i have no
> problems, which rights must i set to correct this problem.

When this happens on an HP-UX box, the problem "usually" stems from the file protection on the oracle executable in $ORACLE_HOME/bin. The file protection must bet set by "chmod 4755 oracle" so the userid bit is turned on. When set using this command, the file list command shows: -rwsr-s--x oracle.  

Michael

###################################################################
# Michael Abbey           Ottawa ON Canada      613 780 2364
#
# Co-author of:   Tuning Oracle          Oracle: A Beginner's Guide
#                 Oracle Data Warehousing
###################################################################